CODEWITHSUNDEEP
pythonpandasdictionarytuples
FaCoffee
FaCoffee

Reputation: 7909

Pandas: create a dictionary with a tuple as key

Given this DataFrame:

import pandas as pd
first=[0,1,2,3,4]
second=[10.2,5.7,7.4,17.1,86.11]
third=['a','b','c','d','e']
fourth=['z','zz','zzz','zzzz','zzzzz']
df=pd.DataFrame({'first':first,'second':second,'third':third,'fourth':fourth})
df=df[['first','second','third','fourth']]

   first  second third fourth
0      0   10.20     a      z
1      1    5.70     b     zz
2      2    7.40     c    zzz
3      3   17.10     d   zzzz
4      4   86.11     e  zzzzz

I can create a dictionary with a list of columns as values, like this:

d = {df.loc[idx, 'first']: [df.loc[idx, 'second'], df.loc[idx, 'third']] for idx in range(df.shape[0])}

but how can I create a dictionary with, say, a tuple containing first and second as key?

The result would be:

In[1]:d
Out[1]: 
{(0,10.199999999999999): 'a',
 (1,5.7000000000000002): 'b',
 (2,7.4000000000000004): 'c',
 (3,17.100000000000001): 'd',
 (4,86.109999999999999): 'e'}

PS: and how could I make sure that pandas doesn't mess up with the values? 10.20 has now become 10.1999999999...

Upvotes: 2

Views: 2168

Answers (1)

jezrael
jezrael

Reputation: 862441

You need create MultiIndex by set_index and then call Series.to_dict:

a = df.set_index(['first','second']).third.to_dict()
print (a)
{(2, 7.4): 'c', (1, 5.7): 'b', (3, 17.1): 'd', (0, 10.2): 'a', (4, 86.11): 'e'}

Upvotes: 6

Related Questions