Data Extraction with R & {stringr} | Step-by-Step Tutorial

[@albertocabrera4297]

In less than 15 minutes, I learned more about general expressions from Albert than from all the books I had on the topic. I finally understood the role of parentheses in identifying groups within general expressions. If this KZbin lesson is a preview of Part 3 of the R Data Cleaning Master Class, I can only imagine the invaluable insights Albert will share with those just starting to learn R.

[@rappa753]

Yup that's the idea. Part 3 of the course will have much more like this :)

[@asolisca]

As always, top notch content Albert, thank you so much! One thing to note on the capturing groups though: the group argument in str_extract is supposed to receive an integer rather than a boolean as you can have more than one capturing group! In this case you only have one capturing group and so TRUE evaluates to 1 and that’s why it works! You can check the documentation for great examples!

[@rappa753]

Oh that's a good catch! Thank you :) Whenever I have more than one group I ususally use str_match(). So I guess that's how I've never noticed my erroneous use of that argument :D

[@ambhat3953]

I thought i never needed this package in my line of work...but after seeing this i can think of some use cases which can make my data clean easier. Thnx for that

[@rappa753]

Happy to hear that. I used to think that tech cleaning is not for me as well but once I had the skill I realized that applications are everywhere 🥳

[@iwoaugustynski9265]

You always surprise me with functions in well known packages which I haven't know. Thanks!

[@rappa753]

You're welcome. Happy to hear that my video had a surprise in store for you :) The {stringr} is massive. There are just so many functions :D

[@djangoworldwide7925]

This is great, but for all of you students or hobbiests, youd wish to have such a nice data in your actual job. as a dummy example to get to know stringr and tidyr, its a nice tutorial :)

[@rappa753]

Yeah this is a bit easier than what you'd see in the real world but I've had a similar use case recently at work that didn't involve much harder things. Getting started is always the hardest 😁

[@haraldurkarlsson1147]

Why not scrape it? The issue with copy-paste that it is not strictly reproducible.

[@rappa753]

Sometimes it's not possible to web-scrape the page you're looking at. Could be company data that is only accessible interactively for example. That's why you sometimes need such a workaround.

[@haraldurkarlsson1147]

@@rappa753 True - but is it impossible to tell unless you look at the underlying html. I have seen examples of webscraping for pages with pull-downs etc. Of course you need to check first if scraping is allowed.

[@muhammedhadedy4570]

Thank you so much, my dear professor. I launched your data cleaning course, it's AMAZING. The best R tutorial I've ever had so far. Just one favour, would you please share the data source or website data that you used in this video? I would like to replicate your code. Thanks again, and greetings from Egypt. ❤❤❤❤

[@woodspock]

Watch and pause the video between 1:08 and 1:21. You'll be able to see the whole text. Just have to type it yourself, it's rather short.

[@rappa753]

Thank you ❤️ I'm really glad that you get so much value out of my data cleaning course. 🥳 As for the data, I've included the content of the text file at the bottom of this video's description.