/Python/Python convert dictionary to pandas dataframe

Python convert dictionary to pandas dataframe

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

Dataframe to dictionary

>>> df.to_dict('records')
[{'col1': 1, 'col2': 0.5}, {'col1': 2, 'col2': 0.75}]

Source: pandas.pydata.org

Python convert dictionary to pandas dataframe

>>> 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 pandas dataframe to dict with a column as key

df.set_index('columnName').T.to_dict()

Similar codes

1 vote145 views1 answer
How to convert string to function name in python
Python
0 vote143 views1 answer
Python map string to int
Python
2 votes191 views4 answers
Streamlit install
Python
1 vote193 views1 answer
Django models.py convert DateTimeField to DateField
Python Django
0 vote145 views1 answer
Django update replace regex
Python
0 vote155 views1 answer
Programme phyton pour realiser un programme qui transforme une image en niveau de gris
Python
1 vote144 views2 answers
Iterable object pytohn
Python
84 votes158 views6 answers
Sort dataframe by column
Python
10 votes157 views6 answers
How to merge two dictionaries with same keys in python
Python
0 vote138 views1 answer
Enumerate() to skip items
Python