Reformats data for 384-well-plate screen to be better suited for plotting
- This README
- A copy of the MIT License
- requirements.txt, for quick install
- simplified-melt-data-test.xlsx, a sample input file to see formatting of input data
- simplified-melt-data-test-out.xlsx, a sample output file to see what formatting of output data will look like
- pivot_wellplate_data.py, the python script that will turn the input into the output
- Download the repository
- Make a new virtual environment
- Install requirements
- Add your files to the folder the script is in (input and output)
- Run the script
All things in curly brackets can be replaced with the relevant file name etc.
- Download the repository (green button on main page)
- Put the folder somewhere convenient, probably in a folder that doesn't have spaces in its name or your desktop
- Open Terminal, navigate to that folder (use "cd {directory name}" to go to a particular folder, use "ls" to list what is in the folder you are currently in, use "pwd" to get the path to the folder you're currently in)
- Navigate into the folder you downloaded
- Make a new virtual environment (type "python3 -m venv {virtual environment name}")
- Activate your new virtual environment (type "source {virtual environment name}/bin/activate")
- Make sure you can run the python script (type "chmod +x pivot_wellplate_data.py")
- Use pip to install the requirements file (type "pip install -r requirements.txt")
At this point you should be set! To test your setup, you can use the sample file and the run instructions (move sample file to the same folder as the python script and make a new output folder)
python3 pivot_wellplate_data.py {input file name} {raw output file name} {processed output file name}
You will see file read and file written messages print to the command line as the script runs
Recommendation: name the files without spaces to avoid issues Input files should be Excel files This script will only work if you have complete columns (although you don't need a full plate's worth of data) There should be 3 columns: Well Position, Temperature, Fluorescence (modify the script if you are repurposing for other data, this was written for thermal stability) Well Position should be in letter number format (e.g. A1, B2, etc)
Designed for thermal shift, normalizes each well to its max and min reading (reading-min)/(max-min)
Output files should be empty excel files, saved with names
Put both files in the same folder as the python script and you're good to run!