Python sort list of DataFrames on first column

Question

I have a list of DataFrames where I am outputting just the column names for each. I am able to sort each DataFrame by column name, but I also want to sort the list itself based on the name of the first column in each DataFrame. I've searched around but can't find what the appropriate key for sorted() would be.


for df in df_list:
        df = df.reindex(sorted(df.columns), axis=1)

sorted_dflist = sorted(df_list, key = ???)

My Output: 
( 3  4  5  8 11 12)( 7 10)( 1  6  9 13 14)(2)

Expected Output: 
( 1  6  9 13 14)(2)( 3  4  5  8 11 12)( 7 10)

Possible duplicate of How to sort a list of lists by a specific index of the inner list? — Yuca
– Yuca, Commented Nov 27, 2019 at 21:31

Valdi_Bo · Accepted Answer · 2019-11-27 21:47:23Z

2

As I understood, the sort criterion is the first element in the first column of each DataFrame. To sort this way, try the following code:

sorted_dflist = sorted(df_list, key = lambda x: x.iloc[0,0])

To sort by the name of the first column, run:

sorted_dflist = sorted(df_list, key = lambda x: x.columns[0])

edited Nov 27, 2019 at 21:47

answered Nov 27, 2019 at 21:40

Valdi_Bo

31.1k4 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mandosoft Over a year ago

Edited above. It should be sorted by the name of the first column in each DataFrame.

Collectives™ on Stack Overflow

Python sort list of DataFrames on first column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related