I'm trying to write a python script to collect data from an excel table (table.png) with a lot of spreadsheets and data in in.
The table contains mole fraction of species in each column at different pressure in each row.
I will need just tables named with "..._end_point_vs_parameter". PFRC1... represents mole fraction results at 100°C so i have to consider up to PFRC13_end_point_vs_parameter (700°C).
My script is currently working just for one row and one spreadsheet.
How can i collect data from different spreadsheads and for each defined column name all data in it. I need to somehow summarize those data into this (sum.png).
Hello, Shkelqim Shaqiri! This question is also suitable for the https://stackoverflow.com/ forum. Anyway, my preferred way to load Excel workbooks with Python is through the Pandas module. Then, I would iterate over all sheets in the Excel workbook, each time requesting only columns with the specific name. All rows will be read by default. See the read_excel() function: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
- Badges
- Science topic