How to Find Differences In Dataframe Rows

Python

In this code snippet we compare two rows in the same dataframe or different dataframes with the same columns. Where there are differences the column name and the column values from each row are printed for each differing column.

 1|  columns_to_compare = ['a', 'b', 'c']
 2|  
 3|  # Compare rows in the same dataframe:
 4|  for column in columns_to_compare:
 5|      if df[column][0] != df[column][1]:
 6|          print(column)
 7|          print(df[column][0])
 8|          print(df[column][1])  
 9|  
10|  # Compare rows in different dataframes:
11|  for column in columns_to_compare:
12|      if df1[column][0] != df2[column][0]:
13|          print(column)
14|          print(df1[column][0])
15|          print(df2[column][0])
detro
Pandas
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

142
LightGBM Custom Loss Function
Python

LightGBM | Loss function

127
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

122
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

115
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

86
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

85
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

82
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

65
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

65
Overwriting a Python Logging File Instead of Appending
Python

Logging

61