/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 vote172 views1 answer
Pandas.describe per group
Python
29 votes153 views5 answers
Python ls directory
Python
0 vote170 views1 answer
Import sys locate python = sys.exec_prefix print(locate python)
Python
1 vote210 views1 answer
Django how to set a navbar active
Python Django
0 vote170 views1 answer
Mediapipe python face landmarks
Python
0 vote185 views1 answer
Seasonal_decompose python
Python
0 vote168 views1 answer
How to make bot commands case insensitive in discord.py
Python
0 vote190 views1 answer
Pyttsx3 NameError: name 'voices' is not defined
Python
0 vote154 views1 answer
ImportError: /home/user/.local/lib/python3.8/site-packages/pytorch3d/_C.cpython-38-x86_64-linux-gnu.so: undefined symbol: _ZN2at5zerosEN3c108ArrayRefIlEENS0_13TensorOptionsE
Python
0 vote168 views1 answer
How to not create a new line in python
Python