How to create pandas dataframe from python dictionary?

Question

I have a python dictionary below:

dict = {'stock1': (5,6,7), 'stock2': (1,2,3),'stock3': (7,8,9)};

I want to change dictionary to dataframe like:

How to write the code?

I use:

pd.DataFrame(list(dict.iteritems()),columns=['name','closePrice'])

But it will get wrong. Could anyone help?

I have tried pd.DataFrame(dict),But it will show: If using all scalar values, you must pass an index — yensheng
– yensheng, Commented Jul 22, 2016 at 4:39

alecxe · Accepted Answer · 2016-07-22 04:04:50Z

4

You are overcomplicating the problem, just pass your dictionary into the DataFrame constructor:

import pandas as pd

d = {'stock1': (5,6,7), 'stock2': (1,2,3),'stock3': (7,8,9)}
print(pd.DataFrame(d))

Prints:

   stock1  stock2  stock3
0       5       1       7
1       6       2       8
2       7       3       9

answered Jul 22, 2016 at 4:04

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

2 Comments

yensheng Over a year ago

I have tried your method,But it will show: If using all scalar values, you must pass an index

juanpa.arrivillaga Over a year ago

@easyway Then the dictionary you gave as an example doesn't represent the dictionary your actual dictionary accurately. If it were the same form, that works in every version of pandas, AFAIK.

Merlin · Accepted Answer · 2016-07-22 05:34:26Z

2

Try this: Do not name your variables python key words!

dd = {'stock1': (5,6,7), 'stock2': (1,2,3),'stock3': (7,8,9)};
#pd.DataFrame(dd) Should work!

pd.DataFrame.from_dict(dd, orient='columns')

   stock1  stock2  stock3
0       5       1       7
1       6       2       8
2       7       3       9

answered Jul 22, 2016 at 5:34

Merlin

25.8k44 gold badges141 silver badges213 bronze badges

Collectives™ on Stack Overflow

How to create pandas dataframe from python dictionary?

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related