from pathlib import Path import time import parser import argparse import pandas as pd import numpy as np import warnings warnings.filterwarnings("ignore") parser = argparse.ArgumentParser(description='Process some integers.') parser.add_argument('path', help='define the directory to folder/file') parser.add_argument('--verbose', help='display processing information') start = time.time() def main(path_xlsm, verbose): if (".xlsm" in str(path_xlsm).lower()) and path_xlsm.is_file(): xlsm_files = [Path(path_xlsm)] else: xlsm_files = list(Path(path_xlsm).glob("*.xlsm")) df = pd.DataFrame() df3 = pd.DataFrame() df6 = pd.DataFrame() for fn in xlsm_files: all_dfs = pd.read_excel(fn, sheet_name=None, header=None, engine='openpyxl') list_data = all_dfs.keys() all_dfs.pop("Lookups", None) for ws in list_data: # Looping for excel sheet df1 = all_dfs[ws] # print(df1.iloc[7:,15:18]) df2 = df1.iloc[7:48, 16:68] # print(df2) # print(df2.iloc[:,0]) df2 = df2.dropna(how='all') # Drop rows where all rows Null df2 = df2.T.reset_index(drop=True).T # Reset Column Index df2 = df2.reset_index(drop=True) # Reset Row Index # print(df2) df3 = df1.iloc[24:43, 2:4] df3 = df3.rename(columns={2: 'HoleID', 3: 'Index'}) # print(df3) # if (1 in df3.iloc[:,1]): row_index_1 = df3.loc[df3.loc[:, 'Index'] == 1, 'Index'].first_valid_index() # if (2 in df3.iloc[:,1]): row_index_2 = df3.loc[df3.loc[:, 'Index'] == 2, 'Index'].first_valid_index() # if (3 in df3.iloc[:,1]): row_index_3 = df3.loc[df3.loc[:, 'Index'] == 3, 'Index'].first_valid_index() # if (4 in df3.iloc[:,1]): row_index_4 = df3.loc[df3.loc[:, 'Index'] == 4, 'Index'].first_valid_index() # if (5 in df3.iloc[:,1]): row_index_5 = df3.loc[df3.loc[:, 'Index'] == 5, 'Index'].first_valid_index() # if (6 in df3.iloc[:,1]): row_index_6 = df3.loc[df3.loc[:, 'Index'] == 6, 'Index'].first_valid_index() # if (7 in df3.iloc[:,1]): row_index_7 = df3.loc[df3.loc[:, 'Index'] == 7, 'Index'].first_valid_index() # if (8 in df3.iloc[:,1]): row_index_8 = df3.loc[df3.loc[:, 'Index'] == 8, 'Index'].first_valid_index() # if (9 in df3.iloc[:,1]): row_index_9 = df3.loc[df3.loc[:, 'Index'] == 9, 'Index'].first_valid_index() # if (10 in df3.iloc[:,1]): row_index_10 = df3.loc[df3.loc[:, 'Index'] == 10, 'Index'].first_valid_index() df_A = pd.DataFrame() df_B = pd.DataFrame() df_C = pd.DataFrame() df_D = pd.DataFrame() df_E = pd.DataFrame() df_F = pd.DataFrame() df_G = pd.DataFrame() df_H = pd.DataFrame() df_I = pd.DataFrame() df_J = pd.DataFrame() df_K = pd.DataFrame() Activities = [] TimeID = [] HoleID = [] Activities1 = [] TimeID1 = [] HoleID1 = [] Activities2 = [] TimeID2 = [] HoleID2 = [] Activities3 = [] TimeID3 = [] HoleID3 = [] Activities4 = [] TimeID4 = [] HoleID4 = [] Activities5 = [] TimeID5 = [] HoleID5 = [] Activities6 = [] TimeID6 = [] HoleID6 = [] Activities7 = [] TimeID7 = [] HoleID7 = [] Activities8 = [] TimeID8 = [] HoleID8 = [] Activities9 = [] TimeID9 = [] HoleID9 = [] Activities10 = [] TimeID10 = [] HoleID10 = [] for column in range(0, 52): # Column Loop for row in range(0, 35): # Row Loop if (df2.iloc[row, column] == 'X') or (df2.iloc[row, column] == 'x'): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append('NoHole') elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append('NoHole') if (df2.iloc[row, column] == '1') or (df2.iloc[row, column] == 1): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_1][0]) if (df2.iloc[row, column] == '2') or (df2.iloc[row, column] == 2): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_2][0]) if (df2.iloc[row, column] == '3') or (df2.iloc[row, column] == 3): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_3][0]) if (df2.iloc[row, column] == '4') or (df2.iloc[row, column] == 4): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) if (df2.iloc[row, column] == '5') or (df2.iloc[row, column] == 5): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_4][0]) if (df2.iloc[row, column] == '5') or (df2.iloc[row, column] == 5): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_5][0]) if (df2.iloc[row, column] == '6') or (df2.iloc[row, column] == 6): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_6][0]) if (df2.iloc[row, column] == '7') or (df2.iloc[row, column] == 7): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_7][0]) if (df2.iloc[row, column] == '8') or (df2.iloc[row, column] == 8): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_8][0]) if (df2.iloc[row, column] == '9') or (df2.iloc[row, column] == 9): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_9][0]) if (df2.iloc[row, column] == '10') or (df2.iloc[row, column] == 10): if row == 0: Activities.append(df2.iloc[0, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 1: Activities.append(df2.iloc[1, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 2: Activities.append(df2.iloc[2, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 3: Activities.append(df2.iloc[3, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 4: Activities.append(df2.iloc[4, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 5: Activities.append(df2.iloc[5, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 6: Activities.append(df2.iloc[6, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 7: Activities.append(df2.iloc[7, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 8: Activities.append(df2.iloc[8, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 9: Activities.append(df2.iloc[9, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 10: Activities.append(df2.iloc[10, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 11: Activities.append(df2.iloc[11, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 12: Activities.append(df2.iloc[12, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 13: Activities.append(df2.iloc[13, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 14: Activities.append(df2.iloc[14, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 15: Activities.append(df2.iloc[15, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 16: Activities.append(df2.iloc[16, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 17: Activities.append(df2.iloc[17, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 18: Activities.append(df2.iloc[18, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 19: Activities.append(df2.iloc[19, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 20: Activities.append(df2.iloc[20, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 21: Activities.append(df2.iloc[21, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 22: Activities.append(df2.iloc[22, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 23: Activities.append(df2.iloc[23, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 24: Activities.append(df2.iloc[24, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 25: Activities.append(df2.iloc[25, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 26: Activities.append(df2.iloc[26, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 27: Activities.append(df2.iloc[27, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 28: Activities.append(df2.iloc[28, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 29: Activities.append(df2.iloc[29, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 30: Activities.append(df2.iloc[30, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 31: Activities.append(df2.iloc[31, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 32: Activities.append(df2.iloc[32, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 33: Activities.append(df2.iloc[33, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 34: Activities.append(df2.iloc[34, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 35: Activities.append(df2.iloc[35, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 36: Activities.append(df2.iloc[36, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 37: Activities.append(df2.iloc[37, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 38: Activities.append(df2.iloc[38, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 39: Activities.append(df2.iloc[39, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 40: Activities.append(df2.iloc[40, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) elif row == 41: Activities.append(df2.iloc[41, 0]) TimeID.append(column+1) HoleID.append(df3.loc[row_index_10][0]) df_A['Activity'] = Activities df_A['TimeID'] = TimeID df_A['HoleID'] = HoleID df_B['Activity'] = Activities1 df_B['TimeID'] = TimeID1 df_B['HoleID'] = HoleID1 df_C['Activity'] = Activities2 df_C['TimeID'] = TimeID2 df_C['HoleID'] = HoleID2 df_D['Activity'] = Activities3 df_D['TimeID'] = TimeID3 df_D['HoleID'] = HoleID3 df_E['Activity'] = Activities4 df_E['TimeID'] = TimeID4 df_E['HoleID'] = HoleID4 df_F['Activity'] = Activities5 df_F['TimeID'] = TimeID5 df_F['HoleID'] = HoleID5 df_G['Activity'] = Activities6 df_G['TimeID'] = TimeID6 df_G['HoleID'] = HoleID6 df_H['Activity'] = Activities7 df_H['TimeID'] = TimeID7 df_H['HoleID'] = HoleID7 df_I['Activity'] = Activities8 df_I['TimeID'] = TimeID8 df_I['HoleID'] = HoleID8 df_J['Activity'] = Activities9 df_J['TimeID'] = TimeID9 df_J['HoleID'] = HoleID9 df_K['Activity'] = Activities10 df_K['TimeID'] = TimeID10 df_K['HoleID'] = HoleID10 df = pd.concat([df_A, df_B, df_C, df_D, df_E, df_F, df_G, df_H, df_I, df_J, df_K], axis=0, ignore_index=True) df = df.assign(PlodDate=df1.iloc[1, 8]) df = df.assign(PlodShift=df1.iloc[3, 8]) df = df.assign(ContractNo=df1.iloc[2, 4]) df = df.assign(RigNo=df1.iloc[5, 8]) df = df.assign(DataSource=Path(fn.name)) df = df[["PlodDate", "PlodShift", "ContractNo", "RigNo", "HoleID", "Activity", "TimeID", "DataSource"]] df['Activity'] = df['Activity'].apply( lambda x: x.replace("nan -", "")) df['Activity'] = df['Activity'].apply( lambda x: str(x.encode("ascii", "ignore"), "utf-8")) df['Activity'] = df['Activity'].replace(r'^ -', '', regex=True) df = df.replace(',', ';', regex=True) df = df.replace('\n', ' ', regex=True) df = df.replace('\r', ' ', regex=True) df = df.replace('\t', ' ', regex=True) df6 = df6.append(df) df6.to_csv('CDActivities.csv', index=False) if __name__ == "__main__": start = time.time() args = parser.parse_args() path = Path(args.path) verbose = args.verbose main(path, verbose) print("Processed time", time.time()-start)