This is an extension that embeds Python in LibreOffice Calc like Python in Excel. Once the extension is installed, pandas, matplotlib, numpy, etc. are also installed, allowing tables to be manipulated as pandas data frames.
The difference with Python in Excel is that it works with Python embedded in LibreOffice. It can be used without external access.
The linked page doesn't seem to have anything to say why I should adopt this tool. I use jupyter in preference to a spreadsheet partly because it separates data from analysis and from visualisation.
Your point is really interesting, I've seen similar articles and I still can't figure out why and how spreadsheets could be replaced by Jupyter Notebooks.
While they are awesome for data analysis and building code by section, to the best of my knowledge the sequential execution lacks the flexibility of the dynamic interdependence of spreadsheets, so having the possibility to call dynamically Python code seems awesome to me in the context with several interconnected variable as it allows quick, simple and dynamic modeling.
Am I missing something?
Does this allow external programs/servers to interact with a workbook (xlsx file)? Or is this just to run more complex calculations inside cell(s)?
There's UNO and there's also openpyxl to interact with workbooks from Python, but both solutions were a bit slow when testing it.
There's a lot of value in having existing workbooks which a lot of businesses already use, and extending them so they can be interacted with or queried from a server. For example to allow further access from a webapp without allowing changes to the entire workbook or hiding the full dataset.
This is an extension that embeds Python in LibreOffice Calc like Python in Excel. Once the extension is installed, pandas, matplotlib, numpy, etc. are also installed, allowing tables to be manipulated as pandas data frames.
The difference with Python in Excel is that it works with Python embedded in LibreOffice. It can be used without external access.
GitHub: Amourspirit/python_libre_pythonista_ext: https://github.com/Amourspirit/python_libre_pythonista_ext
Introducing Python in LibreOffice Calc - YouTube: https://www.youtube.com/watch?v=AQLuSNHhUY4
The linked page doesn't seem to have anything to say why I should adopt this tool. I use jupyter in preference to a spreadsheet partly because it separates data from analysis and from visualisation.
Your point is really interesting, I've seen similar articles and I still can't figure out why and how spreadsheets could be replaced by Jupyter Notebooks. While they are awesome for data analysis and building code by section, to the best of my knowledge the sequential execution lacks the flexibility of the dynamic interdependence of spreadsheets, so having the possibility to call dynamically Python code seems awesome to me in the context with several interconnected variable as it allows quick, simple and dynamic modeling. Am I missing something?
Does this allow external programs/servers to interact with a workbook (xlsx file)? Or is this just to run more complex calculations inside cell(s)?
There's UNO and there's also openpyxl to interact with workbooks from Python, but both solutions were a bit slow when testing it.
There's a lot of value in having existing workbooks which a lot of businesses already use, and extending them so they can be interacted with or queried from a server. For example to allow further access from a webapp without allowing changes to the entire workbook or hiding the full dataset.