Use pivot_wider() to shape your data. R programming from beginners.

[@RProgramming101]

Get my FREE cheat sheets for R programming and statistics (including transcripts of these lessons) here: www.learnmore365.com/courses/rprogramming-resource-library

[@muhammedhadedy4570]

Waiting for every single video on your KZbin channel. Thank you so much.

[@RProgramming101]

Most welcome 😊 Thanks for the lovely feedback.

[@nabeelsiddiqui3377]

I absolutely love that you are like the only one that uses large text. I always watch these on my phone. Please cover more advanced topics as well such as multilevel regression, etc.

[@RProgramming101]

Thanks for the feedback! Will do :)

[@JacquesHenriqueDias]

you and your habit of saving my life when I'm coding in r. Thank you very much, have a nice weekend!

[@RProgramming101]

Wow Jacques - what a nice thing to say (thanks!!)

[@josephkimote661]

Your work is wow! Take us through data imputation too

[@oliviagrau3749]

Thank you for the great videos. Could you make a video focused on manipulating dates, like converting characters to dates, extracting a certain part of a date or grouping date-hours into days, etc.?

[@RProgramming101]

Will do.

[@TimothyChenAllen]

You had me at "boom-shaka-laka"

[@RProgramming101]

Haha

[@davidispiryan5689]

Thanks a lot for all this great videos!!

[@RProgramming101]

Glad you like them! My pleasure!

[@katyadimitrovapetrova9343]

so useful, thank you

[@haraldurkarlsson1147]

Greg, And then...? Once we have created our wide data then what? Other than just displaying it in human readable form? Can you give an example of use (are we getting average tree growth or...?). I figure that this exercise probably shows best the reason for using long data. Not having sensible variable names is quite confusing.

[@RProgramming101]

You make a good point. I prefer long data. My next video will be about how to get data from wide to long. Some people like wide data to help with time series analysis (for example) but even for that, I prefer long data

[@Shawn-gm4cf]

There is a great article on tidy data that explains why wide and long data matter written by the guy who came up with the Tidyverse. You can access it here: vita.had.co.nz/papers/tidy-data.pdf

[@haraldurkarlsson1147]

@@Shawn-gm4cf The R guru Hadley Wickham?

[@Shawn-gm4cf]

@@haraldurkarlsson1147 Yep!

[@mugomuiruri2313]

Good

[@RProgramming101]

Thanks

[@vincentdujardin7322]

And what if you have more than three original columns? How do you know where to put them?

[@deekshashetty-xx3gq]

can not find pivot_wider function, i m getting this error. Could you please help with this...

[@Sorjen108]

Maybe because the tidyr package is not attached Load the tidyverse like below: library(tidyverse)

[@dvojedece]

Love your videos, but the adds are a bit annoying

[@RProgramming101]

Thank you for the feedback.