3 ms·
I just can’t imagine what I can do here that I can’t do with a Python script using Pandas. Maybe visualization of data using Excel, in a way that makes it easie
by tourmalinetaco 2y ago
I just can’t imagine what I can do here that I can’t do with a Python script using Pandas. Maybe visualization of data using Excel, in a way that makes it easier for boomers/accountants to understand?
- noleary 2y agoYeah, I think it's the compatibility with 'business language' for collaboration. Most white-collar workers know how to use Excel to a really basic level of proficiency. Not many people know how to parse Python code. It's also just a lot easier to work quickly in Excel. I dual boot Linux and Windows on my laptop so that I can have Windows keyboard shortcuts in Excel. If I need to do some lightweight financial modeling or analysis, it's dramatically faster (10x or more) for me to build a spreadsheet than write some Python/R code from scratch.
- slt2021 2y agobasic interop like fetching data from s3 bucket, formatting it and showing as a table in excel would be a good use case, but not sure serverside python is needed for that. more interesting idea could be using Excel as a jupyter-like front-end for the Python kernel. Imagine excel as a jupyter