Breaking News: Grepper is joining You.com. Read the official announcement!

python dataframe calculate difference between columns

Add Answer

Sarah Vorsselmans answered on April 18, 2020 Popularity 10/10 Helpfulness 4/10

answer python dataframe calculate difference between columns

related pandas difference between two dataframes

related difference between 2 dataframes

related find difference between two pandas dataframes

python dataframe calculate difference between columns

Comment

import pandas as pd
  
# Create a DataFrame
df1 = { 'Name':['George','Andrea','micheal',
                'maggie','Ravi','Xien','Jalpa'],
        'score1':[62,47,55,74,32,77,86],
        'score2':[45,78,44,89,66,49,72]}
  
df1 = pd.DataFrame(df1,columns= ['Name','score1','score2'])
  
print("Given Dataframe :\n", df1)
  
# getting Difference
df1['Score_diff'] = df1['score1'] - df1['score2']
print("\nDifference of score1 and score2 :\n", df1)

Popularity 10/10 Helpfulness 4/10 Language python

Source: www.geeksforgeeks.org

Tags: between dataframe difference python

Link to this answer
Share Copy Link

Contributed on Apr 16 2022

Sarah Vorsselmans

0 Answers Avg Quality 2/10

Closely Related Answers

pandas difference between two dataframes

Comment

source_df.merge(target_df,how='left',indicator=True).loc[lambda x:x['_merged']!='both']

Popularity 10/10 Helpfulness 3/10 Language python

Source: Grepper

Tags: between

Link to this answer
Share Copy Link

Contributed on Apr 18 2020

Repulsive Rhinoceros

0 Answers Avg Quality 2/10

difference between 2 dataframes

Comment

df1.merge(df2,indicator = True, how='left').loc[lambda x : x['_merge']!='both']
Out[421]: 
   A  B     _merge
1  2  3  left_only
2  3  4  left_only
3  3  4  left_only

Popularity 9/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: between

Link to this answer
Share Copy Link

Contributed on Sep 05 2021

David the pythonistas

0 Answers Avg Quality 2/10

find difference between two pandas dataframes

Comment

# by doing outer, you will get records from both the sides.
f = df1.merge(df2,indicator = True, how='outer').loc[lambda x : x['_merge']!='both']
Out[421]: 
   A  B     _merge
1  2  3  left_only
2  3  4  left_only
3  3  4  left_only

left_unique_result = f.loc[lambda x: x['_merge'] == 'left_only']
right_unique_result = f.loc[lambda x: x['_merge'] == 'right_only']

Popularity 10/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: between

Link to this answer
Share Copy Link

Contributed on Jun 15 2021

Difficult Deer

0 Answers Avg Quality 2/10

python dataframe calculate difference between columns

Contents

More Related Answers

python dataframe calculate difference between columns

Closely Related Answers

pandas difference between two dataframes

difference between 2 dataframes

find difference between two pandas dataframes

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.