Direct Method

This is the __getitem__ method syntax ([]), which lets you directly access the columns of the data frame using the column name.

Example: Subtract two columns in Pandas dataframe

Python3




import numpy as np
import pandas as pd
  
data = np.arange(0, 20).reshape(4, 5)
  
  
df1 = pd.DataFrame(data,
                   index=['Row 1', 'Row 2', 'Row 3', 'Row 4'],
                   columns=['Column 1', 'Column 2', 'Column 3',
                            'Column 4', 'Column 5'])
  
# using our previous example
# now let's subtract the values of two columns
df1['Column 1'] - df1['Column 2']


Output: 

How to Subtract Two Columns in Pandas DataFrame?

In this article, we will discuss how to subtract two columns in pandas dataframe in Python.

Dataframe in use:

Similar Reads

Method 1: Direct Method

This is the __getitem__ method syntax ([]), which lets you directly access the columns of the data frame using the column name....

Method 2: Defining a function

...

Method 3: Using apply()

We can create a function specifically for subtracting the columns, by taking column data as arguments and then using the apply method to apply it to all the data points throughout the column....

Method 4: Using the Assign method

...