Difference of two columns in pandas dataframe – python

Difference of two columns in pandas dataframe in python is carried out using ” -” operator. Let’s see how to

  • Find the difference of two columns in pandas dataframe – python. (subtract one column from other column pandas) with an example.

First let’s create a data frame

import pandas as pd
import numpy as np

#Create a DataFrame
df1 = {
     'Name':['George','Andrea','micheal','maggie','Ravi','Xien','Jalpa'],
   'Mathematics1_score':[62,47,55,74,32,77,86],
   'Mathematics2_score':[45,78,44,89,66,49,72]}

df1 = pd.DataFrame(df1,columns=['Name','Mathematics1_score','Mathematics2_score'])

print(df1)

 df1 will be

Difference of two columns in pandas dataframe – python 1

 

Difference of two columns in a pandas dataframe in python

Difference of two Mathematical score is computed using simple – operator and stored in the new column namely Score_diff as shown below


df1['Score_diff']=df1['Mathematics1_score'] - df1['Mathematics2_score']
print(df1)

so resultant dataframe will be

Difference of two columns in pandas dataframe – python 2

Difference of two columns in pandas dataframe – python                                                                                                          Difference of two columns in pandas dataframe – python

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.

    View all posts