How to convert nested dictionary to dataframe in Python

Question

I have a list contain nested dictionary, I want to convert them to pandas dataframe.

My input data is below

my_list = [{'ticker': 'CompanyA',
  'Cash Cycle': ['3M/2018', '3M/2017', '2017', '2016'],
  'A/R Turnover (Times)': ['1', '2', '3', '4']},
 {'ticker': 'CompanyB',
  'Cash Cycle': ['3M/2018', '3M/2017', '2017', '2016'],
  'A/R Turnover (Times)': ['5', '6', '7', '8']}]

I tried to convert with pd.Dataframe(my_list) and result is below

Please tell me how to get result below ?

Sunitha · Accepted Answer · 2018-07-01 17:14:11Z

2

import pandas as pd
df_list = [pd.DataFrame(d) for d in my_list]

df = pd.concat(df_list).reset_index(drop=False)
df
   index    ticker Cash Cycle A/R Turnover (Times)
0      0  CompanyA    3M/2018                 7.57
1      1  CompanyA    3M/2017                 7.60
2      2  CompanyA       2017                 8.69
3      3  CompanyA       2016                 8.25
4      0  CompanyB    3M/2018                 7.57
5      1  CompanyB    3M/2017                 7.60
6      2  CompanyB       2017                 8.69
7      3  CompanyB       2016                 8.25


   ticker     Cash Cycle    A/R Turnover (Times)
0  CompanyA    3M/2018      7.57
1  CompanyA    3M/2017      7.60
2  CompanyA       2017      8.69
3  CompanyA       2016      8.25
0  CompanyB    3M/2018      7.57
1  CompanyB    3M/2017      7.60
2  CompanyB       2017      8.69
3  CompanyB       2016      8.25

edited Jul 1, 2018 at 17:14

answered Jul 1, 2018 at 13:32

Sunitha

12.1k2 gold badges23 silver badges23 bronze badges

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

3 Comments

nisahc Over a year ago

Can we set index number to continue from last index of first dataframe ?

Ashish Acharya Over a year ago

@nisahc, you mean df.reset_index()?

nisahc Over a year ago

@AshishAcharya Thanks,

Collectives™ on Stack Overflow

How to convert nested dictionary to dataframe in Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related