Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
merge excel
#1
Hi

I want to merge and filter 2 excel sheets. They have different columns and one unique id.

I would want to leave other columns from these different excel and produce a 3rd excel sheet
Reply
#2
In general, an algorithm would be as follows (if you expect to use Python to solve the problem): 1) read these files, e.g. using pandas: import pandas as pd; data1 = pd.read_excel('yourfile_1.xlsx'); 2) do merging... 3) save the result, e.g. using pandas.
So, what did you try so far?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Merge 2 Excel in a specific format Apython 0 1,880 Jan-16-2019, 07:26 AM
Last Post: Apython

Forum Jump:

User Panel Messages

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