Categories
28°C, New York
Home Python Pandas How to use the Assign method In Python Pandas

How to use the Assign method In Python Pandas

Method 3: Using apply()

assign() method assign new columns to a DataFrame, returning a new object (a copy) with the new columns added to the original ones. 

Example: Subtract two columns in Pandas dataframe

Python3




import numpy as np
import pandas as pd
  
data = np.arange(0, 20).reshape(4, 5)
  
  
df = pd.DataFrame(data,
                  index=['Row 1', 'Row 2', 'Row 3', 'Row 4'],
                  columns=['Column 1', 'Column 2', 'Column 3',
                           'Column 4', 'Column 5'])
  
  
df = df.assign(diff_1_5=df['Column 1'] - df['Column 5'])
  
df 






                        









													
													
												

												
												

													
													
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

													

														...
													

												
											

											
										


									

									

										
Tags:

										
										#pandas-dataframe-program
										
										#Python pandas-dataFrame
										
										#Python-pandas
										
										#Python
										
										#python
										

									

									

										

											
											
												
												Method 3: Using apply()