-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathanalysis_log.txt
More file actions
68 lines (65 loc) · 8.07 KB
/
analysis_log.txt
File metadata and controls
68 lines (65 loc) · 8.07 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
2025-05-08 23:08:57,240 - INFO - Processing data\downloads\2021SeniorSecondaryCompletionAndAchievementInformation.csv...
2025-05-08 23:08:57,259 - INFO - Successfully processed data\downloads\2021SeniorSecondaryCompletionAndAchievementInformation.csv. Shape: (590, 6)
2025-05-08 23:08:57,260 - INFO - Processing data\downloads\2022SeniorSecondaryCompletionAndAchievementInformation.csv...
2025-05-08 23:08:57,270 - INFO - Successfully processed data\downloads\2022SeniorSecondaryCompletionAndAchievementInformation.csv. Shape: (587, 6)
2025-05-08 23:08:57,270 - INFO - Processing data\downloads\2023SeniorSecondaryCompletionAndAchievementInformation.csv...
2025-05-08 23:08:57,284 - INFO - Successfully processed data\downloads\2023SeniorSecondaryCompletionAndAchievementInformation.csv. Shape: (598, 6)
2025-05-08 23:08:57,284 - INFO - Processing data\downloads\2024SeniorSecondaryCompletionAndAchievementInformation.csv...
2025-05-08 23:08:57,294 - INFO - DEBUG: Checking for 'Elevation Secondary College' in raw 2024 data (shape: (602, 23))
2025-05-08 23:08:57,296 - INFO - DEBUG: Found 'Elevation Secondary College' in raw 2024 df via mapped 'School' column:
2025-05-08 23:08:57,306 - INFO - School Small School Locality Number of VCE, VCE Vocational Major (VM) studies and VCE VET programs at Units 3 and 4 level with enrolments Number of Vocational Education and Training (VET) certificates with enrolments Number of Higher Education studies (HES) with enrolments Enrolment(s) in VCE Vocational Major (VM) unit(s)\u200b Enrolment(s) in the Victorian Pathways Certificate (VPC) Enrolment(s) in the International Baccalaureate (IB) Diploma Enrolment(s) in Northern Hemisphere Timetable (NHT) delivery at Units 3 and 4 level \u200b Number of students enrolled in at least one VCE or VCE Vocational Major (VM) study or VCE VET program at Units 3 and 4 level Number of students enrolled in a Vocational Education and Training (VET) certificate Number of students enrolled in an School-based Apprenticeship or Traineeship (SBAT) Number of students enrolled in a Higher Education study (HES) Percentage of VCE students applying for tertiary places through the Victorian Tertiary Admissions Centre (VTAC) Percentage of satisfactory VCE completions Number of students awarded the VCE Vocational Major (VM) Number of students awarded the VCE (Baccalaureate) Percentage of Vocational Education and Training (VET) units of competency completed Percentage of Higher Education studies (HES) completed Median VCE study score Percentage of study scores of 40 and over Number of students awarded the Victorian Pathways Certificate (VPC)
158 Elevation Secondary College NaN CRAIGIEBURN 9 18 - NaN NaN NaN NaN 55 100 4 - - - - - 66 - 30 9.4 -
2025-05-08 23:08:57,309 - INFO -
DEBUG (2024): ESC status BEFORE dropna(['School']):
2025-05-08 23:08:57,311 - INFO - School Median_VCE_Score Pct_Scores_40_Plus Completion_Rate Tertiary_Application_Rate
158 Elevation Secondary College 30.0 9.4 NaN NaN
2025-05-08 23:08:57,312 - INFO - DEBUG (2024): ESC 'School' column value: 'Elevation Secondary College', type: <class 'str'>, pd.isna: False
2025-05-08 23:08:57,312 - INFO -
DEBUG (2024): df_selected dtypes JUST BEFORE dropna:
2025-05-08 23:08:57,312 - INFO - School object
Median_VCE_Score float64
Pct_Scores_40_Plus float64
Completion_Rate float64
Tertiary_Application_Rate float64
Year int64
2025-05-08 23:08:57,314 - INFO - DEBUG (2024): ESC School value FINAL CHECK JUST BEFORE dropna: 'Elevation Secondary College', type: <class 'str'>, pd.isna: False
2025-05-08 23:08:57,315 - INFO - DEBUG: Checking for 'Elevation Secondary College' in processed 2024 df_selected (shape: (602, 6))
2025-05-08 23:08:57,316 - INFO - DEBUG: Found 'Elevation Secondary College' in processed 2024 df_selected:
2025-05-08 23:08:57,318 - INFO - School Median_VCE_Score Pct_Scores_40_Plus Completion_Rate Tertiary_Application_Rate Year
158 Elevation Secondary College 30.0 9.4 NaN NaN 2024
2025-05-08 23:08:57,318 - INFO - Successfully processed data\downloads\2024SeniorSecondaryCompletionAndAchievementInformation.csv. Shape: (602, 6)
2025-05-08 23:08:57,318 - INFO -
Combined data shape: (2377, 6)
2025-05-08 23:08:57,318 - INFO -
First 5 rows of combined data:
2025-05-08 23:08:57,320 - INFO - School Median_VCE_Score Pct_Scores_40_Plus Completion_Rate Tertiary_Application_Rate Year
0 Academy of Mary Immaculate 30.0 6.5 100.0 94.0 2021
1 Adass Israel School NaN NaN NaN NaN 2021
2 Adass Israel School NaN NaN NaN NaN 2021
3 Advance College of Education NaN NaN NaN NaN 2021
4 Aitken College 28.0 2.7 98.0 94.2 2021
2025-05-08 23:08:57,320 - INFO -
Last 5 rows of combined data:
2025-05-08 23:08:57,323 - INFO - School Median_VCE_Score Pct_Scores_40_Plus Completion_Rate Tertiary_Application_Rate Year
2372 Yarrawonga College P-12 28.0 1.3 100.0 55.3 2024
2373 Yea High School 25.0 0.0 86.0 43.2 2024
2374 Yeshivah College 37.0 25.3 100.0 94.7 2024
2375 Yesodei HaTorah College 28.0 7.9 100.0 62.5 2024
2376 Youth2Industry College NaN NaN 89.0 26.3 2024
2025-05-08 23:08:57,324 - INFO -
Info on combined data:
2025-05-08 23:08:57,330 - INFO - <class 'pandas.core.frame.DataFrame'>
RangeIndex: 2377 entries, 0 to 2376
Data columns (total 6 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 School 2377 non-null object
1 Median_VCE_Score 2158 non-null float64
2 Pct_Scores_40_Plus 2101 non-null float64
3 Completion_Rate 2235 non-null float64
4 Tertiary_Application_Rate 2192 non-null float64
5 Year 2377 non-null int64
dtypes: float64(4), int64(1), object(1)
memory usage: 111.5+ KB
2025-05-08 23:08:57,345 - INFO -
Combined data saved to 'data\downloads\combined_school_metrics.csv'