Hello. I'm so sorry in advance. I am super new to this. If this question isn't allowed, please discard. I have something as follows:
sample001a.com, -12, sample002b.com, -16, sample002c.com, -18
sample002a.com, -14, sample003b.com, -16, sample004c.com, -22
sample003a.com, -16, sample004b.com, -20, sample005c.com, -16
sample004a.com, -18, sample005b.com, -14
sample005a.com, -12
So far, I have had to manually sort the data in excel like this:
sample002a.com, -14, sample002b.com, -16, sample002c.com, -18
sample003a.com, -16, sample003b.com, -16, sample004c.com, -22
sample005a.com, -12, sample005b.com, -14, sample005c.com, -16
sample004a.com, -18, sample004b.com, -20,
sample005a.com, -12
As you can see the data is sorted by sample number, prioritizing matches with the last data set. I'm pretty new to python only having had a brief introduction to numpy and pandas. I was wondering if anyone had any lead on where to start here.
sample001a.com, -12, sample002b.com, -16, sample002c.com, -18
sample002a.com, -14, sample003b.com, -16, sample004c.com, -22
sample003a.com, -16, sample004b.com, -20, sample005c.com, -16
sample004a.com, -18, sample005b.com, -14
sample005a.com, -12
So far, I have had to manually sort the data in excel like this:
sample002a.com, -14, sample002b.com, -16, sample002c.com, -18
sample003a.com, -16, sample003b.com, -16, sample004c.com, -22
sample005a.com, -12, sample005b.com, -14, sample005c.com, -16
sample004a.com, -18, sample004b.com, -20,
sample005a.com, -12
As you can see the data is sorted by sample number, prioritizing matches with the last data set. I'm pretty new to python only having had a brief introduction to numpy and pandas. I was wondering if anyone had any lead on where to start here.