Pandas to list of dicts

Dataframe to list of dicts

df = pd.DataFrame({'Name': ['John', 'Sara','Peter','Cecilia'],
                   'Age': [38, 47,63,28],
                  'City':['Boston', 'Charlotte','London','Memphis']})

datadict = df.to_dict('records')

Python list of dict to dataframe

# Supposing d is your list of dicts, simply
df = pd.DataFrame(d)
# Note: this does not work with nested data

Source: stackoverflow.com

Pandas to list of dicts

In [20]: timeit df.T.to_dict().values()
1000 loops, best of 3: 395 µs per loop

In [21]: timeit df.to_dict('records')
10000 loops, best of 3: 53 µs per loop

Source: stackoverflow.com

List of dict to dataframe

Supposing d is your list of dicts, simply:
import pandas as pd 

df = pd.DataFrame(d)

List of dict to df

df = pd.DataFrame(d)  #here d is list of dict

Similar codes

2 votes262 views1 answer
Python gui capture user input
Python
0 vote176 views1 answer
Rabin karp algorithm
Python
0 vote198 views1 answer
Django custome login
Python Django
0 vote181 views1 answer
How to apply a function to multiple columns in pandas dataframe
Python
5 votes188 views1 answer
Python put quotes in string
Python
31 votes187 views3 answers
How to adda vaslues to data frame
Python
13 votes180 views3 answers
Python how to generate random number in a range
Python
0 vote199 views1 answer
Raspberry pi run python script on boot
Python
4 votes218 views1 answer
Replace multi spaces with single space
Python
0 vote220 views1 answer
How to remove repeated files from google drive in python
Python