Albert Rapp
Albert Rapp
  • 103
  • 150 905
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
Переглядів: 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

КОМЕНТАРІ

  • @onkar7651
    @onkar7651 2 дні тому

    Super-duper useful video, thank you, Albert, for your amazing contribution to the #rstats community.

  • @daviddehoog9269
    @daviddehoog9269 4 дні тому

    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!

  • @djangoworldwide7925
    @djangoworldwide7925 6 днів тому

    5:15 I would introduce libpath to demonstrate this idea.. great vid. Renv is Great

    • @rappa753
      @rappa753 5 днів тому

      Ahh you're right. Clearly I missed an opportunity there 😅

  • @DM-py7pj
    @DM-py7pj 6 днів тому

    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

    • @rappa753
      @rappa753 5 днів тому

      @@DM-py7pj interesting 😯 I thought it's one standalone library per project. Possibly renv has some optimization going on here 🤔

    • @DM-py7pj
      @DM-py7pj 5 днів тому

      @ 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").

    • @rappa753
      @rappa753 5 днів тому

      @@DM-py7pj Pretty cool optimization

  • @rappa753
    @rappa753 6 днів тому

    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

  • @transportation-talk
    @transportation-talk 8 днів тому

    You're awesome! Thank you for your hard work.

    • @rappa753
      @rappa753 8 днів тому

      You're welcome. I'm just glad that this is appreciated so much 😊

  • @enocharthur4322
    @enocharthur4322 11 днів тому

    Amazing...finaallllyyyy... tutorials on PowerPoint. This is very important. We need more tutorials on this

    • @rappa753
      @rappa753 10 днів тому

      Glad that you're so excited about this 🤗

    • @enocharthur4322
      @enocharthur4322 8 днів тому

      ​@@rappa753Thank you so much. Please please please do more videos on R and PowerPoint

  • @blaisepascal3905
    @blaisepascal3905 12 днів тому

    Really nice! But why not use Quarto to export to pptx?

    • @rappa753
      @rappa753 11 днів тому

      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.

    • @blaisepascal3905
      @blaisepascal3905 11 днів тому

      @rappa753 Thank you for your nice and precise answer!

    • @rappa753
      @rappa753 11 днів тому

      @@blaisepascal3905 you're very welcome. I'm always happy to help 🤗

  • @djangoworldwide7925
    @djangoworldwide7925 12 днів тому

    Next big thing: integration of ggiraph with pptx, so you get interactivity within the slide!

    • @rappa753
      @rappa753 12 днів тому

      Would be cool but I don't think pptx has a built-in JavaScript functionality to handle the interactivity 🤔

  • @taiwankyh
    @taiwankyh 13 днів тому

    thanks so much

    • @rappa753
      @rappa753 13 днів тому

      You're welcome! 😊

  • @rappa753
    @rappa753 13 днів тому

    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

  • @andregouveia4051
    @andregouveia4051 18 днів тому

    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 😉

    • @rappa753
      @rappa753 17 днів тому

      The video will come in the next few weeks. I've already recorded it but haven't gotten around to the editing part yet 😊

  • @djangoworldwide7925
    @djangoworldwide7925 19 днів тому

    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

    • @rappa753
      @rappa753 19 днів тому

      Oh I love it when that happens and the error just tells me the solution 😍

  • @djangoworldwide7925
    @djangoworldwide7925 19 днів тому

    Does hadley even write in R? Its all c and c++ under the mighty tidy hood 😅

    • @rappa753
      @rappa753 19 днів тому

      Good question. Haven't thought about that 😂

  • @carvalhoribeiro
    @carvalhoribeiro 20 днів тому

    Great explanation. Thanks for sharing this

    • @rappa753
      @rappa753 19 днів тому

      You're welcome. Happy to help ☺

  • @rappa753
    @rappa753 21 день тому

    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/

  • @haraldurkarlsson1147
    @haraldurkarlsson1147 23 дні тому

    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.

    • @rappa753
      @rappa753 23 дні тому

      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 😊

  • @enocharthur4322
    @enocharthur4322 27 днів тому

    A simpler example would have drum home the point faster. Great work though

    • @rappa753
      @rappa753 23 дні тому

      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

  • @albertocabrera4297
    @albertocabrera4297 27 днів тому

    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.

    • @rappa753
      @rappa753 23 дні тому

      Glad you like it 🤗 and yeah the map() functions can help with loads of analyses 🥳

  • @adan8657
    @adan8657 27 днів тому

    Great thanks. And cool new logo!

    • @rappa753
      @rappa753 27 днів тому

      Thank you. That's exactly what I wanted to hear ❤️🤗

  • @thespaniardinme
    @thespaniardinme 27 днів тому

    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!

    • @rappa753
      @rappa753 27 днів тому

      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? 🤔

    • @thespaniardinme
      @thespaniardinme 27 днів тому

      @@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.

    • @rappa753
      @rappa753 27 днів тому

      Awesome! It's always delightful to hear that my videos made an impact. Thank you for sharing that. ♥️

    • @ambhat3953
      @ambhat3953 26 днів тому

      +1

  • @rappa753
    @rappa753 27 днів тому

    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/

  • @siddheshpujari25
    @siddheshpujari25 29 днів тому

    Thank you for exposing me to this library. Huge time saver. Will start implementing this right away

    • @rappa753
      @rappa753 29 днів тому

      Awesome! Happy to hear that :)

  • @enocharthur4322
    @enocharthur4322 Місяць тому

    We need more tutorials on the officeR Package. Very limited tutorials on youtube

    • @rappa753
      @rappa753 29 днів тому

      Agreed. A Powerpoint tutorial is also on its way 🥳

  • @reem19681
    @reem19681 Місяць тому

    Excellent, Is it possible to share the code?

  • @sanderellphillip
    @sanderellphillip Місяць тому

    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?

    • @rappa753
      @rappa753 Місяць тому

      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 :)

  • @ferrocen
    @ferrocen Місяць тому

    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 👍🏻

    • @rappa753
      @rappa753 Місяць тому

      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?

    • @ferrocen
      @ferrocen Місяць тому

      @@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 😊

  • @JollyRoger183
    @JollyRoger183 Місяць тому

    Unrealted question but how do you set up RStudio in a way to get these red-yellow-green squares that visualize the intendations?

    • @rappa753
      @rappa753 Місяць тому

      It's the rainbow indent setting. I've described them at ua-cam.com/video/XHT1m-LKTVY/v-deo.html

  • @DM-py7pj
    @DM-py7pj Місяць тому

    Please do a qmd to PowerPoint, using custom PowerPoint template. Include the setting up PowerPoint and qmd parts. Company/custom styling etc.

    • @rappa753
      @rappa753 Місяць тому

      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 :)

  • @ambhat3953
    @ambhat3953 Місяць тому

    Need to try this, I always copy pasted the charts to word doc

    • @rappa753
      @rappa753 Місяць тому

      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.

  • @djangoworldwide7925
    @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
      @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 😁

  • @mbmathematicsacademic7038
    @mbmathematicsacademic7038 Місяць тому

    this is crazy,I watched first 10 mins without coding, which shows how you explain everything so easy

  • @rappa753
    @rappa753 Місяць тому

    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/

    • @nithin.m2675
      @nithin.m2675 Місяць тому

      hi albert. nice video. Do you think we can use this in quarto? i mean use YAML parameters for replacement words like date?

  • @sunrunnerke
    @sunrunnerke Місяць тому

    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?

    • @rappa753
      @rappa753 Місяць тому

      You're welcome :) You should fine what you need at 3:20

    • @sunrunnerke
      @sunrunnerke Місяць тому

      @@rappa753 Thank you .. I missed that

  • @ThomasJacobsen-h8d
    @ThomasJacobsen-h8d Місяць тому

    thanks a lot. as usual a great video. yes, glue_sql is really one of the best functions to work with databases

  • @mignacio79
    @mignacio79 Місяць тому

    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!

    • @rappa753
      @rappa753 Місяць тому

      Nice! I'm glad that you find this so useful 🤗🥳

  • @rayflyers
    @rayflyers Місяць тому

    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.

    • @rayflyers
      @rayflyers Місяць тому

      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 )

    • @rappa753
      @rappa753 Місяць тому

      Have you seen the {duckplyer} package yet? 🤔

    • @rayflyers
      @rayflyers Місяць тому

      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") )

    • @rayflyers
      @rayflyers Місяць тому

      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 )

    • @rayflyers
      @rayflyers Місяць тому

      ​@@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.

  • @user-sq9wp2ge4h
    @user-sq9wp2ge4h Місяць тому

    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

    • @rappa753
      @rappa753 Місяць тому

      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 🥳

  • @rappa753
    @rappa753 Місяць тому

    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/

  • @PaoloTolomeo-d5b
    @PaoloTolomeo-d5b Місяць тому

    Very nice package. Are you aware of anything like that to scrap data from pdf documents?

    • @rappa753
      @rappa753 Місяць тому

      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}.

  • @santia6756
    @santia6756 Місяць тому

    I recently discovered your teachings here and on LinkedIn. You are a brilliant instructor-thank you!

    • @rappa753
      @rappa753 Місяць тому

      Thank you ☺

  • @abdiomar22
    @abdiomar22 2 місяці тому

    ==> 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.

    • @rappa753
      @rappa753 2 місяці тому

      Do you have Quarto v1.4 or higher? 🤔

    • @abdiomar22
      @abdiomar22 2 місяці тому

      @@rappa753sir I have Quarto v1.4.4

    • @abdiomar22
      @abdiomar22 2 місяці тому

      @@rappa753 Yes, it is v 1.4.4 and R version 4.3.3 (2024-02-29)

    • @rappa753
      @rappa753 Місяць тому

      @@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

    • @rappa753
      @rappa753 Місяць тому

      @@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

  • @ambhat3953
    @ambhat3953 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

    • @rappa753
      @rappa753 2 місяці тому

      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 🥳

  • @ahmed007Jaber
    @ahmed007Jaber 2 місяці тому

    Thank you for this. I learnt about a new trick, using group in str_detect thank you for this

  • @D2-DataDoctor
    @D2-DataDoctor 2 місяці тому

    Hi, where I can find tbl_data.csv ?

  • @haraldurkarlsson1147
    @haraldurkarlsson1147 2 місяці тому

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

    • @rappa753
      @rappa753 2 місяці тому

      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
      @haraldurkarlsson1147 2 місяці тому

      @@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.

  • @albertocabrera4297
    @albertocabrera4297 2 місяці тому

    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.

    • @rappa753
      @rappa753 2 місяці тому

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

  • @asolisca
    @asolisca 2 місяці тому

    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
      @rappa753 2 місяці тому

      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

  • @iwoaugustynski9265
    @iwoaugustynski9265 2 місяці тому

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

    • @rappa753
      @rappa753 2 місяці тому

      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

  • @muhammedhadedy4570
    @muhammedhadedy4570 2 місяці тому

    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
      @woodspock 2 місяці тому

      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
      @rappa753 2 місяці тому

      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.