If you enjoyed this video, I am certain that you're going to love my Data Cleaning Master Class. It shows you even more advanced tricks for Excel file and text cleaning. You can check it outat data-cleaning.albert-rapp.de/
Great video, many thanks. If I may have a note/suggestion; for us less advanced R-users :), I would like to see explained in more details also partial tasks/steps you are performing. For example regex
Hi Robert, thanks for reaching out. It is indeed hard to find a balance between what to explain and what to leave to the user 🙈 As for your question, the call you mentioned is constructing a regular expression using the glue function. A great guide on regular expression is r4ds.hadley.nz/regexps.html
Nice. I was a bit surprised by seeing paste0 inside a glue function. I thought glue was used instead of paste and was simpler. It is also worth noting, as you probably, know that there are three packages specifically aimed at dealing with excel files (even messier than the ones you did - for instance subheaders at different levels throughout the document). These are tidyxl, unheadr, and unpivotr. The tidyxl package actually works on the "cellular" level that is allows you to deal with the contents of the excel cells and manipulate them. Tidyxl is powerful but takes experience to work with. It would be nice to see a video on tidyxl. Thanks.
😀 I am on board with not using setwd() for static file paths. I think that's what Jenny meant 🤔 I do love projects but still sometimes navigating inside of them is unavoidable. That's why I use here() from the {here} package to make file paths relative.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
If you enjoyed this video, I am certain that you're going to love my Data Cleaning Master Class. It shows you even more advanced tricks for Excel file and text cleaning. You can check it outat data-cleaning.albert-rapp.de/
Great video, many thanks. If I may have a note/suggestion; for us less advanced R-users :), I would like to see explained in more details also partial tasks/steps you are performing. For example regex
Hi Robert, thanks for reaching out. It is indeed hard to find a balance between what to explain and what to leave to the user 🙈 As for your question, the call you mentioned is constructing a regular expression using the glue function. A great guide on regular expression is r4ds.hadley.nz/regexps.html
Very nice. You sure packed a lot into this 7:44 min:secs. Thank you.
Glad that you like it, Robert 😊
Date columns in Excel are nightmare fuel, luckily we have janitor::excel_numeric_to_date(). Great video!
It is indeed 😀 Janitor's convenience function are super great for fixing these types of problems.
Excellent tutorial. I literally watch it every day so that I can learn it very well. Would you please make more of these cleaning data tutorials?
Happy to have a fan 😊 I'm planning on making a data cleaning course but that's still a bit in the future 😅
@@rappa753
Excellent. Can't wait to join.
Nice. I was a bit surprised by seeing paste0 inside a glue function. I thought glue was used instead of paste and was simpler. It is also worth noting, as you probably, know that there are three packages specifically aimed at dealing with excel files (even messier than the ones you did - for instance subheaders at different levels throughout the document). These are tidyxl, unheadr, and unpivotr. The tidyxl package actually works on the "cellular" level that is allows you to deal with the contents of the excel cells and manipulate them. Tidyxl is powerful but takes experience to work with. It would be nice to see a video on tidyxl. Thanks.
Great video, well done!
Thank you :)
Excellent one. thank you Albert
Glad that you like it 😊
so much information packed,you the best
Thank you, that's very kind of you 😊
Thank you very much. Very informative.
Thank you, Hassan. Glad that you enjoy my video!
YES! WOW! I didnt know I needed this video
Nice, looks like you got a lot out of this video. Thanks for sharing that with me 🤗
A proper way is to use the `tidyxl` package
Uhh {tidyxl} sounds promising. it sounds a bit like an add-on to {readxl}. Thanks for the hint 🙂
Great job Albert. But next time you use setwd() I will look for you and burn your computer (Jenny Bryan) (projects are better).
😀 I am on board with not using setwd() for static file paths. I think that's what Jenny meant 🤔 I do love projects but still sometimes navigating inside of them is unavoidable. That's why I use here() from the {here} package to make file paths relative.