Python
Updated
Python: 3 free modules that walk you through Python: Total a Sales Export by Customer in Google Colab, Python: Combine Monthly Sales Exports into One Quarter and Python: Clean a Messy Invoice Export Before You Total It, using Google Colab.
Each module is a real project. You watch a step, do it yourself in a practice copy of the tool, and it checks your work before moving on. It is free, and no experience is needed.
3 modules
Python: Total a Sales Export by Customer in Google ColabA beginner Python walkthrough in the free Google Colab: put six orders in a pandas table, total the quarter and rank customers by revenue, typing every line yourself.
Free · Live ~12 min Beginner
Python: Combine Monthly Sales Exports into One QuarterA beginner Python walkthrough in the free Google Colab: label three monthly exports, stack them into one quarter with pandas concat and total by month and by customer…
Free · Live ~12 min Beginner
Python: Clean a Messy Invoice Export Before You Total ItA beginner Python walkthrough in the free Google Colab: fix stray spaces and capitals, turn "1,250" text into numbers and remove a duplicate invoice before totalling…
Free · Live ~12 min Beginner
What you do in each module
- Python: Total a Sales Export by Customer in Google Colab (about 12 minutes, 15 steps, beginner). You work through: Open a notebook, Put the orders in a table and Total and rank.
- Python: Combine Monthly Sales Exports into One Quarter (about 12 minutes, 11 steps, beginner). You work through: Three monthly exports, Stack them and Totals by month and customer.
- Python: Clean a Messy Invoice Export Before You Total It (about 12 minutes, 10 steps, beginner). You work through: The messy export, Clean it and Total it.
Common questions
How long will this take?
The 3 modules take about 36 minutes in total, and you can do them in separate sittings.
Do I need experience first?
No. These modules are beginner level, and each step tells you exactly where to click.
Do I need a Google Colab account to start?
No. The practice runs in a copy of Google Colab inside your browser, and nothing touches your real accounts. When you are ready, you repeat the steps in your own account.
Is it free?
Yes. All 3 modules are free.
Where should I start?
Start with Python: Total a Sales Export by Customer in Google Colab, then continue with Python: Combine Monthly Sales Exports into One Quarter.
Related
How every module works
Each step is shown on the left, with a cursor pointing to exactly where to click. You do the same thing on the right, in a practice copy of the real tool. Get it right and it moves on. Nothing touches your real accounts until you're ready to build it for real.
Start learning free