List of dataframes to dataframe of lists

Question

How to convert a list of dataframes to a dataframe of lists? For example:

lst = [pd.DataFrame({'A': [1, 2], 'B': [10, 20]}), pd.DataFrame({'A': [3, 4, 5], 'B': [30, 40, 50]})]

Expected result:

 A B 0 [1, 2] [10, 20] 1 [3, 4, 5] [30, 40, 50]

My real list contains thousands of dataframes.

Ignatius Reilly · Accepted Answer · 2022-08-27 02:41:07Z

2

lst = [pd.DataFrame({'A': [1, 2], 'B': [10, 20]}), pd.DataFrame({'A': [3, 4, 5], 'B': [30, 40, 50]})] dic_lst = [df.to_dict(orient='list') for df in lst] pd.DataFrame(dic_lst)

answered Aug 27, 2022 at 2:41

Ignatius Reilly

1,7524 gold badges9 silver badges18 bronze badges

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

2 Comments

Ignatius Reilly Over a year ago

Don't know how efficient it's for thousands of dataframes... but it's the most straightforward solution I can think of.

mozway Over a year ago

Nice one. It should be quite fast ;)

BENY · Accepted Answer · 2022-08-27 03:33:11Z

We could do

out = pd.concat(dict(enumerate(lst))).groupby(level=0).agg(list) Out[1053]: A B 0 [1, 2] [10, 20] 1 [3, 4, 5] [30, 40, 50]

Collectives™ on Stack Overflow

List of dataframes to dataframe of lists

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related