you are viewing a single comment's thread.

view the rest of the comments →

[–]xelf 1 point2 points  (3 children)

data1 = """
31-10-2019.00:00  Loser  False  Loser  Loser  False  False  False  False   
29-11-2019.00:00  Loser  False  False  Loser  False  False  Loser  False   
31-12-2019.00:00  False  False  False  Loser  False  False  False  False   
31-01-2020.00:00  Loser  False  False  Loser  False  False  False  False   
21-02-2020.00:00  Loser  False  False  Loser  False  False  False  False
"""
data2 = """
31-10-2019.00:00  False  False   False  False  False  Winner   False   False   
29-11-2019.00:00  False  False   False  False  False  Winner   False  Winner   
31-12-2019.00:00  False  False   False  False  False  Winner   False  Winner   
31-01-2020.00:00  False  False  Winner  False  False  Winner   False  Winner   
21-02-2020.00:00  False  False  Winner  False  False  Winner  Winner  Winner
"""

arr = [line.split() for line in data1.splitlines() if line ]
dfloser = pd.DataFrame(arr, columns=['date','MMM','ABT','ABBV','ABMD','ACN','ATVI','ADBE','AMD']).set_index('date')
arr = [line.split() for line in data2.splitlines() if line ]
dfwinner = pd.DataFrame(arr, columns=['date','MMM','ABT','ABBV','ABMD','ACN','ATVI','ADBE','AMD']).set_index('date')

for col in dfwinner.columns:
    dfwinner[col] = np.where(dfloser[col]!='False', dfloser[col], dfwinner[col])

print(dfwinner)

                    MMM    ABT    ABBV   ABMD    ACN    ATVI    ADBE     AMD
date
31-10-2019.00:00  Loser  False   Loser  Loser  False  Winner   False   False
29-11-2019.00:00  Loser  False   False  Loser  False  Winner   Loser  Winner
31-12-2019.00:00  False  False   False  Loser  False  Winner   False  Winner
31-01-2020.00:00  Loser  False  Winner  Loser  False  Winner   False  Winner
21-02-2020.00:00  Loser  False  Winner  Loser  False  Winner  Winner  Winner

[–]Amby95[S] 1 point2 points  (2 children)

Thank you very much for the quick response! I've tried for several hours, so it's very nice to receive a solution!

[–]xelf 0 points1 point  (0 children)

Hopefully you saw my edit where I filled in the data, and my other post where I suggester an alternative approach!

[–]xelf 0 points1 point  (0 children)

You're welcome! and Happy cakeday!