Learn Python, or learn to drive Copilot? A beginner's honest fork in the road
Two tabs open, four spare hours a week, and everyone insisting the other tab is a waste of your time - here's the no-hype version of the beginner's fork.
Python
// 6 postsTutorials, tips, and deep dives on Python — every post from bianca.codes tagged Python.
Python posts
-
-
Build a Monthly Report Card in a Single Python in Excel Cell
Python in Excel can't write a file, but it can turn a transaction table into a chart that lives in the workbook and never goes stale - in one =PY() cell.
-
Python in Excel: When a Cell Stops Being a Number and Becomes a DataFrame
For forty years an Excel cell could hold one of four things, and Python in Excel quietly added a fifth: a whole pandas DataFrame, living inside a single cell.
-
Python for Excel Users, Part 3: Merging Datasets and Replacing Your VLOOKUPs
VLOOKUP and XLOOKUP, but for files that don't fit in memory, joins on multiple keys, and many-to-many matches that VLOOKUP simply can't do.
-
Python for Excel Users, Part 2: Grouping, Aggregating, and Replacing Your SUMIFS
SUMIFS and COUNTIFS are great — until your data has 500,000 rows and Excel is grinding. Part 2 shows how to do everything your SUMIFS does, but with pandas groupby — faster, more flexible, and on d…
-
Python for Excel Users, Part 1: Reading and Filtering Your First Real Dataset
This isn't 'what is a variable' Python. This is: you have a CSV that's too big for Excel, you need it filtered by date and category, and you need the result saved as a clean file. Part 1 covers exa…