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

Backlink analysis can be done on a spreadsheet but Python has certain advantages. Learn how to use it and customize reports with this script. Chances are, you’ve used one of the more popular tools ...

Data visualization is a technique that allows data scientists to convert raw data into charts and plots that generate valuable insights. Charts reduce the complexity of the data and make it easier to ...

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

While you can do some good data analysis with a spreadsheet like Excel, if you want to take your calculations to the next level, you might try Python in a Jupyter notebook instead. Here are some ...

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

Reticulate is a handy way to combine Python and R code. From the reticulate help page suggests that reticulate allows for: "Calling Python from R in a variety of ways including R Markdown, sourcing ...

Over the last month, Google has announced a number of advancements to how they will be measuring user experience through key speed and performance metrics. Coincidentally, I have been working on ...