Member-only story
Spreadsheets are moving to Python
Is it time to automate your spreadsheet in Python?
Published in
6 min readMar 16, 2023
Spreadsheets are every Data Analysist’s best friend. It’s hard to find arguments against spreadsheets, but they do have obvious limitations. Some data analysist argue they are slow, they don’t handle large datasets well and they are challenged when it comes to automation and repeatability.
Some will argue you can code in a spreadsheet and automate many calculations, but I’m personally not a fan of it. Why? Writing (complex) code in spreadsheet is a cumbersome process which results in a block of badly structured code.
It is becoming increasingly common for Excel users and spreadsheet workflows to start transitioning to Python. By reading this article you’ll learn a few tips on how to get started.
What you’ll learn by reading this article?
- Useful Python packages that can help you migrate your spreadsheet
- Is your spreadsheet appropriate for migration to Python?
