Still using Excel for your data analysis ... can use Python’s replace method and provide a list. Extracting a substring within Excel requires the usage of the LEFT, MID, or RIGHT functions ...

We need to parse the data in this format into Python ... in your analysis is to break the path portion of the URL by ‘/’ to get the parts. This is simple to do with the split function.

There’s an intriguing new option for people who want to do data-wrangling and analysis ... data in R or Python and then send those results to Observable with the ojs_define() function.