Andy, i'm learning so much from your videos. Have watched four now and looking forward to moving on to some others. I get most from just watching you clean data and think of stats you want to make. You should do one on that (if it wouldn't be boring for you!). Loving it either way
My older videos have a lot of improvisational cleaning but I've transitioned over to focusing on specific topics for each video. I may start livestreaming TidyTuesday datasets which would have a lot of data cleaning and metric creation. Thanks for watching!
How to upload an excel file/ Google sheet or database which includes data into R and do the analysis there. But, if have the data on monthly basis so I want to add the data and just hit the button refresh to add the data for the next month. I want to have bar chart and pie as well as maps and all in interactive ones in a beautiful dashboard. If we have a video like this that would be so amazing. Thanks in advance.
I think my video on functions would help you with this task th-cam.com/video/7oz1qGClrl0/w-d-xo.html . But I can also break it into 4 main ideas for what I think you want to do. 1. Create a report/dashboard using R Markdown with the excel/Google file 2. Inside the report, create a command that will read in the main dataset and also any new data. Then combine them together and remove any duplicates. 3. Create an R script that will execute the R Markdown file. This is a simple command such as rmarkdown::render("report.Rmd) 4. Use taskscheduleR to run the R script on a specific time. Hopefully, this helps but I may make a video on job scheduling in R. -Andrew
I learn a lot from how quickly you wrangle data
Great video Andrew! Thanks!
Andy, i'm learning so much from your videos. Have watched four now and looking forward to moving on to some others. I get most from just watching you clean data and think of stats you want to make. You should do one on that (if it wouldn't be boring for you!). Loving it either way
My older videos have a lot of improvisational cleaning but I've transitioned over to focusing on specific topics for each video. I may start livestreaming TidyTuesday datasets which would have a lot of data cleaning and metric creation. Thanks for watching!
@@AndrewCouch Nice. I'll check some out. Thank _you_
Hi Andrew,
Does these GGanimate functions also work in Rmarkdown after knitting to HTML ?
Yes Gganimate works with html documents. You can either use gifs which is the default or a video file using ffmpeg_renderer()
How to upload an excel file/ Google sheet or database which includes data into R and do the analysis there. But, if have the data on monthly basis so I want to add the data and just hit the button refresh to add the data for the next month. I want to have bar chart and pie as well as maps and all in interactive ones in a beautiful dashboard. If we have a video like this that would be so amazing. Thanks in advance.
I think my video on functions would help you with this task th-cam.com/video/7oz1qGClrl0/w-d-xo.html . But I can also break it into 4 main ideas for what I think you want to do.
1. Create a report/dashboard using R Markdown with the excel/Google file
2. Inside the report, create a command that will read in the main dataset and also any new data. Then combine them together and remove any duplicates.
3. Create an R script that will execute the R Markdown file. This is a simple command such as rmarkdown::render("report.Rmd)
4. Use taskscheduleR to run the R script on a specific time.
Hopefully, this helps but I may make a video on job scheduling in R.
-Andrew