Year
2023
Role
Full Stack
Type
Program
Highlight
After visiting the lab to see how data was measured and how students used the equipment, I realized their workflow could be much smoother. I set out to build a Python program that would automatically process raw data into a format they could use right away.
At first, I wrote it as a simple script, but I soon saw the need for a user-friendly interface. That’s when I discovered tkinter, a popular Python GUI library, and used it to turn my backend logic into an intuitive tool that made the students’ work far easier.
What does the program do?
The program processes raw files from VitaView 6.0 and automatically separates data for each test rat, exporting them into individual Excel files—no matter how many files are imported at once. Users can customize the output by selecting the file type, time bin, and grouping method. The group option lets them choose between separating data for each rat individually or combining it for all rats.
Even though each raw file may contain a different number of rats with unique ID names, the program accurately detects and matches these IDs, ensuring every file is exported correctly with the proper name.
