def downloadCSV(): dfMaster = pd.read_csv("myProject/static/file/master.csv") dfClient = pd.read_csv("myProject/static/file/upload/client.csv", sep='\t') # get columns in client table data = [] vals = dfClient.values for row in vals: strs = row[0].split('|') data.append(strs) client_label = dfClient.columns.values[0].split('|') dfClient = pd.DataFrame(data, columns=client_label) # get columns in master table data = [] vals = dfMaster.values for row in vals: strs = row[0].split('|') data.append(strs) cols = dfMaster.columns.values[0].split('|') dfMaster = pd.DataFrame(data, columns=cols) keys = list(request.form.keys()) res_dict = {} newCols = [] for key in keys: if key != 'submit': res_dict[key] = request.form.get(key) newCols.append(request.form.get(key)) dfMerge = dfClient.copy() dfMerge.columns = newCols dfMerge.to_csv("myProject/static/file/matched.csv", index=False) return GetData(dfMerge)()
def downloadCSV(): newDF = pd.read_csv("myProject/static/file/data.csv") newDF['template'] = newDF['template'].str.upper() choices_t = request.values.getlist("choices") startDate = request.values.getlist("StartDate")[0] endDate = request.values.getlist("EndDate")[0] result = searchData(newDF)(choices_t,startDate,endDate) dfResult = result[5] return GetData(dfResult)()
def downloadAllReco(): # download the recommendation dfAllReco = pd.read_csv("myProject/static/file/allReco.csv") return GetData(dfAllReco)()
def downloadAuto(): df = pd.read_csv("myProject/static/file/autoRes.csv") return GetData(df)()
def downloadCom2(): df = pd.read_csv("myProject/static/file/comRes2.csv") return GetData(df)()
def downloadCus1(): df = pd.read_csv("myProject/static/file/cusRes1.csv") return GetData(df)()
def downloadQuery(): df = pd.read_csv("myProject/static/file/query.csv") return GetData(df)()
def downloadAllReco(): dfAllReco = pd.read_csv("myProject/static/file/allReco.csv") return GetData(dfAllReco)()