Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Combining Spreadsheets
#4
Have you looked at more than one tutorial for this kind of operation?

As an example: how about this one

Myself, I'd be looking at using OpenPyXL for this kind of work and I have in fact used said (not for this task, but for a far simper one) and it can get very involved and code heavy, if you want to have all the correct checks in place, which you should, tbh.

edit to add: I'm not a pandas user, but I've just learned that as of pandas version 2.0.0, the append() method has been completely removed, so you may want to check your version and, if needs be, use the concat() method.
Sig:
>>> import this

The UNIX philosophy: "Do one thing, and do it well."

"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse

"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
Reply


Messages In This Thread
Combining Spreadsheets - by Py3_14 - Feb-02-2024, 06:21 PM
RE: Combining Spreadsheets - by deanhystad - Feb-02-2024, 07:40 PM
RE: Combining Spreadsheets - by Py3_14 - Feb-06-2024, 08:10 PM
RE: Combining Spreadsheets - by rob101 - Feb-06-2024, 09:16 PM
RE: Combining Spreadsheets - by deanhystad - Feb-07-2024, 04:58 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Merging spreadsheets with the same columns and extracting rows with matching entries johnbernard 3 11,934 Aug-19-2021, 03:08 PM
Last Post: johnbernard
Question How to make a 3D List of Excel Spreadsheets? chatguy 4 2,835 Jan-24-2021, 05:24 AM
Last Post: buran
  IDE with spreadsheets lewispgj 4 2,401 Mar-13-2020, 09:45 PM
Last Post: lewispgj
  opepyxl not counting rows in spreadsheets? jjartus 10 6,807 Mar-07-2020, 09:17 AM
Last Post: jjartus

Forum Jump:

User Panel Messages

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