Python spreadsheet examples

[FPAguy]

How does the python in the spreadsheet work? Can you share examples of python spreadsheet functions?

[Mark]

The python code window is accessible in the top right corner of any workbook via the ‘Code’ button. The code window is a Python development environment that lets you write custom Python functions that can be used in the spreadsheet and import popular Python libraries like pandas, numpy, scipy, etc. It works like a code cell in a Jupyter notebook. Here’s an overview of how the python spreadsheet code window works and here’s a video tutorial:

Python in Row Zero

Here are a few python spreadsheet examples where you can play around with pre-built python functions in a spreadsheet:

• Run ARIMA in a spreadsheet
• Sensitivity analysis using Python
• yfinance Python package in a spreadsheet
• pybaseball data in a spreadsheet
• NFL football stats with Python