The power of Python trumps Excel workbooks.

In this video, we cover the new IMPORTCSV and IMPORTTEXT functions in Excel, which simplify importing data into the application. The IMPORTCSV function allows importing CSV files using just the file ...

These tricks show how AI tools, new import formulas, and classic features improve productivity. Excel has outlasted many tech trends, and in the age of AI, it remains very much in the mix. While new ...

Why write SQL queries when you can get an LLM to write the code for you? Query NFL data using querychat, a new chatbot component that works with the Shiny web framework and is compatible with R and ...

The reticulate package provides a comprehensive set of tools for interoperability between Python and R. The package includes facilities for: Calling Python from R in a variety of ways including R ...

Authentication using Application passwords now works - for OIDC and SAML-backed authentication providers (OP) - but note below how this has been implemented to perhaps work around the fact that ...

What if the tools you already use could do more than you ever imagined? Picture this: you’re working on a massive dataset in Excel, trying to make sense of endless rows and columns. It’s slow, ...

This article is adapted from an edition of our Off the Charts newsletter originally published in October 2021. Off the Charts is a weekly, subscriber-only guide to The Economist’s award-winning data ...