<jupyter_start><jupyter_text>Reading  101 OBE Marksheet<jupyter_code>Evaluation ID, Student_Enrollment, Assessments ID, Obtain Marks<jupyter_output><empty_output><jupyter_text>import pandas as pdfile = pd.read_excel('CSE101 OBE Mark Sheet.xlsx') file.head() file.tail()  Taking columns for Q1mid_q1 = file.iloc[3:, :6]mid_q1.head()  Dropping 2 columns as we needed 4 columns q1 = mid_q1.drop(mid_q1.columns[[2,3]], axis= 1)q1.head()  Cnverting q1 as a listmidterm_q1_l = q1.values.tolist()print(midterm_q1_l[1])  To get question no. for assessments IDto_list = file.values.tolist()question_no = to_list[1:][0][5]print("Question number is: ",question_no) print(midterm_q1_l[3]) for i in range(len(midterm_q1_l)):    midterm_q1_l[i][0] = 10000 + i    midterm_q1_l[i][1] = 1000 + i    midterm_q1_l[i][2] = 'CSE101_Mid_' + question_no    As our assessments ID named like this    print(midterm_q1_l[1])      Converting list dataframedf = pd.DataFrame(midterm_q1_l,columns=['Evaluation ID', 'Student_Enrollment', 'Assessments ID', 'Obtain Marks'] )df.head() df.to_excel('evaluation_for_cse101_mid_q1.xlsx')<jupyter_code>Evaluation for question 2<jupyter_output><empty_output><jupyter_text>Taking columns for Q2mid_q2 = file.iloc[3:, :7]mid_q2.head()  Dropping 3 columns as we needed 4 columns q2 = mid_q2.drop(mid_q2.columns[[2,3,4]], axis= 1)q2.head()  Cnverting q2 as a listmidterm_q2_l = q2.values.tolist()print(midterm_q2_l[1])  To get question no. for assessments IDto_list = file.values.tolist()question_no = to_list[1:][0][6]          can be write as funtionprint("Question number is: ",question_no) for i in range(len(midterm_q2_l)):    midterm_q2_l[i][0] = 10000 + i    midterm_q2_l[i][1] = 1000 + i    midterm_q2_l[i][2] = 'CSE101_Mid_' + question_no    As our assessments ID named like this    print(midterm_q2_l[13])  Converting list dataframedf = pd.DataFrame(midterm_q2_l,columns=['Evaluation ID', 'Student_Enrollment', 'Assessments ID', 'Obtain Marks'] )df.head() df.to_excel('evaluation_for_cse101_mid_q2.xlsx')<jupyter_code>Evaluation for question 3<jupyter_output><empty_output><jupyter_text>Taking columns for Q3mid_q3 = file.iloc[3:, :8]mid_q3.head()  Dropping 4 columns as we needed 4 columns q3 = mid_q3.drop(mid_q3.columns[[2,3,4,5]], axis= 1)q3.head()  Function to get question numberdef get_question_no(file, column_number):    to_list = file.values.tolist()                       file is the full data which we loaded first    question_no = to_list[1:][0][column_number]          can be write as funtion    print("Question number is: ",question_no)    return question_no mid_question_3 = get_question_no(file, 7)    q3 is on column 7print(mid_question_3)print(type(mid_question_3))  Function to modify column values for evaluationdef modify(evaluate_data, question_no, exam):    evaluate_data_l = evaluate_data.values.tolist()    print("Before: ", evaluate_data_l[0])    for i in range(len(evaluate_data_l)):        evaluate_data_l[i][0] = 10000 + i        evaluate_data_l[i][1] = 1000 + i        evaluate_data_l[i][2] = exam + question_no    As our assessments ID named like this    print('After: ', evaluate_data_l[0])    return evaluate_data_l    df = pd.DataFrame(evaluate_data_l,columns=['Evaluation ID', 'Student_Enrollment', 'Assessments ID', 'Obtain Marks'] )    return df     question_3 = modify(q3, mid_question_3, 'CSE101_Mid_')print(question_3[1]) question_3.head()  Saving as Excel sheetquestion_3.to_excel('evaluation_for_cse101_mid_q3.xlsx')<jupyter_code>Evaluation for Midterm question 4<jupyter_output><empty_output><jupyter_text>Taking columns for Q4mid_q4 = file.iloc[3:, :9]mid_q4.head()  Dropping 5 columns as we needed 4 columns q4 = mid_q4.drop(mid_q4.columns[[2,3,4,5,6]], axis= 1)q4.head()  Getting question numbermid_question_4 = get_question_no(file, 8)    q4 is on column 8print(mid_question_4)  Modify column valuesquestion_4 = modify(q4, mid_question_4, 'CSE101_Mid_')  printing the modified dataquestion_4.head()  Saving as Excel sheetquestion_4.to_excel('evaluation_for_cse101_mid_q4.xlsx')<jupyter_code>Evaluation for question 5<jupyter_output><empty_output><jupyter_text>Taking columns for Q5mid_q5 = file.iloc[3:, :10]mid_q5.head()  Dropping 6 columns as we needed 4 columns q5 = mid_q5.drop(mid_q5.columns[[2,3,4,5,6,7]], axis= 1)q5.head()  Getting question numbermid_question_5 = get_question_no(file, 9)    q5 is on column 9print(mid_question_5)  Modify column valuesquestion_5 = modify(q5, mid_question_5, 'CSE101_Mid_')  printing the modified dataquestion_5.head()  Saving as Excel sheetquestion_5.to_excel('evaluation_for_cse101_mid_q5.xlsx')<jupyter_code>Evavulation question 6<jupyter_output><empty_output><jupyter_text>Taking columns for Q6mid_q6 = file.iloc[3:, :11]mid_q6.head()  Dropping 7 columns as we needed 4 columns q6 = mid_q6.drop(mid_q6.columns[[2,3,4,5,6,7,8]], axis= 1)q6.head()  Getting question numbermid_question_6 = get_question_no(file, 10)    q5 is on column 10print(mid_question_6)  Modify column valuesquestion_6 = modify(q6, mid_question_6, 'CSE101_Mid_') question_6.head()  Saving as Excel sheetquestion_6.to_excel('evaluation_for_cse101_mid_q6.xlsx')<jupyter_code>##### Evaluation For Final Questions<jupyter_output><empty_output><jupyter_text>file.head()  Taking columns for Q6final_index = file.iloc[0:, :14]final_index.head() final_index = file.iloc[0:, :18]final_index.head()  Final Questions starts with column 14 and ends with 17 Taking columns for Q1final_q1 = file.iloc[3:, :14]final_q1.head()  Dropping columns as we needed 4 columns fq1 = final_q1.drop(final_q1.columns[[2,3,4,5,6,7,8, 9, 10, 11]], axis= 1)fq1.head(20)  Getting question numberfinal_question_1 = get_question_no(file, 13)    q1 is on column 13print(final_question_1)  Modify column valuesf_question_1 = modify(fq1, final_question_1, 'CSE101_Final_') f_question_1.head()  Saving as Excel sheetf_question_1.to_excel('evaluation_for_cse101_final_q1.xlsx')<jupyter_code>Evaluation final question 2<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.11573146292585171, 'fraction_numerical': 0.05494321977287909, 'mean_word_length': 6.4582814445828145, 'pattern_counts': {'":': 0, '<': 33, '<?xml version=': 0, '>': 33, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '8', 'dir': 'jupyter-structured-clean-dedup', 'id': '36982', 'license': 'MIT', 'n_tokens_mistral': 2402, 'n_tokens_neox': 2247, 'n_words': 477, 'path': 'data_input_files_scripts/.ipynb_checkpoints/evaluation_cse101-checkpoint.ipynb', 'repo_name': 'shuvo03/CSE_303_SEC_02_GROUP_07', 'size': '5988'}