Python DataFrame from a list

Question

So, I have to create a dataframe. I do not mind my source to be a list of dicts or a dict.

List of Dict:
[{'A': 'First', 'C': 300, 'B': 200},
{'A': 'Second', 'C': 310, 'B': 210},
{'A': 'Third', 'C': 330, 'B': 230},
{'A': 'Fourth', 'C': 340, 'B': 240},
{'A': 'Fifth', 'C': 350, 'B': 250}]

OR

{'First': {'C': 300, 'B': 200},
'Second':{'C': 310, 'B': 210} },
'Third': {'C': 330, 'B': 230},
'Fourth': {'C': 340, 'B': 240},
'Fifth': {'C': 350, 'B': 250} }

I want my dataframe like this

           C     B
First    300   200
Second   310   210
Third    330   230
Fourth   340   240
Fifth    350   250

Basically, suggesting that one of the columns become the index ...

I am using dataFrame. Problem is I am not able to figure out how to make contents of dict index 'A' as index of the dataframe — Pankaj Singh
– Pankaj Singh, Commented Nov 30, 2016 at 18:43

akuiper · Accepted Answer · 2016-11-30 18:48:23Z

3

Also you can use pd.DataFrame.from_records() where you can set a specific column to be index:

pd.DataFrame.from_records([{'A': 'First', 'C': 300, 'B': 200},
{'A': 'Second', 'C': 310, 'B': 210}, 
{'A': 'Third', 'C': 330, 'B': 230}, 
{'A': 'Fourth', 'C': 340, 'B': 240}, 
{'A': 'Fifth', 'C': 350, 'B': 250}], index = ['A'])

answered Nov 30, 2016 at 18:48

akuiper

216k33 gold badges362 silver badges379 bronze badges

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

Comments

Robᵩ · Accepted Answer · 2016-11-30 18:48:04Z

2

Using your first dataset, here is one way:

In [15]: df=pd.DataFrame(l, index=[d['A'] for d in l])

In [16]: del df['A']

In [17]: df
Out[17]: 
          B    C
First   200  300
Second  210  310
Third   230  330
Fourth  240  340
Fifth   250  350

[5 rows x 2 columns]

From your second dataset, here is another way. Note that, since the order of keys in a dictionary is arbitrary, the order of rows in the DataFrame will also be arbitrary.

In [27]: pd.DataFrame(data=l2.values(), index=l2.keys())
Out[27]: 
          B    C
Fifth   250  350
Second  210  310
Fourth  240  340
Third   230  330
First   200  300

[5 rows x 2 columns]

edited Nov 30, 2016 at 18:48

answered Nov 30, 2016 at 18:44

Robᵩ

170k20 gold badges251 silver badges323 bronze badges

1 Comment

Pankaj Singh Over a year ago

x = pd.DataFrame(data,index=[x['A'] for x in data]) ... yeah, that is what I was wondering too... thanks Rob

Vidhya G · Accepted Answer · 2016-11-30 19:13:13Z

2

List of Dict:

l = [{'A': 'First', 'C': 300, 'B': 200},
{'A': 'Second', 'C': 310, 'B': 210}, 
{'A': 'Third', 'C': 330, 'B': 230}, 
{'A': 'Fourth', 'C': 340, 'B': 240}, 
{'A': 'Fifth', 'C': 350, 'B': 250}]


df = pd.DataFrame.from_records(l).set_index('A')

Dictionary:

d = {'First': {'C': 300, 'B': 200},
'Second':{'C': 310, 'B': 210}, 
'Third': {'C': 330, 'B': 230}, 
'Fourth': {'C': 340, 'B': 240}, 
'Fifth': {'C': 350, 'B': 250} }

df = pd.DataFrame.from_dict(d, orient='index')

answered Nov 30, 2016 at 19:13

Vidhya G

2,3401 gold badge27 silver badges28 bronze badges

Collectives™ on Stack Overflow

Python DataFrame from a list

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related