Excel Automation

This is a collection of Python automation scripts to help me with the data analysis for my research project on Cognitive Load.

• View GitHub Repository
• Download Automation Scripts

Background

Each participant was required to play two versions of a game. For each version, they needed to play the game three times. In total, one participant had 6 excel files. In total there were 40 participants. 40*6 = 240 excel files. This is a very time consuming process so my partner suggested to automate this process.

Data Analysis Script

This script does simple analysis and maths calculations on the data. My partner initially created the script which is stored in this Github repository. Since then, this script has been modified to include new summary tables and maths calculations. It calculates things such as:

• Finding the average reaction times at specific times in the game
• Calculating the total crashes within a specific timeframe during the gameplay (eg, between 10-20 seconds)
• Calculating the Standard Deviation and Averages of the player's response times, and DRT misses

Clean Data

I created this to delete some columns in the excel files that were unecessary.

The Template

The template was created so it was easier to create more automated scripts in the future. The template asks the user for a folder that stores excel files, and loops through each excel file in the folder, and prints any details.

Tech Stack

• Python Script