Merge multiple Boolean data frames into one data frame based on Boolean values

Question

I have three Boolean data frames which are part of the same dictionary. I would like to have as an output one data frame, containing all the true rows. So if one row is True in one of the data frames it's True in the output dataframe. if it's False in All data frames, it's False in the output dataframe.

data1 ={"":[True,False,True,False,False]}
data2= {"":[False,True,False,False,False]}
data3= {"":[False,False,False,False,True]}

df1=pd.DataFrame(data1)
df2=pd.DataFrame(data2)
df3=pd.DataFrame(data3)

Expected output:

Output_Data= {"":[True,True,True,False,True]}

Ynjxsjmh · Accepted Answer · 2022-07-19 17:12:07Z

1

IIUC, you can concat all dataframes on columns and use any(axis=1)

out = pd.concat([df1, df2, df3], axis=1).any(axis=1)

print(out)

0     True
1     True
2     True
3    False
4     True
dtype: bool

print({'': out.tolist()})

{'': [True, True, True, False, True]}

answered Jul 19, 2022 at 17:12

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

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

Comments

Mahdi F. · Accepted Answer · 2022-07-19 17:12:29Z

1

You can use or on multiple DataFrame then convert to the desired dictionary with pandas.to_dict like below.

>>> (df1 | df2 | df3).to_dict('list')
{'': [True, True, True, False, True]}

answered Jul 19, 2022 at 17:12

Mahdi F.

24.1k5 gold badges25 silver badges32 bronze badges

Collectives™ on Stack Overflow

Merge multiple Boolean data frames into one data frame based on Boolean values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related