Skip to main content

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.

Next session to be confirmed
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.

Ask for the next dates

Automate repetitive tasks and process your data with Python.

* Required field