pandas add two columns code example

Example 1: pandas merge two columns from different dataframes

#suppose you have two dataframes df1 and df2, and 
#you need to merge them along the column id
df_merge_col = pd.merge(df1, df2, on='id')

Example 2: how to add the sum of multiple columns into another column in a dataframe

print(df)
   Apples  Bananas  Grapes  Kiwis
0     2.0      3.0     NaN    1.0
1     1.0      3.0     7.0    NaN
2     NaN      NaN     2.0    3.0

df['Fruit Total']=df.iloc[:,-4:].sum(axis=1)

print(df)
   Apples  Bananas  Grapes  Kiwis  Fruit Total
0     2.0      3.0     NaN    1.0          6.0
1     1.0      3.0     7.0    NaN         11.0
2     NaN      NaN     2.0    3.0          5.0

Example 3: sum two columns pandas

sum_column = df["col1"] + df["col2"]

Example 4: pandas dataframe add two columns int and string

df = df['Day'].map(str) + '-' + df['Month'].map(str) + '-' + df['Year'].map(str)

Example 5: how to merge two column pandas

DataFrame["new_column"] = DataFrame["column1"] + DataFrame["column2"]