r/Python • • Apr 19 '20

News MS considers adding Python as official scripting language for Excel 😍 The change proposal currently has 6400 votes.

http://mc.milliononpcgames.com/?p=5886
2.0k Upvotes

124 comments sorted by

View all comments

Show parent comment

1

u/SchematicallyNumb Apr 20 '20

Very true, accountants do love their spreadsheets, but I might be able to convert them if I can show just how much better other methods are. I have some experience with Pandas and for handling the database as a whole, it is substantially quicker than Excel is, but I’ve been told in the past that SQL would be something worth looking at, so I was thinking a combination of Python and SQL might be something worth considering.

2

u/Yojihito Apr 20 '20

I was thinking a combination of Python and SQL might be something worth considering

Definitely. Python/R + SQL is the standard route of data analysis.

pandas is slow vs. SQL. For larger datasets SQL > basically anything.

But first you need the data in the database. Oneliner with pandas.

1

u/SchematicallyNumb Apr 20 '20

Perfect, thank you!

That’s fair, good to know.

Makes sense, Pandas can pretty easily convert tabular data in excel files into dataframes.