python pandas dataframe to dictionary

python dictionary pandas
perigee picture perigee · Sep 9, 2013 · Viewed 171.3k times · Source

I've a two columns dataframe, and intend to convert it to python dictionary - the first column will be the key and the second will be the value. Thank you in advance.

Dataframe:

    id    value
0    0     10.2
1    1      5.7
2    2      7.4

Answer

joris picture joris · Sep 9, 2013

See the docs for to_dict. You can use it like this:

df.set_index('id').to_dict()

And if you have only one column, to avoid the column name is also a level in the dict (actually, in this case you use the Series.to_dict()):

df.set_index('id')['value'].to_dict()

Related questions

Convert list of dictionaries to a pandas DataFrame

I have a list of dictionaries like this: [{'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'}] And I want to turn this into a pandas DataFrame …

Read More
Remap values in pandas column with a dict

I have a dictionary which looks like this: di = {1: "A", 2: "B"} I would like to apply it to the "col1" column of a dataframe similar to: col1 col2 0 w a 1 1 2 2 2 NaN to get: col1 col2 0 w a 1 A 2 2 B NaN …

Read More
Convert a Pandas DataFrame to a dictionary

I have a DataFrame with four columns. I want to convert this DataFrame to a python dictionary. I want the elements of first column be keys and the elements of other columns in same row be values. DataFrame: ID A …

Read More