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)()