/Python/Python list of dict to dataframe

Python list of dict to dataframe

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

Similar codes

0 vote318 views2 answers
Commentaire python
Python
0 vote304 views1 answer
India states django choices
Python
4 votes296 views3 answers
Python create 2d array deep copy
Python
0 vote249 views1 answer
Radice n esima python
Python
1 vote318 views1 answer
Select realted for foreign key table in django
Python Django
0 vote314 views1 answer
Tkiner lable
Python
7 votes253 views2 answers
Python list 1 to n
Python
0 vote312 views1 answer
Index.py:14: RuntimeWarning: invalid value encountered in true_divide return np.dot(user, user2) / (norm(user) * norm(user2))
Python
0 vote262 views2 answers
Pip config proxy
Python
0 vote283 views1 answer
Python API translate language into Igbo
Python