After requesting lab data, I was invited into the actual laboratory to thoroughly investigate and observe how the data was measured and how the students were using the machine and program. This led to the creation of a program that automatically transforms the raw data to meet the needs of the graduate students to make them more comfortable with the data.

During the laboratory tour, I roughly envisioned how the program should work in my mind. So, when I started the project, I simply started developing a Python program without any GUI, assuming that students would be able to use it. However, no matter how well I develop the program, I realized that it shouldn’t be difficult for students to use. Therefore, I decided to study Python GUI libraries to create a better program.

Since it was my first time learning a Python GUI library, I did a simple search and came across tkinter, a most popular Python GUI library, so I decided to use tkinter for this project.

What does the program actually do?

original format from the machine

No matter how many raw files (from VitaView 6.0) are imported, the software will automatically separate each test rat ID and export the data into individual Excel files. Moreover, in the current version, users have the flexibility to choose various options, such as file type, time bin, and group. The “group” option allows users to decide whether they prefer the data to be separated by each individual rat or collectively for all rats.

For each raw file, it is feasible, but keep in mind that nearly every file may have a different number of rats and unique ID names. Nevertheless, the program is designed to accurately read the varying numbers of rats and their corresponding IDs, ensuring that the files are correctly exported with their respective file names.

More functions

1. Injection Time Selection

When generating the program, it will initiate the file export process right away. However, upon further consideration, it has been determined that an additional step before the actual file export would be beneficial. When users import their files and select the desired options, the program will perform the same procedures. However, before finalizing the export, the program will prompt the user to input the injection time for each read rat
EX) F410 (ACSF): insert injected time F412 (AMYLIN): insert injected time

2. Null value in Temperature and Activity Data.

[Linear Regression]
SGD Epoch = 5000
Learning Rate= 0.001
Test Ratio = 70:30