Avatar of Isaiah Melendez
Isaiah Melendez
 asked on

How can I sort multiple Python lists based on the sort applied to one list?

I have a list of lists in Python that essentially represent a table. I know I should have used a pandas dataframe to accomplish this, but hindsight is 20/20. I digress...below is an example list of what I'm talking about.

The overarching list variable is comprised of these nested lists:

['Store number', 2, 3, 4, 1, 5]
['Variable 1', 82, 99, 44, 32, 65]
['String 1', 'cat', 'dog', 'lizard', 'alligator', 'crocodile']

In the current state, each index of each nested list corresponds to the same row in the table. So for store number 2, variable 1 is 82 and string 1 is cat. Say I want to sort each list to where these relationships are maintained, but we sort by ascending store number. The final lists would look like:

['Store number', 1, 2, 3, 4, 5]
['Variable 1', 32, 82, 99, 44, 65]
['String 1', 'alligator', 'cat', 'dog', 'lizard', 'crocodile']

How could I accomplish this using my current data structures?
* python3ProgrammingPython* data structures

Avatar of undefined
Last Comment
Norie

8/22/2022 - Mon
dpearson

You have two options.  
a) You can add a data structure that links these lists together (e.g. a list of maps that connect up the entries) and then sort that based on the first field.  But it sounds like you don't want to add days structures.

b) You can implement a simple sort and when this sort moves an item in the first list, you move the matching ones.

E.g. Bubble sort is a very simple sort to implement.  You just loop through all items in the list and compare n to n+1.  If the two items aren't in the correct order you swap them (and in your case swap the items in the other two lists as well at the same positions).  You also record that a swap was made (just a boolean flag).

Then after going through the whole list, check to see if any swaps were made.  If some were swapped, repeat the whole process.  If not, the list (and the matching ones) will all now be sorted.

It's not the fastest sort, but it is simple to implement and will solve this problem.
noci

You mention you use pandas.... So why not use the padas sorting functions for dataframes:
See: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.sort_values.html
ASKER CERTIFIED SOLUTION
Norie

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy