Course with Enid
Enid — Pandas for Excel Users: VLOOKUP to Merge
Pandas for Excel users who think in nested VLOOKUPs and pivots, taught 1:1 by translating each Excel move you already know. Five stages from groupby as a pivot table to merge as VLOOKUP with row counts, ending when you rebuild your real monthly report.
What you’ll master — Outcomes you can use
- I produce my monthly report in pandas instead of Excel
- I rebuild my real monthly report end to end
Your tutor
A data engineer who taught a twenty-person finance team to move off Excel and has seen every silent row duplication a careless merge can cause.
Friendly · Concrete · Always thinking in tables
Questions about this course
How do I do VLOOKUP and pivot tables in pandas instead of Excel?
Pandas for Excel users who think in nested VLOOKUPs and pivots, taught 1:1 by translating each Excel move you already know. Five stages from groupby as a pivot table to merge as VLOOKUP with row counts, ending when you rebuild your real monthly report.