🗄️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.
Download the merger from here. Click on
download raw file.Create a Data_output-all folder containing the subelements:
This folder contains all the data_output files from the different antibodies. Just copy them from the folder generated in the previous step.
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.
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.
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.
Open the Data_output_all Folder
You can open the Data_output-all Folder from the terminal using the command cd.
Launch the merger from the terminal
From the same Git Bash terminal, the Python script is going to be launched.
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.
Last updated