Breaking News: Grepper is joining You.com. Read the official announcement!

pandas df to list of dictionaries

Add Answer

Doubtful Dotterel answered on August 21, 2020 Popularity 9/10 Helpfulness 4/10

answer pandas df to list of dictionaries

related Convert list of dictionaries to a pandas DataFrame

related dataframe to list of dicts

related python list of dict to dataframe

related list of dict to dataframe

related pandas to list of dicts

related Convert list of dictionaries to a pandas DataFrame

related Converting Dataframe from list Using a list in the dictionary

pandas df to list of dictionaries

Comment

In [2]: df.to_dict('records')
Out[2]:
[{'customer': 1L, 'item1': 'apple', 'item2': 'milk', 'item3': 'tomato'},
 {'customer': 2L, 'item1': 'water', 'item2': 'orange', 'item3': 'potato'},
 {'customer': 3L, 'item1': 'juice', 'item2': 'mango', 'item3': 'chips'}]

Popularity 9/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: list pandas python

Link to this answer
Share Copy Link

Contributed on Jan 27 2022

Doubtful Dotterel

0 Answers Avg Quality 2/10

Closely Related Answers

Convert list of dictionaries to a pandas DataFrame

Comment

import pandas as pd

your_list = [{'points': 50, 'time': '5:00', 'year': 2010}, 
 {'points': 25, 'time': '6:00', 'month': "february"}, 
 {'points':90, 'time': '9:00', 'month': 'january'}, 
 {'points_h1':20, 'month': 'june'}]

df = pd.DataFrame(your_list)

Popularity 10/10 Helpfulness 8/10 Language python

Source: Grepper

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Jun 24 2022

Zany Zebra

0 Answers Avg Quality 2/10

dataframe to list of dicts

Comment

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

datadict = df.to_dict('records')

Popularity 10/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Oct 22 2020

Exuberant Eland

0 Answers Avg Quality 2/10

python list of dict to dataframe

Comment

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

Popularity 10/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Apr 23 2021

Arno Deceuninck

0 Answers Avg Quality 2/10

list of dict to dataframe

Comment

#Supposing d is your list of dicts, simply:
import pandas as pd 
df = pd.DataFrame(d)

Popularity 10/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Nov 21 2021

Sachin

0 Answers Avg Quality 2/10

pandas to list of dicts

Comment

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

Popularity 10/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: list

Link to this answer
Share Copy Link

Contributed on Aug 21 2020

Busy Boar

0 Answers Avg Quality 2/10

Convert list of dictionaries to a pandas DataFrame

Comment

np.random.seed(0)
data = pd.DataFrame(
    np.random.choice(10, (3, 4)), columns=list('ABCD')).to_dict('r')

print(data)
[{'A': 5, 'B': 0, 'C': 3, 'D': 3},
 {'A': 7, 'B': 9, 'C': 3, 'D': 5},
 {'A': 2, 'B': 4, 'C': 7, 'D': 6}]

Popularity 9/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on May 08 2022

SAMER SAEID

0 Answers Avg Quality 2/10

Converting Dataframe from list Using a list in the dictionary

Comment

-1

# import pandas as pd 

import pandas as pd 
# list of name, degree, score 
n = ["apple", "grape", "orange", "mango"] 
col = ["red", "green", "orange", "yellow"] 
val = [44, 33, 22, 11] 
# dictionary of lists 
dict = {'fruit': n, 'color': col, 'value': val}  
df = pd.DataFrame(dict) 
print(df)

Popularity 9/10 Helpfulness 1/10 Language python

Source: softhunt.net

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Apr 10 2022

Outrageous Ostrich

0 Answers Avg Quality 2/10

pandas df to list of dictionaries

Contents

More Related Answers

pandas df to list of dictionaries

Closely Related Answers

Convert list of dictionaries to a pandas DataFrame

dataframe to list of dicts

python list of dict to dataframe

list of dict to dataframe

pandas to list of dicts

Convert list of dictionaries to a pandas DataFrame

Converting Dataframe from list Using a list in the dictionary

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.