Combining two integer columns without addition

Asked Dec 28 '20 at 12:25

Active Dec 28 '20 at 16:05

Viewed 47 times

I have two columns:

Data = {'Col1': [1 , 2 , 3 , 0 , 0 , 4] , 'Col2': [0 , 2 , 0 , 5 , 6 , 4]}
df = pd.DataFrame(data = Data)
df.head()

Col1    Col2
0   1    0
1   2    2
2   3    0
3   0    5
4   0    6
5   4    4

I want to create a third column which combines these two, but does not add the cells. I want a dataset like the following:

Col1    Col2    Col3
0   1    0    1
1   2    2    2
2   3    0    3
3   0    5    5
4   0    6    6
5   4    4    4

I've simply added the two columns, but this solution adds the values existing in both columns. The solution is probably very easy, but i couldn't wrap my head around it...

Thanks in advance!

edited Dec 28 '20 at 16:05

New Dev

48,427
12
87
129

asked Dec 28 '20 at 12:25

Amby95

7

Check `df['Col3'] = df.max(1)` – Shubham Sharma Dec 28 '20 at 12:27
Can you select the max method on certain columns? For instance df['Col3'] = df[['Col1 , Col2]].max(1) – Amby95 Dec 28 '20 at 12:30
1

yes, you can select multiple columns.. – Shubham Sharma Dec 28 '20 at 12:31
2

df['Col3'] = df.max(axis=1). axis=1 for denoting that you're finding the max for the rows. – Igor Micev Dec 28 '20 at 12:32
Thanks a lot! I works wonders! – Amby95 Dec 28 '20 at 12:33

Combining two integer columns without addition

0 Answers0