- 103
- 150 905
Albert Rapp
Приєднався 17 лип 2008
High quality tutorials on all the data things with R and web technologies like HTML, CSS and JS.
I also break down my content into bite-sized, weekly 3-minute newsletters. You can get them delivered straight to your inbox. Just follow this link below.
I also break down my content into bite-sized, weekly 3-minute newsletters. You can get them delivered straight to your inbox. Just follow this link below.
Robust R Code That Will Work Forever With {renv}
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/
📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users
📍 Free gt e-book at gt.albert-rapp.de/
🧹CLEAN UP MESSY DATA
From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/
📈 CREATE EFFECTIVE CHARTS
Check out my video course to create insightful data visualizations with ggplot at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users
MORE VIDEOS
📺 Web Development for R Users ua-cam.com/play/PLBnFxG6owe1FYxS97WBIlY8TtUVYDLBNn.html
📺 ggplot Tutorials ua-cam.com/video/IWXcw6NHM6E/v-deo.html&ab_channel=AlbertRapp
📺 ggplot Remakes ua-cam.com/video/nTbzO-RjABo/v-deo.html&ab_channel=AlbertRapp
Subscribe at 👉 ua-cam.com/channels/dFC653IaBVC5kwj7CGo2sQ.html
MORE CONTENT
- weekly 3-minute newsletter about R, DataViz and webdev at 3mw.albert-rapp.de/
- LinkedIn at www.linkedin.com/in/dr-albert-rapp-9a5b9b28b/
#rstats #dataviz #ggplot #dplyr
📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users
📍 Free gt e-book at gt.albert-rapp.de/
🧹CLEAN UP MESSY DATA
From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/
📈 CREATE EFFECTIVE CHARTS
Check out my video course to create insightful data visualizations with ggplot at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users
MORE VIDEOS
📺 Web Development for R Users ua-cam.com/play/PLBnFxG6owe1FYxS97WBIlY8TtUVYDLBNn.html
📺 ggplot Tutorials ua-cam.com/video/IWXcw6NHM6E/v-deo.html&ab_channel=AlbertRapp
📺 ggplot Remakes ua-cam.com/video/nTbzO-RjABo/v-deo.html&ab_channel=AlbertRapp
Subscribe at 👉 ua-cam.com/channels/dFC653IaBVC5kwj7CGo2sQ.html
MORE CONTENT
- weekly 3-minute newsletter about R, DataViz and webdev at 3mw.albert-rapp.de/
- LinkedIn at www.linkedin.com/in/dr-albert-rapp-9a5b9b28b/
#rstats #dataviz #ggplot #dplyr
Переглядів: 688
Відео
How To Create Data-Driven Slide Decks With R & {officer}
Переглядів 803День тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 🧹CLEAN UP MESSY DATA From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/ 📈 CRE...
Stop Code Errors From Crashing Your Whole R Script
Переглядів 53814 днів тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 🧹CLEAN UP MESSY DATA From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/ 📈 CRE...
Run Many Calculations All at Once With Map Functions | Step-by-Step R Tutorial
Переглядів 1,2 тис.21 день тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 🧹CLEAN UP MESSY DATA From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/ 📈 CRE...
Automatically Fill Word Documents With Data Using R | Step-by-Step Tutorial
Переглядів 1,3 тис.Місяць тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 🧹CLEAN UP MESSY DATA From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/ 📈 CRE...
How to Get Data from SQL Databases With R | Step-by-Step Tutorial
Переглядів 958Місяць тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 🧹CLEAN UP MESSY DATA From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/ 📈 CRE...
Data Extraction with R & {stringr} | Step-by-Step Tutorial
Переглядів 9322 місяці тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 🧹CLEAN UP MESSY DATA From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-cleaning.albert-rapp.de/ 📈 CRE...
How to Download Tables With R & rvest | Step-by-Step Web-Scraping Tutorial
Переглядів 1,3 тис.2 місяці тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at INSERT URL 🧹CLEAN UP MESSY DATA From basics to advanced tricks: Simplify your messy data into clean, usable insights and sign up for my Data Cleaning Master Class today 👉 data-clea...
How To Create Interactive Tables With R & reactable | Step-By-Step Guide
Переглядів 1,5 тис.3 місяці тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at albert-rapp.de/posts/28_reactable_intro/28_reactable_intro 📈 CREATE EFFECTIVE CHARTS Check out my video course to create insightful data visualizations with ggplot at arapp.thinkif...
Visualize Patterns With Calendars & ggplot2 | Step-By-Step Tutorial
Переглядів 8163 місяці тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at albert-rapp.de/posts/ggplot2-tips/35_calendar_plots/35_calendar_plots 📈 CREATE EFFECTIVE CHARTS Check out my video course to create insightful data visualizations with ggplot at ar...
FULL Text Control With ggplot & {marquee} | Step-By-Step Tutorial
Переглядів 1,2 тис.4 місяці тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at albert-rapp.de/posts/ggplot2-tips/34_dynamic_text_color/34_dynamic_text_color 📈 CREATE EFFECTIVE CHARTS Check out my video course to create insightful data visualizations with ggpl...
Use These Techniques to Perfect Your Line Charts | {ggplot2} Step-by-Step Tutorial
Переглядів 1,2 тис.4 місяці тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at albert-rapp.de/posts/ggplot2-tips/32_viz_tips/32_viz_tips 📈 CREATE EFFECTIVE CHARTS Check out my video course to create insightful data visualizations with ggplot at arapp.thinkifi...
How to Avoid EMPTY Charts With ggplot2 (groups finally explained)
Переглядів 1,2 тис.5 місяців тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at albert-rapp.de/posts/ggplot2-tips/31_grouped_lines/31_grouped_lines 📈 CREATE EFFECTIVE CHARTS Check out my video course to create insightful data visualizations with ggplot at arap...
Use These 6 Functions For All Data Projects | Step-By-Step Tutorial
Переглядів 1,3 тис.5 місяців тому
📍 Data Cleaning Masterclass at data-cleaning.albert-rapp.de/ 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at albert-rapp.de/posts/24_data_cleaning_fundamentals/24_data_cleaning_fundamentals 📈 CREATE EFFECTIVE CHARTS Check out my video course to create insightful data visualizations with g...
Why you shouldn't rely on box plots too much
Переглядів 9855 місяців тому
📍 Data Cleaning Masterclass at 3mw.albert-rapp.de/p/data-cleaning-masterclass 📍 DataViz Course at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users 📍 Free gt e-book at gt.albert-rapp.de/ 📍 Blog post at albert-rapp.de/posts/ggplot2-tips/29_no_boxplots/29_no_boxplots 📈 CREATE EFFECTIVE CHARTS Check out my video course to create insightful data visualizations with g...
Write R Code Faster With These RStudio Shortcuts and Settings | Step-By-Step Tutorial
Переглядів 2,7 тис.5 місяців тому
Write R Code Faster With These RStudio Shortcuts and Settings | Step-By-Step Tutorial
Use These Data Cleaning Helpers for R from the janitor package
Переглядів 2,5 тис.6 місяців тому
Use These Data Cleaning Helpers for R from the janitor package
How To Create Interactive Maps with R | Step-By-Step Tutorial
Переглядів 3,8 тис.6 місяців тому
How To Create Interactive Maps with R | Step-By-Step Tutorial
How to Create Dashboards with R, Python, OJS or Julia | Step-By-Step Guide
Переглядів 2,4 тис.6 місяців тому
How to Create Dashboards with R, Python, OJS or Julia | Step-By-Step Guide
How to Make Great Tables with Python | Step-by-Step Tutorial
Переглядів 1,7 тис.6 місяців тому
How to Make Great Tables with Python | Step-by-Step Tutorial
How to Make Great Tables with R | Step-by-Step Tutorial
Переглядів 2,8 тис.7 місяців тому
How to Make Great Tables with R | Step-by-Step Tutorial
Translating Quarto to HTML & CSS Notation
Переглядів 6207 місяців тому
Translating Quarto to HTML & CSS Notation
How to Add Images to Your ggplot | Step-By-Step Tutorial
Переглядів 1,5 тис.7 місяців тому
How to Add Images to Your ggplot | Step-By-Step Tutorial
How to align HTML Containers with Grid in R | Step-By-Step Tutorial
Переглядів 2747 місяців тому
How to align HTML Containers with Grid in R | Step-By-Step Tutorial
Principal Component Analysis with Statistics Globe
Переглядів 1,2 тис.8 місяців тому
Principal Component Analysis with Statistics Globe
How to Create Upset Charts With {ggplot2} | Step-by-Step Tutorial
Переглядів 1,6 тис.8 місяців тому
How to Create Upset Charts With {ggplot2} | Step-by-Step Tutorial
How to align HTML containers with Flexbox in R | Step-by-step Tutorial
Переглядів 3498 місяців тому
How to align HTML containers with Flexbox in R | Step-by-step Tutorial
Summarize PDF Docs & Extract Information with AI & R | Step-By-Step Tutorial
Переглядів 2 тис.8 місяців тому
Summarize PDF Docs & Extract Information with AI & R | Step-By-Step Tutorial
Use CSS Selection to Style Existing HTML Code | A Step-By-Step Tutorial
Переглядів 5018 місяців тому
Use CSS Selection to Style Existing HTML Code | A Step-By-Step Tutorial
Use ChatGPT, Mistral and ollama for Text Processing in R | Step-By-Step Tutorial
Переглядів 3,2 тис.8 місяців тому
Use ChatGPT, Mistral and ollama for Text Processing in R | Step-By-Step Tutorial
Super-duper useful video, thank you, Albert, for your amazing contribution to the #rstats community.
Thanks for the helpful guide! Could you please show, in a future video, how to deal with new versions of packages becoming available? For example, if I had a Quarto document that used an old version of a package, and I want to upgrade it to use a feature in the new package? I’ve done something similar with python and venv, so would be interested to see how it could work in R with renv. I think it was really helpful for me to understand why virtual environments and lock files are important and powerful - especially for reproducibility and for deployment in different environments!
5:15 I would introduce libpath to demonstrate this idea.. great vid. Renv is Great
Ahh you're right. Clearly I missed an opportunity there 😅
I thought renv doesn’t have multiple copies of same version packages (across projects). Rather, if it is already installed then a new project requiring that package (and specific version) links to that pre-installed version? So, there could be something like an renv store/library as well as a global? Trying to understand why packages existing in global aren’t linked to unless different version
@@DM-py7pj interesting 😯 I thought it's one standalone library per project. Possibly renv has some optimization going on here 🤔
@ I didn’t get it quite right. Quote from docs: If you use renv for multiple projects, you’ll have multiple libraries, meaning that you’ll often need to install the same package in multiple places. It would be annoying if you had to download (or worse, compile) the package repeatedly, so renv uses a package cache. That means you only ever have to download and install a package once, and for each subsequent install, renv will just add a link from the project library to the global cache. You can learn more about the cache in vignette("package-install").
@@DM-py7pj Pretty cool optimization
If you enjoyed this video and want to level up your R skills even further, check out my latest video courses: 📍Data Cleaning Master Class at data-cleaning.albert-rapp.de/ 📍Insightful Data Visualizations for "Uncreative" R Users at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users
You're awesome! Thank you for your hard work.
You're welcome. I'm just glad that this is appreciated so much 😊
Amazing...finaallllyyyy... tutorials on PowerPoint. This is very important. We need more tutorials on this
Glad that you're so excited about this 🤗
@@rappa753Thank you so much. Please please please do more videos on R and PowerPoint
Really nice! But why not use Quarto to export to pptx?
That's possible too but it's limited to what Quarto or rather more appropriately what pandoc can do. And in that sense Pandoc is often a bottleneck when it comes to Office files. That's why I usually go with {officer} instead. Also, I don't think the Quarto docs are detailled enough when it comes to pptx.
@rappa753 Thank you for your nice and precise answer!
@@blaisepascal3905 you're very welcome. I'm always happy to help 🤗
Next big thing: integration of ggiraph with pptx, so you get interactivity within the slide!
Would be cool but I don't think pptx has a built-in JavaScript functionality to handle the interactivity 🤔
thanks so much
You're welcome! 😊
If you enjoyed this video and want to level up your R skills even further, check out my latest video courses: 📍Data Cleaning Master Class at data-cleaning.albert-rapp.de/ 📍Insightful Data Visualizations for "Uncreative" R Users at arapp.thinkific.com/courses/insightful-data-visualizations-for-uncreative-r-users
Hi Albert! Are you going to teach (show us hot to do the initial table about Germany that you showed at the brginning?? Could you make a series about that table, please?? I'm this series could be valueable for most of us (at least for me will be! 😅). Congrats for your awesome work 😉
The video will come in the next few weeks. I've already recorded it but haven't gotten around to the editing part yet 😊
Theres a meme with levels of awesomeness. Integrating classes in cli:: in your error handling is second to top level, which is understanding what the user *wanted* to do and suggest the correct code, as they often do with "n" or ".n" and in depcracted methods in tidyverse
Oh I love it when that happens and the error just tells me the solution 😍
Does hadley even write in R? Its all c and c++ under the mighty tidy hood 😅
Good question. Haven't thought about that 😂
Great explanation. Thanks for sharing this
You're welcome. Happy to help ☺
Thank you for watching my latest video. ♥ If you enjoyed this video, I'm sure you're also going to love my Data Cleaning Master Class. Clean your data and find insights much faster at data-cleaning.albert-rapp.de/
I prefer the more explict expressions rather than short-hand because it may be difficult for someone (inlcuding one self) to interpret the code down the line. I like the ~.x versions e.g. map_dbl(coeffs, ~.x[1]) but I suppose with \(x) x[1] things are clear. Lastly I would have liked to have seen r-squared and the p value for the slope.
Yeah I write \(x) almost instinctively so I never use the short-hand either 😃 you can add additional map calls to extract these stats from the lm object as well 😊
A simpler example would have drum home the point faster. Great work though
I like to start with an elaborate example to show people what's possible first (with explanations of course) 🤗 the simpler example is also available in the video
Your UA-cam lesson could also be used to understand the powerful concept of multilevel modeling regression (MLM), which rests on nested data. I imagine your map( ) could be used to pull out the estimates generated by MLM. Thanks again for another superb lesson.
Glad you like it 🤗 and yeah the map() functions can help with loads of analyses 🥳
Great thanks. And cool new logo!
Thank you. That's exactly what I wanted to hear ❤️🤗
Keep doing the good work, Sir. Always a good feeling when I get a notification that a new video has been uploaded on your channel, Dr. Can you kindly consider doing a video on Web scraping, sir. There are none to very few resources on things like async web scraping using R (be it using httr2, mirai, async). As always, thank you for your good work, sir!
Thank you, I'm Happy to hear that 🤗 As for your topics, I'll add it to the backlog. Have you checked out my tutorial on {httr2} and {rvest} yet? 🤔
@@rappa753 thank you so much, Dr. I have indeed watched both of them. My first introduction to httr2 was actually by way of your video! I had not even known that the package existed prior to that, really.
Awesome! It's always delightful to hear that my videos made an impact. Thank you for sharing that. ♥️
+1
Thank you for watching my latest video. ♥ If you enjoyed this video, I'm sure you're also going to love my Data Cleaning Master Class. Clean your data and find insights much faster at data-cleaning.albert-rapp.de/
Thank you for exposing me to this library. Huge time saver. Will start implementing this right away
Awesome! Happy to hear that :)
We need more tutorials on the officeR Package. Very limited tutorials on youtube
Agreed. A Powerpoint tutorial is also on its way 🥳
Excellent, Is it possible to share the code?
Great video! I wonder what would be the benefit of using this package to make a Word doc as opposed to using Quarto and rendering as a Word doc?
More granular customization possibilities. With Quarto you have to go through pandoc which has limited Word processing features. But if you find that for your use case, Quarto has all that you need, then you can just as easily use that :)
Thanks for this tutorial ❤ Do you think it would be possible to use a template and the replacement functions to create a serial letter? I think „map“ could work, but then I will have a file for each letter. I already tried it with knittr and quarto but failed 😂 Thanks again 👍🏻
Not quite sure I understand the question correctly. You don't want to have separate files per letter? All letters in one Word doc on separate pages?
@@rappa753yes exactly. Like when you use the serial letter function in Word. At the moment I prepare my data with R, export it as csv and then use it with the serial letter function in Word. Now I thought that it would be nice to do everthing in R 😊
Unrealted question but how do you set up RStudio in a way to get these red-yellow-green squares that visualize the intendations?
It's the rainbow indent setting. I've described them at ua-cam.com/video/XHT1m-LKTVY/v-deo.html
Please do a qmd to PowerPoint, using custom PowerPoint template. Include the setting up PowerPoint and qmd parts. Company/custom styling etc.
I find the Quarto to PowerPoint documentation hard to decipher. But I'll show you how to create pptx files with custom templates using the {officer} package soon :)
Need to try this, I always copy pasted the charts to word doc
Let me know how it goes 😊 copy and paste is still a quick method for one-offs. But for repeated documents this will become tedious quite fast.
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 :)
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 😁
this is crazy,I watched first 10 mins without coding, which shows how you explain everything so easy
Thank you for watching my latest video. ♥ If you enjoyed this video, I'm sure you're also going to love my Data Cleaning Master Class. Clean your data and find insights much faster at data-cleaning.albert-rapp.de/
hi albert. nice video. Do you think we can use this in quarto? i mean use YAML parameters for replacement words like date?
Thank you very much for the tutorial. However, it seems that my density plot from one categroy is overlapping with the dotplot from another. Is there a way to fix this?
You're welcome :) You should fine what you need at 3:20
@@rappa753 Thank you .. I missed that
thanks a lot. as usual a great video. yes, glue_sql is really one of the best functions to work with databases
Very nice tips and details on the use of glue and SQL query!!! Thanks for explaining them. They are a bit tricky. It could have been quite a while until I figured out where the error is. What a nice optimized approach you used for this part of the filtering. Great video Albert!
Nice! I'm glad that you find this so useful 🤗🥳
What a timely video. I'm working on a project using Duck DB from R. I know that Duck DB supports enums, nested data, and pivots, but I have no idea how to use them with DBI or dplyr. I'll put examples in the replies.
Example #1: Nested data. Count how many people have data across multiple years for each state (I'm American). My dplyr code looks like this: my_data |> distinct(person_id, state, year) |> summarize( ids = list(person_id), ids_in_this_year = n(), .by = c(state, year) ) |> mutate( ids_in_next_year = map2_int(ids, lead(ids), \(x, y) sum(x %in% y)), ids_in_last_year = map2_int(ids, lag(ids), \(x, y) sum(x %in% y)), .by = state )
Have you seen the {duckplyer} package yet? 🤔
Example 2: Convert numerical csv data into factors/enums. The data come in as 1, 2, or 99 and need to have the labels "Yes," "No," and "Unknown." Again, I have a dplyr example, but I'm not sure how to do this conversion with database enums. my_data |> mutate( x1 = factor(x1, levels = c(1, 2, 99), labels = c("Yes", "No", "Unknown") )
Example 3: Pivots. Trying to use dbplyr just tells me there's no method for pivoting even though I know Duck DB has pivots con |> tbl("my_data") |> select(state, year, ids_in_this_year) |> pivot_wider( names_from = state, values_from = ids_in_this_year )
@@rappa753 I have heard of duckplyr. My understanding is that it works with data in memory. My data are larger than memory, so they have to sit in a duckdb file.
In my first year of data science i went through pain of writing a parser, build with paste XD this would have been easier. Although some time later i found out about the dbplyr package, which literally converts tidyverse syntax into sql syntax. quite nice if the queries aren't too complex
Yeah dbplyr is nice but it can still be useful to use a bit of SQL manually with glue_sql(). But kudos for building a parser 🥳
Thank you for watching my latest video. ♥ If you liked this video, I'm sure you're also going to love my Data Cleaning Master Class. Clean your data and find insights much faster at data-cleaning.albert-rapp.de/
Very nice package. Are you aware of anything like that to scrap data from pdf documents?
The {pdtfools} package lets you read the texts of the pdfs which you can then look through with functions from the {stringr} package. My latest video on text cleaning gives you a couple of pointers on how to use {stringr}.
I recently discovered your teachings here and on LinkedIn. You are a brilliant instructor-thank you!
Thank you ☺
==> quarto preview Untitled.qmd --to dashboard --no-watch-inputs --no-browse ERROR: Validation of YAML front matter failed. ERROR: In file Untitled.qmd (line 3, columns 9--18) Field "format" has value dashboard, which must instead be 'asciidoc' 2: title: B dashboard 3: format: dashboard ~~~~~~~~~~ 4: theme: flatly ERROR: Render failed due to invalid YAML.
Do you have Quarto v1.4 or higher? 🤔
@@rappa753sir I have Quarto v1.4.4
@@rappa753 Yes, it is v 1.4.4 and R version 4.3.3 (2024-02-29)
@@abdiomar22 Weird. Maybe there are too many white spaces after "dashboard" or somewhere else in the YAML? Unfortunately, YAML is really tricky in that sense
@@abdiomar22 Maybe your RStudio version also bundles an old Quarto version as mentioned here: forum.posit.co/t/quarto-1-4-gives-an-error-when-rendering-a-dashboard-format-document/183011/2
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
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 🥳
Thank you for this. I learnt about a new trick, using group in str_detect thank you for this
Hi, where I can find tbl_data.csv ?
Why not scrape it? The issue with copy-paste that it is not strictly reproducible.
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.
@@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.
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 UA-cam 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.
Yup that's the idea. Part 3 of the course will have much more like this :)
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!
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
You always surprise me with functions in well known packages which I haven't know. Thanks!
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
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. ❤❤❤❤
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.
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.