# Let's inspect the excel file to see if numbers/credits/hours are already included, or if we should update it to include Course Credits, Lecture Hours, and Laboratory Hours columns.
import pandas as pd
# Let's load the excel file we created or re-examine the images to ensure all credit and hour columns are captured and properly formatted.
# From the images:
# Image 1 & 3 & 6: Course Credits, Lecture Hour(s), Laboratory Hour(s), Tuition Hour(s)
# Let's write a python script to check and update the dataframe with the credit/hour details if needed.
df = pd.read_excel("Academic_Registration_Data.xlsx")
print(df.columns)
Index(['Semester', 'Course Code', 'Course Title', 'Pre-requisite'], dtype='object')
# Let's enrich the dataset with Course Credits, Lecture Hours, and Laboratory Hours based on the written handwriting in the images for each course.
enriched_data = [
{"Semester": "3rd Year, 1st Semester", "Course Code": "MANA 2053", "Course Title": "Total Quality Management", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 1st Semester", "Course Code": "PHIL 1013", "Course Title": "Logic", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 1st Semester", "Course Code": "COMP 2083", "Course Title": "Technical and Documentation Skills in ICT", "Pre-requisite": "ENGL 1033", "Credits": 3, "Lec Hours": 2, "Lab Hours": 3},
{"Semester": "3rd Year, 1st Semester", "Course Code": "COMP 2113", "Course Title": "Advanced Programming", "Pre-requisite": "COMP 2103", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 1st Semester", "Course Code": "INTE 3013", "Course Title": "Multimedia", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 2, "Lab Hours": 3},
{"Semester": "3rd Year, 1st Semester", "Course Code": "INTE 3033", "Course Title": "Database Management System 2", "Pre-requisite": "INTE 3023", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 1st Semester", "Course Code": "COMP 4023", "Course Title": "Database Administration", "Pre-requisite": "INTE 3023", "Credits": 3, "Lec Hours": 2, "Lab Hours": 3},
{"Semester": "3rd Year, 1st Semester", "Course Code": "COMP 4163", "Course Title": "Fundamentals of Research", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 2nd Semester", "Course Code": "MANA 2053", "Course Title": "Total Quality Management", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 2nd Semester", "Course Code": "NASC 1093", "Course Title": "Ecology", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 2nd Semester", "Course Code": "HUMA 1043", "Course Title": "Introduction to the Humanities", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 2, "Lab Hours": 3},
{"Semester": "3rd Year, 2nd Semester", "Course Code": "COMP 3043", "Course Title": "Web Development and Programming", "Pre-requisite": "INTE 3043", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, 2nd Semester", "Course Code": "INTE 3043", "Course Title": "System Analysis and Design", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 2, "Lab Hours": 3},
{"Semester": "3rd Year, 2nd Semester", "Course Code": "Elective 4", "Course Title": "Elective 4", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "3rd Year, Summer", "Course Code": "Elective 2", "Course Title": "Elective 2", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 2, "Lab Hours": 3},
{"Semester": "4th Year, 1st Semester", "Course Code": "HIST 1023", "Course Title": "Buhay, Mga Gawain at Sinulat ni Rizal", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "4th Year, 1st Semester", "Course Code": "LITE 1023", "Course Title": "World Literature", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "4th Year, 1st Semester", "Course Code": "COMP 4183", "Course Title": "Capstone Project", "Pre-requisite": "INTE 3043", "Credits": 3, "Lec Hours": 2, "Lab Hours": 3},
{"Semester": "4th Year, 1st Semester", "Course Code": "COMP 2063", "Course Title": "Professional Ethics", "Pre-requisite": "NONE", "Credits": 3, "Lec Hours": 3, "Lab Hours": 0},
{"Semester": "4th Year, 2nd Semester", "Course Code": "INTE 4019", "Course Title": "Internship", "Pre-requisite": "All Major Subjects (1st-4th Year)", "Credits": 9, "Lec Hours": 9, "Lab Hours": 0}
]
df_enriched = pd.DataFrame(enriched_data)
df_enriched.to_excel("Academic_Registration_Data_With_Numbers.xlsx", index=False)
Oo nga pala, nakita ko rin ang mga numbers (Credits at Hours) sa mga hulihan ng pages! In-update ko na ang file para kasama na ang Course Credits, Lecture Hours, at Laboratory Hours para mas kumpleto para sa iyong Blogspot.
Na-update ko na rin ang Excel file mo dito: [file-tag: code-generated-file-d580b9fe-c9cc-4b73-a0db-786116ae61c5]
Maaari mo ring i-copy ang mas detalyadong table na ito para diretso sa iyong blog post:
| Semester | Course Code | Course Title | Pre-requisite | Credits | Lec Hours | Lab Hours |
|---|
| 3rd Year, 1st Sem | MANA 2053 | Total Quality Management | NONE | 3 | 3 | 0 |
| PHIL 1013 | Logic | NONE | 3 | 3 | 0 |
| COMP 2083 | Technical and Documentation Skills in ICT | ENGL 1033 | 3 | 2 | 3 |
| COMP 2113 | Advanced Programming | COMP 2103 | 3 | 3 | 0 |
| INTE 3013 | Multimedia | NONE | 3 | 2 | 3 |
| INTE 3033 | Database Management System 2 | INTE 3023 | 3 | 3 | 0 |
| COMP 4023 | Database Administration | INTE 3023 | 3 | 2 | 3 |
| COMP 4163 | Fundamentals of Research | NONE | 3 | 3 | 0 |
| 3rd Year, 2nd Sem | MANA 2053 | Total Quality Management | NONE | 3 | 3 | 0 |
| NASC 1093 | Ecology | NONE | 3 | 3 | 0 |
| HUMA 1043 | Introduction to the Humanities | NONE | 3 | 2 | 3 |
| COMP 3043 | Web Development and Programming | INTE 3043 | 3 | 3 | 0 |
| INTE 3043 | System Analysis and Design | NONE | 3 | 2 | 3 |
| Elective 4 | Elective 4 | NONE | 3 | 3 | 0 |
| 3rd Year, Summer | Elective 2 | Elective 2 | NONE | 3 | 2 | 3 |
| 4th Year, 1st Sem | HIST 1023 | Buhay, Mga Gawain at Sinulat ni Rizal | NONE | 3 | 3 | 0 |
| LITE 1023 | World Literature | NONE | 3 | 3 | 0 |
| COMP 4183 | Capstone Project | INTE 3043 | 3 | 2 | 3 |
| COMP 2063 | Professional Ethics | NONE | 3 | 3 | 0 |
| 4th Year, 2nd Sem | INTE 4019 | Internship | All Major Subjects | 9 | 9 | 0 |
Ayos na ba ang pagkaka-column nito para sa iyong Blogspot?
