Python Forum
Comparing data from two Excel sheets
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Comparing data from two Excel sheets
#1
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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 1,926 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,048 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
Lightbulb Help using Google Sheets matheuspimenta 0 688 Dec-15-2022, 05:36 PM
Last Post: matheuspimenta
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,802 Dec-12-2022, 08:22 PM
Last Post: jh67
  How to loop through all excel files and sheets in folder jadelola 1 4,333 Dec-01-2022, 06:12 PM
Last Post: deanhystad
  Trying to Get Arduino sensor data over to excel using Python. eh5713 1 1,620 Dec-01-2022, 01:52 PM
Last Post: deanhystad
  Appending a row of data in an MS Excel file azizrasul 3 1,139 Nov-06-2022, 05:17 PM
Last Post: azizrasul
  Moving data from one Excel to another and finding maximum profit azizrasul 7 1,412 Oct-06-2022, 06:13 PM
Last Post: azizrasul
  get data from excel and find max/min Timmy94 1 1,077 Jul-27-2022, 08:23 AM
Last Post: Larz60+
  How to keep columns header on excel without change after export data to excel file? ahmedbarbary 0 1,130 May-03-2022, 05:46 PM
Last Post: ahmedbarbary

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020