python dictionary to pandas dataframe returns empty dataframe

Question

I have a dictionary created run-time in my program which needs to be converted to a pandas dataframe.

dictio={'a':'abc','b':'zyx','c':'prq'} df=pd.Dataframe(dictio)

The above code returns me an empty dataframe with columns created. Can anyone point to what am i missing out?

Allen Qin · Accepted Answer · 2017-05-16 00:57:17Z

3

#use from_dict and set orient to index and then transpose in the end.
pd.DataFrame.from_dict(dictio,orient='index').T
Out[263]: 
     a    c    b
0  abc  prq  zyx

answered May 16, 2017 at 0:57

Allen Qin

20k9 gold badges55 silver badges68 bronze badges

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

4 Comments

Abhi Over a year ago

This works but I want the result to be in a transposed format, as in the dictionary keys should be column names.

Allen Qin Over a year ago

Keys(a,b,c) are the column names here. What' your expected results?

Abhi Over a year ago

I believe the example I have provided isn't enough, I have an empty dictionary set up with large number of columns whose values get set during the program. Converting into data-frame gives me using what was suggested dictionary keys as first column and 0 as another.

Allen Qin Over a year ago

I'm not sure if I understand you problem. Please provide an example with more data and your desired output.

Collectives™ on Stack Overflow

python dictionary to pandas dataframe returns empty dataframe

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related