Jun-19-2019, 02:12 PM
(Jun-17-2019, 03:37 PM)gat Wrote: 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.
Hi ..
I am also pretty new to python. While is continue to learn from some tutorial. I also browse some new topics in this EXCELLENT forum with a great knowledgeable gurus and learn from them as well.
I was trying to understand your problem statement but for some reason i could not quite get what you are trying to achieve.
May be dumb but some questions,
1) I see you have "sample001a.com" in the sample set, but your expected set does not have it.
2) Is your second set the expectation of the outcome ?