Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Aligning data
#1
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.
Reply


Messages In This Thread
Aligning data - by gat - Jun-17-2019, 03:37 PM
RE: Aligning data (sorry) :( - by DeaD_EyE - Jun-17-2019, 04:14 PM
RE: Aligning data (sorry) :( - by gat - Jun-18-2019, 09:22 PM
RE: Aligning data (sorry) :( - by Ecniv - Jun-17-2019, 06:25 PM
RE: Aligning data (sorry) :( - by gat - Jun-18-2019, 06:34 PM
RE: Aligning data (sorry) :( - by Ecniv - Jun-18-2019, 07:07 PM
RE: Aligning data - by vindo - Jun-19-2019, 02:12 PM
RE: Aligning data - by gat - Jun-19-2019, 02:49 PM
RE: Aligning data - by Ecniv - Jun-20-2019, 03:23 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Aligning excel data gat 1 2,243 Jun-17-2019, 07:05 PM
Last Post: michalmonday

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020