Convert dataframe to dictionary

Question

I intend to get a dictionary with column name as key from a dataframe.

Suppose I have a dataframe:

    a    b
 0  ac   dc
 1  ddd  fdf

I want the output as:

{a : ac, b : dc}

I want it to be done row by row. Any sort of help would be greatly appreciated. Here I want the column name as the key in the resulting dictionary.

Maybe `df.to_dict(orient='list')` – jezrael Dec 17 '15 at 07:56 — jezrael, Dec 17 '15 at 07:56
@Altoyr Here I want to take the column name as the key. – Sunil Kumar Dec 17 '15 at 08:25 — Sunil Kumar, Dec 17 '15 at 08:25

score 9 · Accepted Answer · answered Dec 17 '15 at 08:03

You can use the to_dict() method with orient='records'

import pandas as pd

df = pd.DataFrame([{'a': 'ac', 'b': 'dc'}, {'a': 'ddd', 'b': 'fdf'}])
print(df)

#      a    b
# 0   ac   dc
# 1  ddd  fdf

d = df.to_dict(orient='records')
print(d)

# [{'b': 'dc', 'a': 'ac'}, {'b': 'fdf', 'a': 'ddd'}]

Convert dataframe to dictionary

1 Answers1

Linked