Skip to content
SEO & Data Specialist | Arthur Camberlein
TwitterFRBlog FR

Compare 2 columns in python in bulk

Python, Data1 min read

TIL moment: Today I Lean how to create a new column to compare two other ones in Python, and it is as simple as a one liner thanks to pandas.

Creating a 3rd column to compare 3 in Python - Arthur Camberlein

To be honest with you folks, I was going to use numpy, and do some "complicated stuff" ... but it is already in pandas & I am realy glad I found this. I didn't search for something on the Internet this time, I tried it as I thought it could work ... and it did!

The python code to compare to columns and create a third one

The python code would be:

1df['match'] = df['Domain_destination'] == df['Domain_source']

What the output

It will give you a true of false

Code excerpt from Arthur Camberlein to compare 2 columns in Python

Domain_destinationDomain_sourcematch
camberlein.comcamberlein.comtrue
camberlein.comcamberlein.frfalse

This is a perfect example, that could be used for data analysis in general, uncluding SEO analysis.

How to do this in Spreadsheet

Of course, you can still use a formula to to this check, using =EXACT() ... but let be honest, if you are already manipulating your data thanks to Python, it is better to use this one liner ... don't you agree?

The output in Google Spreadsheet would be:

First_urlSecond_urlExact
url_aurl_b=EXACT(A2,B2)
url_aurl_bFALSE

This tips is coming from a tweet ...

... I posted some time ago: https://twitter.com/ArthurCa/status/1534542099890286594

© 2022 by SEO & Data Specialist | Arthur Camberlein. All rights reserved.
Theme by LekoArts