Regex is a powerful – yet overlooked – tool in search and data analysis. With just a single line, you can automate what would otherwise take dozens of lines of code. Short for “regular expression,” ...

What if you could turn Excel into a powerhouse for advanced data analysis and automation in just a few clicks? Imagine effortlessly cleaning messy datasets, running complex calculations, or generating ...

I was involved in a recent discussion on the "best" way to remove a given parameter from a URL string. The conversation began with using string primitives to split and join the parameter, a method ...

If you’d like an LLM to act more like a partner than a tool, Databot is an experimental alternative to querychat that also works in both R and Python. Databot is designed to analyze data you’ve ...

While Excel is ubiquitous, I prefer Python for my data analysis. Spreadsheets are great for formatting data, but it's Python that's allowed me to build my own super calculator out of regular Python ...