import numpy as np
import pandas as pd
df = pd.read_csv("stat.csv")
df
df = df.drop(df.index[1])
df = df.drop(df.index[0])
df = df.reset_index(drop = True)
df
def comparison(text1 , text2):
text1 = text1.lower()
text1 = text1.split(" ")
text2 = text2.lower()
text2 = text2.split(" ")
k = 0
if len(text1) == len(text2):
for i in range(0, len(text1)):
if text1[i] == text2[i]:
k +=1
if k == len(text2):
return 1
else:
return 0
else:
return 0
cols = df.columns
cols=[c for c in cols if 'Q' in c]
cols = [c for c in cols if '_' not in c]
len(cols)
df1 = pd.DataFrame(columns = cols)
for i in df.index:
for j in cols:
df1.loc[i,j]= df.loc[i,j]
df1
df1 = df1.fillna(0)
df1
list1 = df1[df1.columns[1]].unique()
if len(list1) == 2:
del df1[df1.columns[1]]
cols2 = cols[2:]
else:
cols2 = cols[1:]
#df1["Q7"].astype("str")
for i in df1.columns:
df1[i] = df1[i].astype(str)
key = pd.read_csv("key.csv")
key["Key"] = key["Key"].astype(str)
key_list = list(key["Key"])
key_list
for i in df1.index:
k = 0
for j in cols2:
df1.loc[i, j] = comparison(df1.loc[i, j], key_list[k])
k +=1
df1
for i in df1.index:
temp = 0
for j in cols2:
temp = temp + pd.to_numeric(df1.loc[i, j])
df1.loc[i, "grade"] = temp
df1
from datetime import datetime
date = datetime.today().strftime('%Y-%m-%d')
text = "Grade_" + date + ".csv"
df1.to_csv(text, index = False)
print("Done")
grade_list= pd.read_csv("total.csv")
grade_list
y = 0
text = "Grade_" + date
for i in grade_list.index:
y= 0
id2 = grade_list.loc[i, "id"]
for j in df1.index:
id1 = df1.loc[j, df1.columns[0]]
if comparison(id1, id2) == 1:
grade_list.loc[i, "grade"] = df1.loc[j, "grade"] + grade_list.loc[i, "grade"]
grade_list.loc[i, text] = df1.loc[j, "grade"]
j = df1.index -1
y = 1
if y == 0:
grade_list.loc[i, text] = "a"
grade_list.to_csv("total.csv", index = False)