SAE 1.05 – data Processing
The objectives of the SAE
The SAE has a main objective to allow the discovery and implementation of a first computer network functional.
More specifically, the CAS aims to :
Extract and filter structured data from a filer .csv
Develop a Python program modular compliance with a specification of functional and technical.
Produce output exploitable : table Markdown and graphical visualization .png
Sessions project
9
Professional tool used
PyCharm / GitLab
First part :
IP routing
This first phase was devoted to reading and filtering data ADE (schedules) contained in the file all.csv. It s’was :
1
Read calendar events, and identify the groups of TD as well as the modules.
II
Select interventions d’a teacher standing for half a year given.
III
Calculating the time accumulated by module and by modality (CM, TD, TP).
Second part :
VLANs
The second part focused on the generation of the outputs of the program.
We have worked on :
1
Construction d’a summary table formatted Markdown (report.md), which list the hours of each module.
II
Creating d’a graphic visualization with the module graph_objects to Plotly, which were exported in .png.
III
L’automation of l’all the processing via a Bash script.
Self-reflection on the work
Discovery of concrete
This project m’placed in a concrete situation, to processing of real data, similar to what l’we can meet in a computer service or administrative.
Rigor and understanding
The compliance of technical specifications (naming functions, error handling, documentation, project tree ) m’has learned to work with method and to produce readable code.
Work under stress
The sessions of autonomy, with an obligation to push the Git repository to each session m’have responsibility in the management of my progress, and in compliance with the deadlines.
A solid foundation
In l’together, the SAE has strengthened my skills in Python, scripting, Bash, and formatting data.