/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

3 votes159 views1 answer
Puissance python
Python
1 vote175 views1 answer
Get_or_create in django
Python
0 vote172 views1 answer
Destroy label tkinter
Python
23 votes170 views4 answers
Delete last few items from a list python
Python
78 votes177 views6 answers
Python string reverse
Python
39 votes193 views4 answers
Round down number python
Python
23 votes175 views4 answers
Python flat list from list of list
Python
2 votes176 views2 answers
Python inline conditional
Python
0 vote183 views1 answer
Python inline web server
Python
3 votes413 views1 answer
Len python meaning
Python