Python Automation Basics
Make Python do your boring work — rename a thousand files, merge Excel sheets, send scheduled reports. The free bridge from Python for Beginners to Advanced Python.
That was a one-minute preview. The full course video is for signed-in learners. Sign in to watch it here — or create a free BvLogic ID; it takes a minute, and this course is added to it.
What you'll be able to do
- Identify which of your recurring tasks are automatable, and set up a working scripts folder.
- Read, write, move, rename and organise files in bulk with pathlib — safely, with a dry-run habit from day one.
- Read, merge and produce Excel files with openpyxl and pandas — the highest-value automation in any Pakistani office.
- Handle date logic, schedule scripts with the operating system, and build the logging that makes unattended scripts trustworthy.
- Fetch data from the internet with requests, send email reports from scripts, and handle credentials properly.
- Assemble the course into a maintained personal toolkit, pitch automation to a real workplace, and see what the paid course scales up.
Advanced Python
Advanced Python
This free course is the introduction. The programme is taught by a trainer, marked by the academy, and carries the syllabus in full — the part an employer asks about.
See the full syllabus and feeCourse content
- 1 The automation mindset: your time, measured Identify which of your recurring tasks are automatable, and set up a working scripts folder.
- 2 Files and folders: the bread and butter Read, write, move, rename and organise files in bulk with pathlib — safely, with a dry-run habit from day one. Sign in to open
- 3 Excel automation: the office's real database Read, merge and produce Excel files with openpyxl and pandas — the highest-value automation in any Pakistani office. Sign in to open
- 4 Dates, schedules and scripts that run themselves Handle date logic, schedule scripts with the operating system, and build the logging that makes unattended scripts trustworthy. Sign in to open
- 5 Reaching out: web data and email reports Fetch data from the internet with requests, send email reports from scripts, and handle credentials properly. Sign in to open
- 6 Your automation toolkit, and the road to Advanced Python Assemble the course into a maintained personal toolkit, pitch automation to a real workplace, and see what the paid course scales up. Sign in to open
Course lab
Graded lab One report that runs itself, safely, for a real person Open the lab →Who this course is for
- Office staff and students who know basic Python and repeat the same tasks every week.
- Anyone who spends hours renaming files, merging Excel sheets or sending the same report.
- Learners on the way to the paid Advanced Python course.
What the 6 lessons cover
- The automation mindset: your time, measured. Any task done the same way three times is a script waiting to exist. Measure the time it takes and set up a scripts folder.
- Files and folders: the bread and butter. Rename, move and organise files in bulk with pathlib, always with a dry run first.
- Excel automation: the office's real database. Merge, clean and summarise workbooks with pandas, and format output with openpyxl: the most valuable automation in any Pakistani office.
- Dates, schedules and scripts that run themselves. Date logic with datetime, dated file names, the operating system's scheduler, and logging so unattended scripts can be trusted.
- Reaching out: web data and email reports. Fetch data with requests, email reports from a script, and keep passwords and keys in a .env file, never in the code.
- Your automation toolkit, and the road to Advanced Python. A maintained toolkit with a README, scripts that report what they did, dry runs and secrets kept safe, and how to pitch automation at work.
Try the first exercise (in Urdu)
اپنی automation hit-list لکھیں: پانچ کام جو آپ (یا آپ کے قریب کوئی — دکان، دفتر، والدین) computer پر بار بار کرتے ہیں۔ ہر ایک کے لیے: کتنی بار، کتنے منٹ، اور سالانہ لاگت گھنٹوں میں۔ اُن دو پر ستارہ لگائیں جن کا لاگت-بمقابلہ-scripting-محنت کا تناسب بہترین ہے — یہ سبق 3 اور 6 میں آپ کے projects بنیں گے۔ پھر listing script اپنے سب سے بے ترتیب folder میں چلائیں۔
Using this in Pakistan
- Indeed's range for junior data analysts in Pakistan is Rs 38,190 to 101,116 a month, averaging Rs 62,142, from only 12 reported salaries. Source
- Few Python adverts show pay: a Lahore Python backend internship offered Rs 15,000 to 20,000 a month, and none of the Faisalabad Python or data adverts seen on 30 September 2026 listed a salary. Source
Questions
Is it really free?
Yes. No payment and no card; lesson 1 needs no account.
Is there a certificate?
Yes, when you complete every lesson.
Can I learn in Urdu?
Every lesson has an Urdu exercise alongside the English reading.
How long does it take?
About 18 minutes of reading, plus the exercises.
What comes next?
The paid Advanced Python programme, in Faisalabad and live online.
Related free courses
- Advanced SQL · Urdu video
- APIs · Urdu video
- Automation · Urdu video
- C# and .NET Basics · Urdu video
- Git and GitHub Basics · Urdu video
- JavaScript Basics · Urdu video