In December 2019 my InfoWorld colleague Sharon Machlis wrote an article called “How to merge data in R using R merge, dplyr, or data.table.” Sharon is a whiz at R programming, and analytics in general ...

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 ...

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, ...

Python's integration in Excel can unlock powerful reports and automation. But what if you try to use Python in Excel without any coding experience? It's possible, but there is still a learning curve ...

Python dataclasses work behind the scenes to make your Python classes less verbose and more powerful all at once. Here's an introduction to using dataclasses in Python. Everything in Python is an ...