Apply sorting to a list of dataframes Python

Question

I've struggling trying to insert a sorting in this code:

all_files = glob.glob(path + "/*.CSV") # To get all csv files disorganized
all_csv = [pd.read_csv(f, sep=',') for f in all_files] # List of dataframes

# I want to sort it by the values of the first column of each dataframe in the all_csv list.

for f in all_csv:
    goal = pd.DataFrame.sort_values(by=(f.iloc[:,0])) #Maybe something like this??

So, Anyone has an idea how can I do this? I've looking on other post but does not apply to a undefined column name (a.k.a. f.iloc[:,0] ) or a list of dataframes (I also thought of using dictionaries but I'd like to see if is posible to use with lists).

Thank you :)

May be useful this ideas: link, link

bsauce · Accepted Answer · 2022-01-10 21:28:42Z

1

This uses enke's code to sort each dataframe by the first column, but returns all dataframes in a list as you requested:

all_csv = [df.sort_values(by=df.columns[0]) for df in all_csv]

answered Jan 10, 2022 at 21:28

bsauce

6445 silver badges14 bronze badges

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

Comments

score 0 · Accepted Answer · 2022-01-10 21:28:59Z

0

You can index df.columns for individual dataframes:

goal = df.sort_values(by=df.columns[0])

For the entire list of dataframes, you can use list comprehension:

all_csv = [df.sort_values(by=df.columns[0]) for df in all_csv]

Suppose you had a dataframe that looked like:

Then when you run:

df = df.sort_values(by=df.columns[0])

df becomes:

edited Jan 10, 2022 at 21:28

answered Jan 10, 2022 at 21:14

user7864386

Collectives™ on Stack Overflow

Apply sorting to a list of dataframes Python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related