4 ms·
My main dependence on Excel is being able to interact with pivot tables. I also have some VBA macros to help with formatting which I would welcome to be in pyth
by hyperpl 3y ago
My main dependence on Excel is being able to interact with pivot tables. I also have some VBA macros to help with formatting which I would welcome to be in python - alas it looks like what they're bringing is for the cloud only?
I haven't found any free, open source solutions around this including any for Jupyter notebooks (my preferred medium).
- xcombelle 3y agopython pandas has pivot tables https://pandas.pydata.org/docs/reference/api/pandas.pivot_table.html https://pandas.pydata.org/docs/reference/api/pandas.pivot_ta... I don't know if it fits your needs
- pasc1878 3y agoSo you can click and drag the columns around in the pivot table to get a better view?
- reportgunner 3y agoimho using pandas for pivot tables is like using a cannon to shoot sparrows