Skip to content
RUROEN
Sign in Choose a course
Development PY—03

Automating the routine

A course for people who have written their first hundred lines of Python and want them to start saving time. We take the tasks you currently do by hand: sorting files, building a report in Excel, pulling data off a site, sending the result — and turn them one by one into scripts that run on a schedule without you.

8 modules21 lessons
16 hoursof video and practice
Python basics neededrequirements
Foreveraccess and updates
Format
€39 one-off payment
Place the order Open the programme
Payment by card or through PayPal
Access opens immediately after payment
14-day refund, if you have not started watching
Outcome

What you will be able to do

Judge where a script pays for itself and where the routine is cheaper left by hand
Put files and folders in order from code: sort, rename, clean up
Build a finished Excel report with openpyxl, with formatting and formulas
Pull data off pages: parse HTML without putting load on someone else's site
Send the result by email or as a Telegram message
Run a script on a schedule with cron and the Windows task scheduler
Turn a script into a tool: parameters, a config and clear error messages
Chain several steps into one pipeline and check that it ran
Programme

8 modules, one project

Press a module to open its lessons

01 What to automate and what not to3 lessons · 2 h 08 minOpen

We start not with code but with arithmetic: how much time the task eats, how much the script costs and when it pays for itself.

Counting the routine: where a script returns time and where it does not
Breaking the task into steps: input, processing, result
An environment for scripts: the project folder, venv, dependencies
02 Files and folders3 lessons · 2 h 12 min

The first honest automation: we tidy a real downloads folder and learn not to lose data when something goes wrong.

pathlib: walking the tree, filters by name and extension
Sort, rename, remove duplicates
Practice: sorting the downloads folder by type and date
03 Excel for real3 lessons · 2 h 16 min

Not «an export to CSV» but a working book: several sheets, formats, column widths and a report you can hand to someone who is not a programmer.

openpyxl: reading a workbook, sheets and cells
Writing data: types, formulas, widths and formats
Practice: a summary report on a separate sheet
04 Data from web pages2 lessons · 1 h 36 min

We parse HTML where there is no API, and we do it politely: with pauses, headers and respect for someone else's server.

requests and parsing HTML: finding the right parts of a page
Polite scraping: pauses, retries, robots.txt and the limits
05 Sending the result3 lessons · 2 h 10 min

The script has finished — now a person needs to hear about it: by email or as a message in a messenger.

An email from a script: SMTP, subject, body and attachment
A Telegram message without a bot framework
Practice: the report goes out by email with the file attached
06 A script on a schedule2 lessons · 1 h 32 min

Automation begins where the script runs without you: we cover cron and the Windows task scheduler.

cron on Linux and macOS: writing a schedule and checking it
The Windows task scheduler and the usual traps when launching
07 The script as a tool2 lessons · 1 h 30 min

We turn a one-off file into a tool you can still use in six months and hand to a colleague.

Command-line parameters and a settings file
Logs and clear errors instead of a traceback into the void
08 The final pipeline3 lessons · 2 h 36 min

We chain the course modules together: source, processing, report, delivery — and run the chain on a schedule.

Chaining the steps into one script
What to do on failure: retries, notification, a safe rollback
Final project: site → spreadsheet → a report once a week
Materials

What you get

21 lessons with transcripts

Videos with timecodes and a written version: the code from a lesson can be copied instead of retyped off the screen.

A data set for practice

A cluttered folder, an Excel workbook with real mess and saved pages of a site — so your result matches the lesson.

Script templates

A starting point for each kind of task: walking files, an Excel report, parsing a page, sending an email — with parameters and logging.

A scheduling guide

How to put a script into cron and the Windows scheduler, where to look for logs and why a scheduled run sees a different environment.

Alina Mihai
Course author

Alina Mihai

Teaches the «Python and backend» direction at Forma. The full list of their courses is on their page.

All courses by this author

The whole first module is open

Watch the lessons of the first module and the first task. If the format does not suit you, you have lost nothing.

Buy for €39Watch for free