/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

1 vote269 views1 answer
Escape string for html python
Python
0 vote261 views1 answer
Run all python files in a directory in windows
Python
-1 vote262 views1 answer
How to join two dataframe in pandas based on two column
Python
0 vote269 views1 answer
"backup-codes-username.txt
Python
0 vote249 views1 answer
How to slice a set in python
Python
1 vote288 views1 answer
Get page source code selenium python
Python
0 vote250 views1 answer
DES-CBC python
Python
0 vote288 views1 answer
Ms access python dataframe
Python
12 votes274 views2 answers
Pil get image size
Python
6 votes270 views4 answers
List iteration
Python