Excel users often work with large amounts of unstructured text data, whether it's customer reviews, survey responses, business emails, or social media comments. Extracting structured insights from …
Python in Excel: How to transform text with Copilot
Text transformation and analysis has never exactly been Excel’s strong suit. Sure, native text functions have significantly improved in recent years with new parsing and even regular expression …
Continue Reading about Python in Excel: How to transform text with Copilot →
Advanced analysis with Python in Copilot: How to work with text data
Excel has long been a go-to tool for data analysts to crunch numbers and perform data analysis. Traditionally, its ability to handle text data, particularly for advanced analysis tasks like sentiment …
Continue Reading about Advanced analysis with Python in Copilot: How to work with text data →
Converting RTF Files to TXT in R
Recently I downloaded a large number of RTF files. Wanting to analyze this text data in R, I first needed to strip RTF encoding. In this video I use the striprtf library to loop through a folder of …