Convert Dataframe with multiple columns to Dictionary in Python

Question

The Dataframe have three columns.

     Month    Machine  Number of Machine
    January  Machine 1                  1
  February   Machine 2                  1
  February   Machine 3                  1
      March  Machine 2                  2
      April  Machine 4                  1
        May  Machine 1                  1
       June  Machine 3                  1

I want to put into a dictionary in this format but I am not unsure on how to do it.

{('January', 'Machine 1'): 1, ('February', 'Machine 2'): 1, ('February', 'Machine 3'): 1, ('March', 'Machine 2'): 1, ('April', 'Machine 4'): 1, ('May', 'Machine 1'): 1, ('January', 'Machine 3'): 1}

Notice that there is a duplication of month.

abc · Accepted Answer · 2020-11-22 09:12:33Z

1

You can set the index to the pair 'Month','Machine' and then use the to_dict method.

df.set_index(['Month','Machine']).to_dict()['Number of Machine']

answered Nov 22, 2020 at 9:12

abc

12k2 gold badges30 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

asd asd · Accepted Answer · 2020-11-22 09:14:23Z

1

You can do it like this:

my_dict = {tuple(i[:-1]): i[-1] for i in data}

answered Nov 22, 2020 at 9:14

asd asd

1468 bronze badges

Comments

Vaebhav · Accepted Answer · 2020-11-22 09:16:12Z

1

You can do this iteratively using a loop

import pandas as pd
import numpy as np
from collections import defaultdict

def gen_dict(in_df):
    refHash = defaultdict()
    
    for row in in_df.values:
        key = tuple(row[:-1])
        refHash[key] = row[-1]
        
    return refHash

hash_map = gen_dict(in_df)

Another way would be to use index

df_dict = df.set_index(['Month','Machine']).to_dict()['Number of Machine']

answered Nov 22, 2020 at 9:16

Vaebhav

5,0921 gold badge17 silver badges37 bronze badges

Collectives™ on Stack Overflow

Convert Dataframe with multiple columns to Dictionary in Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related