Academy
Python for professional automation
Automate repetitive tasks and process your data with Python.
Write Python scripts to process Excel and CSV files, analyse data with pandas, query web APIs and schedule useful everyday automations.
- Duration
- 30–40 h
- Format
- On site in Oujda, in-company or hybrid
- Level
- Intermédiaire
- Pricing
- Request the conditions
Who is it for?
- Audience
Technicians, analysts and professionals who handle files and data and want to automate their processing.
- Prerequisites
Advanced Excel skills or some programming experience. A computer on which you can install software.
What you will be able to do
- Write readable, reusable Python scripts
- Read, transform and produce Excel and CSV files
- Analyse data with pandas
- Retrieve data from a web API
- Schedule a script to run automatically
Curriculum
Python basics
Variables, types, conditions, loops, functions; the working environment.
Files and folders
Reading and writing files, walking folders, renaming and sorting automatically.
Excel and CSV with pandas
Importing, cleaning, filtering, grouping, merging and exporting data.
APIs and the web
HTTP requests, JSON, retrieving external data.
Automating
Automatically generated reports, sending emails, scheduling tasks.
Hands-on practice
Deliverable: a process automation
A complete script that automates a real task from your job: consolidating files, a weekly report or data checks.
Assessment and certificate
Corrected programming exercises and a demonstration of the final automation.
ENTSI Academy certificate of completion, issued at the end of the course once the deliverable is validated.
Sessions
Next session to be confirmed.
Leave your details and we will send you the next dates as soon as they are set.