Datasnips was built out of frustration in wasting time searching for Data Science & AI code snippets through old projects, documentation and internet sources.
We wanted a platform to easily find & organise our snippets, to share them with the community and discover those shared by other users.
At Datasnips you can quickly search, discover and bookmark snippets from the community, curate your own snippet library for easy reference and share your own snippets for others to use.
Our aim is for Datasnips to be the place where everyone can find the code snippet they need. Sign up to be part of the community.
How to Find Differences In Dataframe Rows
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.
columns_to_compare = ['a', 'b', 'c']
# Compare rows in the same dataframe:
for column in columns_to_compare:
if df[column][0] != df[column][1]:
print(column)
print(df[column][0])
print(df[column][1])
# Compare rows in different dataframes:
for column in columns_to_compare:
if df1[column][0] != df2[column][0]:
print(column)
print(df1[column][0])
print(df2[column][0])By detro - Last Updated June 4, 2022, 10:15 p.m.
