a = weeksEventLog_filtered_pageType[6].sort_values(
['case:concept:name', 'time:timestamp'])
dataUpload = pd.read_csv(basePath + 'ca177_uploads.csv')
dataUpload['date'] = pd.to_datetime(dataUpload.date)
exUpload = dataUpload.loc[dataUpload['task'].str.match('ex')]
ex1 = exUpload.loc[exUpload['task'].str.match('ex1')]
ex1 = ex1.sort_values(by=['user', 'task'])
ex1 = ex1.groupby([pd.Grouper(key='user'), pd.Grouper(key='task')]).sum()
ex2 = exUpload.loc[exUpload['task'].str.match('ex2')]
ex2 = ex2.sort_values(by=['user', 'task'])
ex2 = ex2.groupby([pd.Grouper(key='user'), pd.Grouper(key='task')]).sum()
assessment1A = dataProcessing.assessmentConstruction(ex1, 4)
assessment1A['adjustedPerformance'] = (assessment1A['perCorrect'] +
assessment1A['perPassed']) / 2
assessment2A = dataProcessing.assessmentConstruction(ex2, 4)
assessment2A['adjustedPerformance'] = (assessment2A['perCorrect'] +
assessment2A['perPassed']) / 2
assessment1A.rename(columns={
'correct': 'correct1A',
'perCorrect': 'perCorrect1A',
'failed': 'failed1A',
'passed': 'passed1A',
'perPassed': 'perPassed1A',
'testSubmitted': 'testSubmitted1A',
'adjustedPerformance': 'adjustedPerformance1A'
},
exUpload = dataUpload.loc[dataUpload['task'].str.match('ex')]
ex1 = exUpload.loc[exUpload['task'].str.match('ex1')]
ex1 = ex1.sort_values(by=['user','task'])
ex1 = ex1.groupby([pd.Grouper(key='user'),pd.Grouper(key='task')]).sum()
ex2 = exUpload.loc[exUpload['task'].str.match('ex2')]
ex2 = ex2.sort_values(by=['user','task'])
ex2 = ex2.groupby([pd.Grouper(key='user'),pd.Grouper(key='task')]).sum()
ex3 = exUpload.loc[exUpload['task'].str.match('ex3')]
ex3 = ex3.sort_values(by=['user','task'])
ex3 = ex3.groupby([pd.Grouper(key='user'),pd.Grouper(key='task')]).sum()
# ex4 = exUpload.loc[exUpload['task'].str.match('ex4')]
# ex4 = ex4.sort_values(by=['user','task'])
# ex4 = ex4.groupby([pd.Grouper(key='user'),pd.Grouper(key='task')]).sum()
assessment1A = dataProcessing.assessmentConstruction(ex1,2)
assessment1A['adjustedPerformance'] = (assessment1A['perCorrect'] + assessment1A['perPassed'])/2
assessment2A = dataProcessing.assessmentConstruction(ex2,6)
assessment2A['adjustedPerformance'] = (assessment2A['perCorrect'] + assessment2A['perPassed'])/2
assessment3A = dataProcessing.assessmentConstruction(ex3,6)
assessment3A['adjustedPerformance'] = (assessment3A['perCorrect'] + assessment3A['perPassed'])/2
assessment1A.rename(columns={'correct':'correct1A',
'perCorrect':'perCorrect1A',
'failed':'failed1A',
'passed':'passed1A',
'perPassed':'perPassed1A',
'testSubmitted':'testSubmitted1A',
'adjustedPerformance':'adjustedPerformance1A'},
inplace=True)
assessment2A.rename(columns={'correct':'correct2A',
