Python Forum

Full Version: Comparing data from two Excel sheets
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi guys,

Pretty new to Python and taking a couple of courses.
As an SEO I'm looking at ways to use Python and Pandas on a day to day basis to help with workflow.

I've got two sets of data (past and current) which I'm importing into Pandas.

Both contain keywords( string ) and rankings positions (integer). I'm looking to create a new dataframe which contains the past, current and numerical change of ranking positions.

Any information would be greatly appreciated.