Python Forum
Merging spreadsheets with the same columns and extracting rows with matching entries
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Merging spreadsheets with the same columns and extracting rows with matching entries
#3
(Aug-17-2021, 10:14 PM)Larz60+ Wrote: look for packages that you can use in your project, search here: https://pypi.org/
example openpyxl for reading and writing excel files:
search all openpyxl:
https://pypi.org/search/?q=openpyxl&o=
specific: https://pypi.org/project/openpyxl/
and github code docs: https://openpyxl.readthedocs.io/en/stable/

Thanks for the heads up that's really helpful! Appreciate it so much!

John
Reply


Messages In This Thread
RE: Merging spreadsheets with the same columns and extracting rows with matching entries - by johnbernard - Aug-18-2021, 01:36 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Combining Spreadsheets Py3_14 4 635 Feb-07-2024, 04:58 PM
Last Post: deanhystad
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,681 Jan-29-2023, 03:59 PM
Last Post: eyavuz21
  merging rows arvin 2 846 Dec-24-2022, 04:56 AM
Last Post: arvin
  Extracting Data into Columns using pdfplumber arvin 17 5,699 Dec-17-2022, 11:59 AM
Last Post: arvin
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,946 Dec-12-2022, 08:22 PM
Last Post: jh67
  Check DataFrames with different sorting in columns and rows Foxyskippy 0 806 Nov-19-2022, 07:49 AM
Last Post: Foxyskippy
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,649 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  making variables in my columns and rows in python kronhamilton 2 1,650 Oct-31-2021, 10:38 AM
Last Post: snippsat
  rows from sql query need to write to a file as columns sjcsvatt 6 2,451 Oct-09-2021, 12:45 AM
Last Post: snippsat
  Summing up rows and columns plumberpy 3 2,299 Aug-18-2021, 05:46 AM
Last Post: naughtyCat

Forum Jump:

User Panel Messages

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