A practical tutorial on how to standardize and modify URL datasets in Excel, Google Sheets, or other table processors. I’ll teach you how to clean up trailing slashes, WWW subdomain, change HTTP to HTTPS, and much more useful tricks for trimming or concatenating URLs. You’ll appreciate this information during work with the complex datasets, preparing redirection tables, or experimenting.
* and question mark
? play special roles in Excel. Both are wildcard symbols. Asterisk can replace any string. A question mark can replace any single character.
For some reason, you are not able to launch OpenRefine and keep seeing error Failed to use jdatapath in the console? Check this detailed tutorial to debug and fix the issue with missing variables in Windows.
Collection of five exciting data visualizations, infographics, and tips for working with data. This time we’re looking at people migration, text analytics, air traffic, and fonts. In each section, you will find necessary information, author Twitter accounts, links for used technologies, data downloads, and sources.