How to convert pandas DataFrame to dict with string index string value?

Question

I have a pandas DataFrame with 2 columns. How can I convert this into a Python dictionary with id as key and name as value?

INPUT

id | name
1  | hello
2  | world

REQUIRED OUTPUT

{
    "1": "hello",
    "2": "world",
}

Does this answer your question? [dataframe to dict such that one column is the key and the other is the value](https://stackoverflow.com/questions/53941224/dataframe-to-dict-such-that-one-column-is-the-key-and-the-other-is-the-value) — Mayank Porwal, May 20 '20 at 21:27

score 4 · Accepted Answer · answered May 20 '20 at 21:22

4

You can just do this:

In [1256]: df.set_index('id').to_dict()['name']
Out[1256]: {1: 'hello', 2: 'world'}

answered May 20 '20 at 21:22

Mayank Porwal

33,470
8
37
58

score 2 · Answer 2 · answered May 20 '20 at 21:18

2

zip the two columns you want.

dict(zip(df['id'].astype(str), df['name']))
#{'1': 'hello', '2': 'world'}

If you want to use the pandas methods, make things strings then set the keys to your index and grab the column you want to be the values and go with .to_dict

(df.astype('str')
   .set_index('id')['name']
   .to_dict()
)

answered May 20 '20 at 21:18

ALollz

57,915
7
66
89

`df.astype('str')` won’t make the index values strings. – Skippy le Grand Gourou Feb 10 '21 at 15:23
1

In the example both `'id'` and `'name'` are columns so it will. You can see in my second example I then set the index to be `'id'` as it's not to begin with. – ALollz Feb 10 '21 at 15:26

Kriti Pawar · Answer 3 · 2020-05-21T06:47:45.503

1

Please try:

dict_ = {}
for  i , value in enumerate(df[‘name’]):
    dict_[i] = value

You can also try:

dict_ = df.set_index('id').to_dict()['name']

If you want dictionary value as list:

dict_ = df.set_index('id').T.to_dict('list')

edited May 21 '20 at 06:47

answered May 20 '20 at 21:16

Kriti Pawar

832
7
15

Do you know if there is a way without loops/enumeration? – konichiwa May 20 '20 at 21:17

score 1 · Answer 4 · answered May 20 '20 at 21:25

1

Let us do

d=dict(zip(df.id,df.name))

answered May 20 '20 at 21:25

BENY

317,841
20
164
234

score 1 · Answer 5 · answered Feb 10 '21 at 15:34

Other answers focus on the conversion from pandas DataFrame to dict, however the question is also about having the index values as strings.

The solution for that is to map the index to str beforehand :

df.to_dict()
{'name': {0: 'hello', 1: 'world'}}

df.index = df.index.map(str)
df.to_dict()
{'name': {'0': 'hello', '1': 'world'}}

How to convert pandas DataFrame to dict with string index string value?

5 Answers5