The recent announcement from Microsoft that they have now integrated Python into it’s Excel spreadsheet software has opened up a wealth of new applications for data analytics, automation and number ...

You can write a Python program or use a Jupyter Notebook to do almost anything. But you can also get a lot of things done quickly using a spreadsheet. Grist is a “hacker’s” spreadsheet that merges ...

If you've ever wished Excel could handle text patterns the way Python or JavaScript does, these functions deliver exactly ...

Using the SSConverter class that we developed last week, which used the OORunner class from the week before that, this week we'll create a Python function that allows us to use spreadsheets as if they ...

Each input file is a spreadsheet and it is converted into the corresponding output file as a CSV file. As with OORunner, this code is based on PyODConverter. Next week we'll write a converter function ...

The world of data science is awash in open source: PyTorch, TensorFlow, Python, R, and much more. But the most widely used tool in data science isn’t open source, and it’s usually not even considered ...