I have a dataframe with two columns each of which represents an organism. They are called ORG1 and ORG2
I want to move the values of ORG2 into ORG1 for the corresponding index value.
So, if ORG1 is 'A' and ORG2 is 'B' I want ORG1 to take the value 'B' from ORG2.
I have already started work to identify indexes of the ORG2 organisms that I want to move, as follows:
org2_matches = Series(x.ORG2.str.count("ESBL"))
return x.ix[org2_matches == 1]
org2_DF = move_org2(DF)
What is the best way to use this to change ORG1 values with the values at corresponding ORG2 indices
In : df Out: ORG1 ORG2 0 A ESBL 1 B P 2 C Q 3 D R 4 E ESBL In : cond = df.ORG2 == 'ESBL' In : df.ORG1[cond] = df.ORG2[cond] In : df Out: ORG1 ORG2 0 ESBL ESBL 1 B P 2 C Q 3 D R 4 ESBL ESBL