🗄️Final Spreadsheet creation

Final spreadsheet creation by merging multiple file by the same ID, ID_Sample

To create a final spreadsheet, linking the donor/sample information with the positivity rates of the antibodies within specific regions, we are again working in GitBash and calling a python file.

1. Download the merger from here. Click on download raw file.

2. Create a Data_output-all folder containing the subelements:

Immunopositivity

This folder contains all the data_output files from the different antibodies. Just copy them from the folder generated in the previous step.

merger

merger is the python file that is used to merge the data. In the previous step, you downloaded the file so that you can relocate it from the downloads to the data_output_all folder.

Sample_Information

This an Excel sheet containing the donor information linked to the ID_Sample. The information stored within the file can be chosen freely, however, the ID_Sample is necessary to later on merge all the files.

organisation of the folder to perform merging to a final spreadsheet

Open Git Bash:

To open Git Bash search for it on your computer Menu and double-click on the icon to open. A standard prompt window will open.

1. Open the Data_output_all Folder

   You can open the Data_output-all Folder from the terminal using the command cd.

cd Path/To/Data_output_all

Launch the merger from the terminal

From the same Git Bash terminal, the Python script is going to be launched.

python merger.py Path/To/Data_output_all/Sample_Information.xlsx Path/To/Data_output_all/Immunopositivity MergedFile.csv

The MergedFile is your new output file, containing all the information of the donor/sample merged together with the positivity rate for each region, antibody and sample.

An examples for a final MergedFile