Aug-14-2017, 06:11 PM
(This post was last modified: Aug-14-2017, 06:11 PM by AngelRuizM.)
Hi,
I´m really new using Python. But I have to solve a problem to make the analysis of my scientific data.
I have two excel files with different data:
The first one contains results of my experiments and has 6 different columns, which the second one corresponds to ID of my probe. Each probe appears 9 times because of the replicates (one replicate on each row),17109 rows total.
The second file contains many properties of each single probe, starting with ID of the probe in column one and 11 columns total length.
I want to copy the properties info of the second file in column 7 onwards of file one.
I would like to know if there is a Python script which can do that. I mean:
1) Read the probe ID in row 1 in file one
2) Seek that probe in file two
3) Select all the properties (one row, 11 columns) of file two and copy it
4) Paste all that information in file one on column 7 onwards
5) Read the probe ID in row 2 in file one...
and repeat the process for all rows in the file one.
I will appreciate your help.
Best regards
I´m really new using Python. But I have to solve a problem to make the analysis of my scientific data.
I have two excel files with different data:
The first one contains results of my experiments and has 6 different columns, which the second one corresponds to ID of my probe. Each probe appears 9 times because of the replicates (one replicate on each row),17109 rows total.
The second file contains many properties of each single probe, starting with ID of the probe in column one and 11 columns total length.
I want to copy the properties info of the second file in column 7 onwards of file one.
I would like to know if there is a Python script which can do that. I mean:
1) Read the probe ID in row 1 in file one
2) Seek that probe in file two
3) Select all the properties (one row, 11 columns) of file two and copy it
4) Paste all that information in file one on column 7 onwards
5) Read the probe ID in row 2 in file one...
and repeat the process for all rows in the file one.
I will appreciate your help.
Best regards
my code here