3 ms·
That's for the Excel team to decide. My personal hope is that they'll offer as a base: * Python 3 * Numpy, SciPy, Pandas, Matplotlib, Altair, ... * Pythonic
by smortaz 9y ago
That's for the Excel team to decide. My personal hope is that they'll offer as a base:
* Python 3
* Numpy, SciPy, Pandas, Matplotlib, Altair, ...
* Pythonic bindings for Excel APIs (sheets, etc etc)
* VSCode's Python Editor + Debugger built in
* Some sort of conda based env/pkg mgmt
* Right-click, "Open in Jupyter" (data/code)
* <your wish here>
- vvanders 9y agoYeah, matplotlib, scipy and numpy are kinda no-brainers there.
- breatheoften 9y agoPlease not matplotlib ... are we really stuck with matplotlib forever ..?
- vvanders 9y agoIf you've got better suggestions I'm all ears. I've found it pretty great for debugging and being able to understand data in a rapid manner.
- disgruntledphd2 9y agoggplot2. Simply better in every way. Hell, even base R is better than matplotlib. Full disclosure: I hate matplotlib so very, very much.
- auxym 9y agoTransparent access to Excel tables as Pandas Dataframes would be so, so very awesome. I mean, MS implemented these really nice Tables in excel, but then left us no way to easily query them with something like SQL.
- dragonwriter 9y agoWell, there is PowerPivot...
- breatheoften 9y agoDoesn’t pandas.read_excel provide this?
- mistermann 9y agoSomeone posted a link to a really nice 3rd part addin on the reddit thread, on mobile so can't find the link unfortunately but was very well done. Shame on Microsoft for half-assing Excel for the last decade.
- auxym 9y agoPossibly querystorm, in case anyone is looking for it. It did look interesting last time I looked at it, but I've never tried it.
- mistermann 9y agoThat was it: https://www.querystorm.com https://www.querystorm.com
- garyclarke27 9y agoI agree, SQL in Excel would be awesome, Index Match everywhere is a right pain to maintain - to replicate foreign keys. Its amazing what you can do with Sumifs and Countifs, but SQl is better. VBA is OK but NO search across modules makes it such a pain just to find your code, I wish VBA had better support for UDFs so that they can appear the same to users, as built in functions with tooltips. MS have done a really bad job of incorporating Power Pivot, it’s confusing and doesn’t feel like a natural part of Excel. I don’t like Pivot Tables they are too Dynamic and a pain too format.
- govert 9y agoYou can add-in IntelliSense for VBA functions using the (free) Excel-DNA IntelliSense extension. See this detailed write-up by Charles Williams: https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/ https://fastexcel.wordpress.com/2016/10/07/writing-efficient...