DataHarmonizer (Professor’s Spreadsheet Standardizer) is a Python program designed to streamline administrative tasks for college professors. When professors receive diverse Excel spreadsheets containing student data (such as grades, attendance, or assignments), this program automatically standardizes the data into a consistent template. By identifying common columns and creating uniform spreadsheets, it simplifies subsequent data analysis.
The motivation behind this project is to empower professors with a hands-off solution. Professors can simply place their spreadsheets in the designated input folder, run the program, and obtain standardized output files. This consistency not only facilitates data analysis but also reduces the risk of errors or discrepancies. Whether dealing with column-based or row-based spreadsheets, the DataHarmonizer (Professor’s Spreadsheet Standardizer) ensures efficiency and accuracy in administrative workflows.
Feel free to customize this summary further to match your project’s specifics. If you need additional details or have any other remarks, feel free to ask via email! 🚀
Special thanks to Dr. Leila Issa of LAU’s Department of Mathematics for her support and inspiration throughout this project. 🙌