'Update dataframe 1 using two columns in dataframe 2 in python

I want to update Freq column in df1 using Freq column in data frame 2 as shown below,

data = {'Cell':[1,2,3,4,'10-05','10-09'], 'Freq':[True, True,True,True,True,True]}

df1 = pd.DataFrame(data)

Dataframe 1

Dataframe 1

Dataframe 2

data2 = {'Cell-1':[1,1,1,1,1,1,2,2,2,2,2,2],'Cell-2':[1,2,3,4,'10-05','10-09',1,2,3,4,'10-05','10-09'] ,'Freq':[True, False,True,False,True,True,True, False,True,False,True,False]}

df2 = pd.DataFrame(data2)

Dataframe 2

df1 column 1 has keys while column 2 is corresponding value which in this case is either True or False.

Lets take for example key = 1 in Dataframe 1. This key = 1 has multiple values in Dataframe 2 as shown in the figure. The multiple values for this key = 1 in dataframe 2 is due to values in Column 2, Dataframe 2 which in turn are keys to Dataframe 1 which I want to update in column 2 of df1.

Algorithm in action figure Alogrithm in action



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source