# you can do this instead with indexing
Hey! Thank you so much for your helpful response. When I copy and run this code, though, I get the following:
('sample002c.com', -18, 'sample002b.com', -16, 'sample001a.com', -12)
('sample004c.com', -22, 'sample003b.com', -16, 'sample002a.com', -14)
('sample004b.com', -20, 'sample003a.com', -16, 'sample005c.com', -16)
('sample004a.com', -18, 'sample005b.com', -14)
('sample005a.com', -12)
Perhaps I have messed something up. It looks a bit jumbled. So far, I've been importing the data via excel as a data frame. I am a little unclear as to what the zip function is doing in this loop. I think I'm supposed to be "zipping" columns instead of rows maybe? So far I have been importing this data as a dataframe and then modifying it to have merged columns, each containing of the name married to the value:
A B C
0 (sample0001a.com, -12) (sample0002b.com, -16.0) (sample0002c.com, -18.0)
1 (sample0002a.com, -14) (sample0002b.com, -16.0) (sample0004c.com, -22.0)
2 (sample0003a.com, -16) (sample0003b.com, -20.0) (sample0005c.com, -16.0)
3 (sample0004a.com, -18) (sample0004b.com, -14.0) (nan, nan)
4 (sample0005a.com, -12) (nan, nan) (nan, nan
The structure of the function you posted seems helpful, but I think my lack of understanding is preventing me from effectively modifying it.
Agh I realized I posted my question wrong at the very beginning.I am so sorry to anyone involved.
I'm trying to align the sample numbers like so:
sample002a.com, -14, sample002b.com, -16, sample002c.com, -18
sample004a.com, -18, sample004b.com, -20 sample004c.com, -22
sample005a.com, -12, sample005b.com, -14, sample005c.com, -16
sample003a.com, -16, sample003b.com, -16
sample001a.com, -12
I have imported the data and split the string of the sample name into an integer and a letter but am still struggling to systematically move cells based on the integer similarity.
Hey! Thank you so much for your helpful response. When I copy and run this code, though, I get the following:
('sample002c.com', -18, 'sample002b.com', -16, 'sample001a.com', -12)
('sample004c.com', -22, 'sample003b.com', -16, 'sample002a.com', -14)
('sample004b.com', -20, 'sample003a.com', -16, 'sample005c.com', -16)
('sample004a.com', -18, 'sample005b.com', -14)
('sample005a.com', -12)
Perhaps I have messed something up. It looks a bit jumbled. So far, I've been importing the data via excel as a data frame. I am a little unclear as to what the zip function is doing in this loop. I think I'm supposed to be "zipping" columns instead of rows maybe? So far I have been importing this data as a dataframe and then modifying it to have merged columns, each containing of the name married to the value:
A B C
0 (sample0001a.com, -12) (sample0002b.com, -16.0) (sample0002c.com, -18.0)
1 (sample0002a.com, -14) (sample0002b.com, -16.0) (sample0004c.com, -22.0)
2 (sample0003a.com, -16) (sample0003b.com, -20.0) (sample0005c.com, -16.0)
3 (sample0004a.com, -18) (sample0004b.com, -14.0) (nan, nan)
4 (sample0005a.com, -12) (nan, nan) (nan, nan
The structure of the function you posted seems helpful, but I think my lack of understanding is preventing me from effectively modifying it.
Agh I realized I posted my question wrong at the very beginning.I am so sorry to anyone involved.
I'm trying to align the sample numbers like so:
sample002a.com, -14, sample002b.com, -16, sample002c.com, -18
sample004a.com, -18, sample004b.com, -20 sample004c.com, -22
sample005a.com, -12, sample005b.com, -14, sample005c.com, -16
sample003a.com, -16, sample003b.com, -16
sample001a.com, -12
I have imported the data and split the string of the sample name into an integer and a letter but am still struggling to systematically move cells based on the integer similarity.