def main():
listOfConfigFile = py.setUpConfigFile("ConfigForARTY.txt")
historicData = pd.read_excel(listOfConfigFile[0])
files = os.listdir(listOfConfigFile[1])
cwd = os.getcwd()
print("Files in '%s': %s" % (cwd, files))
files_xlsx = [f for f in files if f[-4:] == 'xlsx']
for f in files_xlsx:
data = pd.read_excel(listOfConfigFile[1] + "\\" + f, 'Sheet1')
col = data.at[1, 'COLLECTED_DATE']
print(col)
col = datetime.strptime(col, '%d-%m-%Y %H:%M:%S')
col = col + timedelta(hours=8)
datenow = col.date()
timenow = col.time()
timeSlot = timeBetween(timenow)
dataEntire = data
data = py.doExclude(data, 'CATEGORY', ["Valid Open"])
nonValidCount = len(data.index)
a = ARTY.ARTY(data, dataEntire)
a.makeReport()
a.makeTriage()
"""
def main(self):
self.listOfConfigFile = py.setUpConfigFile("ConfigForARTY.txt")
self.dfMainReport = pd.read_excel(self.listOfConfigFile[3])
print(self.listOfConfigFile[3])
self.makeReport()
self.browser()
def __init__(self,UIMTriage):
self.UIM = UIMTriage
self.listOfConfigFile = py.setUpConfigFile("ConfigForARTY.txt")
def __init__(self,dfOSM):
self.OSM = dfOSM
self.listOfConfigFile = py.setUpConfigFile("ConfigForARTY.txt")
def __init__(self,df,dfEntire):
self.dfMainReport = df
self.EntireSheet = dfEntire
self.listOfConfigFile = py.setUpConfigFile("ConfigForARTY.txt")
def __init__(self, dfBilling):
self.Billing = dfBilling
self.listOfConfigFile = py.setUpConfigFile("ConfigForARTY.txt")