/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 vote145 views1 answer
Multiple sub in single regex.
Python
0 vote145 views1 answer
Pylatex multicolumn align
Python
0 vote147 views1 answer
Matplotlib legend number columns
Python
0 vote174 views1 answer
Matplotlib giving error "OverflowError: In draw_path: Exceeded cell block limit"
Python
1 vote141 views2 answers
Pandas index to datetime
Python
0 vote145 views1 answer
Unpacking list using underscore
Python
0 vote158 views1 answer
Update profile rasterio pyton
Python
0 vote176 views1 answer
Python a, b =
Python
9 votes146 views4 answers
Json timestamp to date python
Python
-1 vote141 views2 answers
Shell script to convert yaml
Python