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',