Python Forum
Python script to summarize excel tables, then output a composite table? i'm a total n
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python script to summarize excel tables, then output a composite table? i'm a total n
#1
So I have a production Limits management system, basically a huge table that has rows for each permutation of [Plan | subgroup | Tool | Item | Statistic | Limit] that will trigger automated events.

The problem I'm seeing is that we are tracking the limits in a table that just has [Tool | Item | limit], making it more reasonable for humans to interact with. In order to make an edit to the actual system table, a user must identify all permutations and then edit all the required rows. a lot of human glue and a lot of room for human error.

I'm wondering if python can help here? given some source tables, can it create a final edit table with all permutations? I'm able to run a query and get a list of all [Items | Plans | subgroup], basically a pivot summary.

Here's an example of what I'm looking at. first pic: a pivot summary of permutations of Item|Plan|SubGroup. noting that not all Items are in all Plans and not all SubGroups are in all Plans.

pivot summary of Item|Plan|SubGroup
[Image: 75OED.png]

Second table is an example of how the Operators manage the limits, on an excel sheet for easy reference.

Limits table
[Image: v5sw9.png]

The result I'm trying to figure out is how to script so that there's a final output table with all permutations of the source tables.

Any advice on where to start with this in Python? (or if there's a better way?)
Reply


Messages In This Thread
Python script to summarize excel tables, then output a composite table? i'm a total n - by surfer349 - Feb-04-2021, 09:15 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  tables in Excel MaartenRo 3 479 Jan-06-2024, 03:46 PM
Last Post: deanhystad
  Better python library to create ER Diagram by using pandas data frames as tables klllmmm 0 992 Oct-19-2023, 01:01 PM
Last Post: klllmmm
  How to summarize an article that is stored in a word document on your laptop? Mikedicenso87 2 615 Oct-06-2023, 12:07 PM
Last Post: Mikedicenso87
  Is there a *.bat DOS batch script to *.py Python Script converter? pstein 3 3,010 Jun-29-2023, 11:57 AM
Last Post: gologica
  python script for inserting rows into hbase table lravikumarvsp 7 7,013 Mar-24-2023, 04:44 AM
Last Post: parth_botadara
  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
Question Export Python output to Excel skyline1397 1 1,985 Jun-26-2022, 05:10 AM
Last Post: skyline1397
  Trying to use 2 values from excel in my script but getting error.. cubangt 3 1,625 May-11-2022, 07:12 AM
Last Post: normanwolf
  Python Program to Find the Total Sum of a Nested List vlearner 8 4,819 Jan-23-2022, 07:20 PM
Last Post: menator01
  Slittping table into Multiple tables by rows drunkenneo 1 2,005 Oct-06-2021, 03:17 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

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