Avoid deeply nested control flow statements.

Open

                    if r[2] == row_loc:
                        amt += get_num_from_curr(r[4])
            tbl_agg.append([row_worker, row_loc, amt])

Avoid deeply nested control flow statements.

Open

                        if lst['name'] != 'INT':
                            if lst['name'] == self.colTypes[c]:
                                txt = get_rand_text_from_list(lst['lst'])
                thisRow.append(txt)

Function save_table has 5 arguments (exceeds 4 allowed). Consider refactoring.

Open

def save_table(tbl, hdr, fname, delim=',', qu='"'):

Function rebuild_index has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

def rebuild_index():
    """
    scans rawdata\data\ folders to create lookups
    of all tables, column names
    """

• Read up
  Read up

Function main has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

def main():
    """
    run in a loop and log the caption of the 
    active window every second. Save to disk
    each minute

• Read up
  Read up

Function identify_grain_csv has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

def identify_grain_csv(fname):
    """
    get counts in all columns until matched count(*)
    to guess the grain of the current table
    """

• Read up
  Read up

Function __str__ has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

    def __str__(self):
        res = ''
        res += 'name  = ' +  self.trend_dict['name'] + '\n'
        res += 'scale = ' + self.trend_dict['scale'] + '\n'
        res += 'trend = ' 

• Read up
  Read up

Function __init__ has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

    def __init__(self, root_path):
        self.sample_list = []      # filelist = [shortname, fullpath]
        self.samples = []          # list of Sample objects
        self.root_path = root_path # os.getcwd() + os.sep + 'samples'
        for root, _, files in os.walk(self.root_path):

• Read up
  Read up

Function load_from_file has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

    def load_from_file(self, fname, delim=',', quote='"'):
        """
        recreates the internal table tbl from an external file
        Use this for sample data generation based on existing 
        data or for extracting unique lists (ie categories from

• Read up
  Read up

Function agg_3 has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

def agg_3(tbl, colLabel):    
    # Table 3 - grain_year.csv
    # has one record for every year
    tbl_agg = []
    for row_year in years:

• Read up
  Read up

Function get_dual_col_counts has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

def get_dual_col_counts(tbl):
    """
    get counts by 2 cols of a table
        Grain of grain_year.csv is :  DATE, Total Amount,
        dual col: DATE,Total Amount

• Read up
  Read up

Function __init__ has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

    def __init__(self, mult_range, exp_range, num_terms=3):
        self.num_terms = num_terms
        self.equation = ''
        self.mult = [random.randint(mult_range[0], mult_range[1] ) for _ in range(self.num_terms + 1)]
        self.expt = [random.randint(exp_range[0], exp_range[1]) for _ in range(self.num_terms + 1)]

• Read up
  Read up

Function agg_2 has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

def agg_2(tbl, colLabel):    
    # Table 2 - grain_person_year.csv
    # has one record for every person per year
    tbl_agg = []
    for row_worker in workers:

• Read up
  Read up

Function get_index_terms has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

def get_index_terms(fname):
    """
    reads the file 'fname' and returns all index values
    for it in terms of fname.col_name, e.g.
    finance_transactions.transaction_type

• Read up
  Read up