How to make dataframe from list of list

Question

I have searched but till not able to figure out how to make data frame from below:

0       ([179, 142, 176, 177, 176, 180, 180, 180, 180,...
1       ([353, 314, 349, 349, 344, 359, 359, 359, 359,...
2       ([535, 504, 535, 535, 535, 540, 540, 540, 540,...
3       ([711, 664, 703, 703, 703, 721, 721, 721, 721,...
4       ([850, 810, 822, 822, 842, 857, 857, 857, 857,.

below is how single data looks

([179, 142, 176],
 ['Qtr- Oct-20','Qtr- Oct-20','Qtr- Oct-20',],
 ['High','Low','Close'],
 [43.8, 26.05,33.1])

what i want is

      0  1           2               3
0   179 Qtr- Oct-20 High            43.8
1   142 Qtr- Oct-20 Low             26.05
2   176 Qtr- Oct-20 High_Volume     1123132
3   177 Qtr- Oct-20 High_Delivery   42499

what i am getting

      0
0   ([179, 142, 176, 177, 176, 180, 180, 180, 180,...
1   ([353, 314, 349, 349, 344, 359, 359, 359, 359,...
2   ([535, 504, 535, 535, 535, 540, 540, 540, 540,...

Shubham Sharma · Accepted Answer · 2020-12-25 12:57:59Z

1

Let's do apply + pd.Series.explode:

pd.DataFrame(df['col'].tolist()).apply(pd.Series.explode).reset_index(drop=True)

     0            1      2      3
0  179  Qtr- Oct-20   High   43.8
1  142  Qtr- Oct-20    Low  26.05
2  176  Qtr- Oct-20  Close   33.1

Note: df['col'] is the column in the dataframe which contains list of lists.

edited Dec 25, 2020 at 12:57

answered Dec 25, 2020 at 12:51

Shubham Sharma

71.8k6 gold badges26 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

How to make dataframe from list of list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related