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

When it comes to working with data in a tabular form, most people reach for a spreadsheet. That’s not a bad choice: Microsoft Excel and similar programs are familiar and loaded with functionality for ...

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

You might think of Microsoft Excel as just rows and columns, a place for basic calculations and simple charts. And while it certainly excels (no pun intended) at those fundamental tasks, the recent ...

Finding the right book can make a big difference, especially when you’re just starting out or trying to get better. We’ve ...