This programming Assignment focuses on the usage of Data Wrangling and Visualization.
- Problem: ECE Board EXAM PROBLEM
- Excel Data
- This section initiates the variables in order to run the program given. The student first initiated the required function and library such as the Pandas and the Matplotlib as these 2 will be used in order to generate graph (Matplotlib) and data sets (Pandas).
- The student then run the excel file sheet in order to complete the requirement. The first requirement was to run the "board2.xlx" file to which after running the file, it will list the grade rankings of ECE board examinees from Luzon, Visayas, and Minadano.
- The table is required as it allows data sets, sorting, filtering, data, and data visualization.
- Table sorting (From Least, Greater, or Equal to)
- The section has 2 filter and 1 calculation.
- The first filter focuses on the hometown of Visayas. This code filters out examinees from Visayas region with less than 70 (<70) in Math. This code allows to filter out unrelated examinees which is required for the given question.
- The second filter focuses on the hometown of Luzon. This code filters out the examinees from Luzon region with less than 70 in Electronics and presents examinees with greater than 70 in Electronics.
- Saved through the use of ".to_csv". This will save the dataset and will allow the file to be accessed again. Without this code, the file may be corrupted or not runnable. Can also serve as a temporary file name/checkpoint
- The third one focuses on the calculation. The code calculates the average grade of the 4 subjects [Math, GEAS, COMMUNICATION, ELECTRONICS]. The mean should be greater than or equal to 55 (>= 55) to which it will show the examinees that are >=55 and will filter out examinees that are <55 from all the region.
- Graph By Tracks
- This section presents the graph of the track.
- This shows the percentage of examinees' track across the different region. The Graph shows three different treacks, Communication, Instrumentation, Microelectronics.
- The code included graph colors to show the differences between the 3 and provide the needed problem requirement, average by track.
- Graph By Gender
- This Section presents the graph of the examinee's gender.
- This shows the percentage of Male and Female examinees. The results show that both Male and Female are equal, no dominant gender across all region.
- The code included graph colors to show the difference between the 2 graph and provide the needed problem requirement, average by gender.
- Graph By Hometown
- This section presents the graph of the examinee's region.
- This shows the percentage of examinees from Luzon, Visayas, and Mindanao. The results show that Luzon has the most examinees, followed by Mindanao and Visayas.
- The code included graph colors in the theme of the Philippines and provide the needed problem requirement, average by hometown.
- Saved through the use of ".to_csv". This will save the dataset and will allow the file to be accessed again. Without this code, the file may be corrupted or not runnable. Can also serve as a temporary file name/checkpoint
- End of Repository and Program functionality.