Hands-on dplyr tutorial for faster data manipulation in R
HTML-код
- Опубликовано: 15 июл 2024
- dplyr is a new R package for data manipulation. Using a series of examples on a dataset you can download, this tutorial covers the five basic dplyr "verbs" as well as a dozen other dplyr functions.
Watch the follow-up tutorial: • Going deeper with dply...
View the R Markdown document: rpubs.com/justmarkham/dplyr-tu...
Download the source document: github.com/justmarkham/dplyr-...
Read about why I love dplyr: www.dataschool.io/dplyr-tutor...
Tutorial contents:
1. Introduction to dplyr (starts at 0:00)
2. Loading dplyr and the example dataset (starts at 2:29)
3. Understanding "local data frames" (starts at 3:23)
4. Verb #1: `filter` (starts at 5:17)
5. Verb #2: `select`, plus `contains`, `starts_with`, `ends_with`, `matches` (starts at 7:54)
6. Using chaining syntax for more readable code (starts at 9:34)
7. Verb #3: `arrange` (starts at 12:53)
8. Verb #4: `mutate` (starts at 13:55)
9. Verb #5: `summarise`, plus `group_by`, `summarise_each`, `n`, `n_distinct`, `tally` (starts at 15:31)
10. Window functions: `min_rank`, `top_n`, `lag` (starts at 26:47)
11. Convenience functions: `sample_n`, `sample_frac`, `glimpse` (starts at 32:44)
12. Connecting to databases (starts at 34:21)
== RESOURCES ==
Reference manual and vignettes: cran.r-project.org/web/package...
July 2014 webinar: pages.rstudio.net/Webinar-Seri...
July 2014 webinar code: github.com/rstudio/webinars/t...
Tutorial by Hadley Wickham: www.dropbox.com/sh/i8qnluwmui...
GitHub repo: github.com/hadley/dplyr
List of releases: github.com/hadley/dplyr/releases
== LET'S CONNECT! ==
Newsletter: www.dataschool.io/subscribe/
Twitter: / justmarkham
Facebook: / datascienceschool
LinkedIn: / justmarkham
You rock dude, 6 year later and this vid is still really really helpful.
Willing to PAY anyone to do my business statistics R homework!!!! Someone please message me ASAP to negotiate a price
This is great! I really love the fact that you show the "base R" approach as a comparison. Looking forward to more vids.
Thanks! Glad it was helpful to you!
I've been using dplyr for a while now and I still learned some new and useful stuff from this video. Thanks very much for sharing.
You're welcome! Glad it was useful to you. I'm planning to create an "updates" video once dplyr 0.3 is released!
Thank you for putting these tutorials together. They are FANTASTIC for the R newbie. And I particularly love that you have the R Markdown version that we can keep for reference.
Awesome! You are very welcome! Here's a link to the GitHub repository, for anyone who needs it: github.com/justmarkham/dplyr-tutorial
This is, with out question, one of the best R tutorials i have seen! Thank you!
Thank you so much!
That was a well spent 40 minutes. Very neat, precise, and easy to understand. You have my additional gratitude for comparing the dpylr to the base R functions, which helped in visualizing why dpylr is practical. Thank You!
You're very welcome! Thanks so much for your incredibly nice comment! :)
I was doing the side by side comparison on a spreadsheet, then I found your video. This is gold. I subscribed to your channel immediately. So thankful to you.
That's great to hear... thanks so much for sharing!
Thanks a lot! As a greenhand to R, your presentation is really helpful to me! Great!
very clear, straightforward, succinct, and helpful. i particularly liked the way the dplyr approach was contrasted with the base R approach for each of the examples. excellent. thank you.
Wow, thanks David Adelson, that's such a nice compliment! I appreciate you taking the time to share it with me!
yes thank u 4 sharing - Its what America is all about! and still the same & going strong in 2022 whew whew! Really grateful for showing the chaining option really cuts down on my workflow
Thanks for this video! I really loved the way you explain things. Very clear and step-by-step approach. Will definitely watch more of your videos to get better in R!
Thanks for your kind words! 🙌
I have learned more about how to neatly and efficiently using more than one functions to apply on more than one columns at once.
Really appreciate your organized illustration!!!
Thank you so much!!!!!
Anticipating for more lessons from you:))))))))))))))))
Awesome, I'm glad you learned a lot from the video!
This tutorial is the most helpful resource I've found thus far for my Data Science project. Thank you so much for posting!!
You're very welcome! I'm so glad to hear that it has been helpful to you!
I'm fairly new to R and didn't really know where to start for my current project. I think I learned about 90% of what I need to know from this video. Thank you very much!
Awesome!
8 years old, still the best tutorial on dplyr.
Wow, thank you! 🙏
The way you explained the commands comparing to Base R help us to appreciate dplyr. Thanks. Good job
You're welcome!
Outstanding video, I never knew that dplyr was so powerful AND easy. Thank you for providing this video!
+Michael Fry Glad it was helpful to you! Thanks for your kind words!
Thanks for this great video. I learnt more here in 1 hour than in several days surfing the Internet!
Awesome, that was my goal! Thanks for your comment!
me too!
Very clear and useful tutorial on dplyr. Thanks a lot!
wow your simply the best instructor in youtube world.
you shorten the time I need explore more about dplyr; very clear explanations. Many thanks
Thank you so much! 😄
I am teaching statistics and data manipualtion and this is most useful! Thanks for this.
Your tutorial is meticulous, clear and useful for those who are used to basic R approach but feels a need to learn dplyr package. This not lengthy video does help me to write R-code in an efficient and convenient manner. Thanks.
You're very welcome!
Best tutorial i have never watched on Yutub .Thank u and keep moving forward .
Thank you! 👍
It's just time-worthy step from my side to watch this video. I pay my gratitude to your nice work. Thanks a lot.
You're welcome! Thanks for the kind comment!
Thanks a lot for this very clear and instructive tutorial !
+Morten Bunes Gustavsen You're very welcome!
Thx for putting this together, it's amazingly clear. I find the comparison with the standard R code very useful.
Great to hear! You are very welcome!
Thank you for doing this Kevin!
Thankyou so much for this detailed and crisp tutorial!
You're very welcome!
Thank you Kevin. You are helping so many people with your great explanations. I'm also doing the Data Science Specialization through Coursera.
You're very welcome, Astrid! Good luck with the Specialization!
Do you such an excellent job at teaching. Everything is so thought through and organized that it makes learning easy.
Thanks very much for your kind words!
2020 and still a very informative and wonderful video. Thanks!
You're welcome!
Your explanations is second to none
Thank you!
The dplyr package should simplify exploratory data analysis when used in conjunction with the graphics packages (base, ggplot2, or lattice). Excellent introductory tutorial.
Thank you!!! The Chaining example is awesome, and makes complete sense now.
You're very welcome!
You're so clear man. Proud of you!
Thanks!
Very useful! Especially the part that shows how to connect to a database. Thank you!
+Shi Shu You're very welcome! Glad it was helpful to you!
Thanks thats a great tutorial ! and the structure is perfect!
Appreciating your great work! Thanks again.
Thanks!
Great video and well explained. Please keep posting this type of videos.
Thanks!
Really very informative and to the point. Thanks a lot for creating and sharing this video.
Glad it was helpful!
Very clear and helpful ! Thank you for your time and efforts.
You're very welcome!
Thank you so so much for your tutorials and materials!
You are so welcome!
Thanks a lot. Your explanation is clear and direct.
You are welcome!
Very easy to understand, straight to the point and useful for beginners like me ^^
thank you very much !
You're very welcome!
this is my favorite R tutorial on youTube. Merci BCP
You're welcome!
thanks for the tutorial! big shout out from Brazil
You're welcome!
38 mins well spent thanks for an awsum tutorial!!!
Great to hear! Thanks for watching :)
Saved the day! thank you ever so much. Keep them coming!
+fahadshery Great to hear!
excellent, thank you for your time to share the explanation!
You are very welcome!
Very precise to the point lecture,...! Thank you much
You are welcome!
Excellent video,cleared all my basics....very very thanks
You're very welcome!
Explanation was awesome. It's changed n improved my perception towards Rstudio
Thanks! Glad it was helpful to you!
Thanks for this elegant presentation sir
You are most welcome!
Awesome tutorial! I'll surely rework all my codes with this... Thanks!
Thanks! dplyr makes code so much easier to read, right?
I just started 38:56 mins ago, now I am a R expert. Thanks a lot
You're welcome!
Really helpful..thanks for the efforts
Excellent tutorial. Thank you very much, Sir.
You're very welcome!
26:47
10. Window functions: `min_rank`, `top_n`, `lag` (starts at 26:47)
32:44
11. Convenience functions: `sample_n`, `sample_frac`, `glimpse` (starts at 32:44)
34:21
12. Connecting to databases (starts at 34:21)
Great Video, it helped me to learn more on dplyr.. Subscribed and searching for more videos from Data School's list :D Thank you!
You're welcome!
This is simply fantastic. I have gone through so many forums - R help, Stats exchange etc etc and in most of the cases ppl bluntly say go and brush ur skills and don't believe in answering easy questions posted by newbies. However in the video above you have taken the pain to explain step by step how dyply is working. Really helped.
In 11:31 we are filtering where DepDelay >60 so can we do a similar between 2 columns. I did so but received an error as they were factors. Thanks,
Shivi Bhatia Thanks for your kind comments! Glad it's helpful to you! As for your question, you can filter on multiple conditions by listing them separated by commas. For example: filter(flights, Month==1, DayofMonth==1)
I found following your steps in the video, but applying them to my own data, was incredibly helpful. Thanks for the great video and my code as a result is more efficient and aesthetically pleasing :-)
You're very welcome!
This is an extremely helpful and well done video. Thank you very much for making it.
You're welcome! And I'll have a follow-up dplyr video coming soon! :)
Great tutorial. Thank you so much.
You're very welcome!
Perfect explanation!
Thank you!
Really helpful video.
Thanks a lot for this very clear and instructive tutorial
You're very welcome!
Thanks for making this video! it was very useful
You're welcome!
Thank you for posting this, I saw the link for this in the Data Scientists Toolbox class on Coursera.
Simple and concise. Thank you :)
You're welcome!
Very well explained and helpful. Thanks
You're very welcome!
Thank you very much for your interpretation !! it helps a lot
Great to hear!
thanks Kavin It was great!
Nicely done 👍
Great Video!
(and fantastic package)
+Joshua Hruzik Thanks!
Great video, thanx a lot!
It's very helpful!! Thank youu
Hi... Thanks for this video. I really learned many things.
Greetings from Venezuela
Great to hear!
you are truly awesome . Thank you so much for this .
Thanks for your kind words!
awesome tutorial man very helpfull and easy to understand !
Thanks!
Thank you! Very clear and helpful.
You're welcome!
Very good video, clear and clean
Thanks!
Very helpful vedio for learning dplyr. And it's very kind that he(the lecturer) provides link where we can download all R-script and explanations. Thanks!
Thanks for your kind words!
That you for you time and effort to make the vídeo!
Congratulations!
You're very welcome!
Great video! Thanks Kevin!
Thanks Ed! Glad it was helpful to you :)
simple, well organized flow
Thanks!
Excellent!
Many thanks!
Thanks a lot, great presentation.
You're welcome!
Very helpful. Thank you
You're welcome!
THank you .... very detailed and informative
Glad it was helpful to you!
Super helpful! thank you
You're very welcome!
you r awesome ...great clear learning steps .. 🙏👍👍👍👍
Thanks!
A lot of thanks, greetings from a beginner in rstudio.
You're welcome!
Great intro. Thanks a lot!
+Juliusz Gonera You're welcome!
Thanks a lot ....very usefully to all
+Thrinadh Nagubadi You're welcome!
Thanks! Great video!
You're welcome!
Superb liked it very much.... easy, neat and clan explanation... super like
+Anurag Sharma I super appreciate it :)
Very good! Thank you.
You're welcome!
Excellent! Thank you
You're welcome!
nicely done!
+python tools Thanks!
Another great video by Mark. One thing I would add is name your data frame dfFlights so you don't get it mixed up with the column Flights.
Glad you liked the video!
It is really nice. Great thank you very much
You are welcome 😊