/Python/Create pandas dataframe from dictionary

Create pandas dataframe from dictionary

Pandas dataframe from dict

data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
pd.DataFrame.from_dict(data)

Convert a dictionary into dataframe python

import pandas as pd
data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
pd.DataFrame.from_dict(data, orient='index').T

Pandas dataframe from dict

>>> data = {'row_1': [3, 2, 1, 0], 'row_2': ['a', 'b', 'c', 'd']}
>>> pd.DataFrame.from_dict(data, orient='index')
       0  1  2  3
row_1  3  2  1  0
row_2  a  b  c  d

Source: pandas.pydata.org

Pandas dataframe from dict

>>> data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
>>> pd.DataFrame.from_dict(data)
   col_1 col_2
0      3     a
1      2     b
2      1     c
3      0     d

Source: pandas.pydata.org

Convert dict to dataframe

#Lazy way to convert json dict to df

pd.DataFrame.from_dict(data, orient='index').T

Create pandas dataframe from dictionary

In [11]: pd.DataFrame(d.items())  # or list(d.items()) in python 3
Out[11]:
             0    1
0   2012-07-02  392
1   2012-07-06  392
2   2012-06-29  391
3   2012-06-28  391
...

In [12]: pd.DataFrame(d.items(), columns=['Date', 'DateValue'])
Out[12]:
          Date  DateValue
0   2012-07-02        392
1   2012-07-06        392
2   2012-06-29        391

Source: stackoverflow.com

Similar codes

0 vote329 views1 answer
Raspberry pi run a python script using ssh
Python
0 vote352 views1 answer
Python quick tutorial
Python
13 votes360 views3 answers
Python upload video to youtube
Python
0 vote344 views1 answer
Conditional Statements to Skip Items enumerate python
Python
0 vote345 views2 answers
IPTC text classification example
Python
1 vote359 views1 answer
Python find dict in list of dict by id
Python
1 vote329 views2 answers
Copy string python
Python
0 vote345 views1 answer
[ WARN:0] global C:\Users\appveyor\AppData\Local\Temp\1\pip-req-build-nxx381if\opencv\modules\videoio\src\cap_msmf.cpp (435) `anonymous-namespace'
Python
0 vote376 views1 answer
Generate 3 random integers between 100 and 999 which is divisible by 5
Python
0 vote334 views1 answer
Create a date list in postgresql
Python