Skip to content
Snippets Groups Projects
Select Git revision
  • fa220f42e90cc2145621e0a0ff45016083ae0e45
  • main default protected
2 results

matrices.py

Blame
    • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    matrices.py 3.11 KiB
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66 
    

    

    

    import pandas as pd
import ERFormatConstants as const

def parseTable(df):
    
    cols = [const.Er_ID, const.Bowtie_ID, const.Metric_ID, const.Metric_Name, const.Value, const.Measure_date, const.Frequency ,const.Measurement_guide]
        
    table = df.loc[df[const.Name]=='Table']    # Defines the table
    
    matrics = pd.DataFrame(columns=cols)

    
    # ! Parsing the first row of the table which has a fucked structure because lucidchart is garbage : ) 
    erID1 = table[const.textArea4].item()              # Define the ER ID
    BowTieID1 = table[const.textArea5].item()          # Define the Bowtie ID
    MetricID1 = table[const.textArea6].item()          # Define the Metric ID
    MetricName1 = table[const.textArea11].item()        # Define the Metric Name
    Value1 = table[const.textArea14].item()            # Define the Value
    MeasureDate1 = table[const.textArea17].item()      # Define the Measure Date
    Frequency1 = table[const.textArea20].item()        # Define the Frequency
    Guide1 = table[const.textArea23].item()            # Define the Measurement guide
    
    
    matrics.loc[0] = erID1, BowTieID1, MetricID1, MetricName1, Value1, MeasureDate1, Frequency1, Guide1
    

    
    erID2 = table[const.textArea7].item()              # Define the ER ID
    BowTieID2 = table[const.textArea8].item()          # Define the Bowtie ID
    MetricID2 = table[const.textArea9].item()          # Define the Metric ID
    MetricName2 = table[const.textArea12].item()        # Define the Metric Name
    Value2 = table[const.textArea15].item()            # Define the Value
    MeasureDate2 = table[const.textArea18].item()      # Define the Measure Date
    Frequency2 = table[const.textArea21].item()        # Define the Frequency
    Guide2 = table[const.textArea24].item()            # Define the Measurement guide    
    
    matrics.loc[1] = erID2, BowTieID2, MetricID2, MetricName2, Value2, MeasureDate2, Frequency2, Guide2
    
        
    matricsIndex = 1

    for i in range(25, len(table.columns), 8):
        if pd.isnull(table["Text Area "+str(i)].item()) == True:
            break
        
        erID = table["Text Area "+str(i)].item()              # Define the ER ID
        BowTieID = table["Text Area "+str(i+1)].item()          # Define the Bowtie ID
        MetricID = table["Text Area "+str(i+2)].item()          # Define the Metric ID
        MetricName = table["Text Area "+str(i+3)].item()        # Define the Metric Name
        Value = table["Text Area "+str(i+4)].item()             # Define the Value
        MeasureDate = table["Text Area "+str(i+5)].item()       # Define the Measure Date
        Frequency = table["Text Area "+str(i+6)].item()         # Define the Frequency
        Guide = table["Text Area "+str(i+7)].item()            # Define the Measurement guide
        
        series = pd.Series([erID, BowTieID, MetricID, MetricName, Value, MeasureDate, Frequency, Guide])
        
        matrics.loc[matricsIndex] = erID, BowTieID, MetricID, MetricName, Value, MeasureDate, Frequency, Guide
        matricsIndex += 1
        
    print(matrics)