3 ms·
LibreOffice Calc combined with python's pandas and numpy modules meet all needs I have for spreadsheets, with matplotlib and seaborn for visualization. The Ipy
by photochemsyn 4y ago
LibreOffice Calc combined with python's pandas and numpy modules meet all needs I have for spreadsheets, with matplotlib and seaborn for visualization. The Ipython shell is the optimal IDE for this approach IMO. My desktop reference is:
"Python for Data Analysis 2nd ed" (Wes McKinney, 2018)
- sgt 4y agoAnd it's something that'll literally last forever. Not dependent on a company or pricing.
- anigbrowl 4y agoSomewhat same, but I'm not sure what you need Calc for, I can't remember the last time I deliberately opened a spreadsheet. On the other hand, while Matplotlib and its ecosystem of add-ons and close imitators is fantastic, it's not friendly to most people, and making it interactive is a massive pain. If you want to wiggle sliders and watch your charts change in real time, you need to use pyplot or something instead.
- jackamadeo 4y ago(Neptyne cofounder here) All great tools to be sure! I am a huge fan of numpy and pandas especially. For plotting in Neptyne I usually opt for plotly over matplotlib/seaborn. Agreed too on the shell -- that's why we built one into our product. I am curious though, do you typically share/collaborate on these spreadsheets with others? Do you have a neat way of packaging up the spreadsheet+Python code?