How to create a Line Graph & Group by Months & Year | ggplot2 dplyr | R for Excel Users & Beginners

The hardest thing with learning anything new is just starting. The idea behind R for Excel Users is purely for that, by using common excel tasks as examples, so that barrier to learning something new, is not quite so daunting.

In this video, I’ll be covering how to create a line graph using ggplot and how to group data into months and year, as well as formatting the x & y axis.

📁 Data Set used can be found here - https://data.world/deanchereden/covid...

📁 The R code file can be found here -
https://data.world/deanchereden/covid...

▶️ How to Download R & R Studio
   • How to Download R & R Studio, Run R Studio...  

🔖c h a p t e r s 🔖

00:00 - Intro
00:23 - Quick overview
01:08 - Importing Dataset
01:13 - Install Tidyverse & load in ggplot, dplyr & scales
01:52 - Filter dataset by location UK
02:48 - Create a simple line graph
03:49 - Create a month & year column
05:48 - Line graph by months & year - broken :(
06:55 - Group by month & sum of new cases
08:11 - Line graph by months & year - working :)
09:09 - Format x & y axis
13:52 - Label x & y axis
14:29 - Add data point to the line for each month

💌 My email - dean@deanchereden.com
🌍 My website - https://www.deanchereden.com
🐦 Twitter -   / deanchereden  

🎵 Music - Misha, Jussi Halme - Higher https://chll.to/4ec991f9

🙌 Follow Misha
・ SoundCloud: https://chll.to/386e721b
・ Spotify: https://chll.to/5f0bc9ba
・ Apple Music: https://chll.to/5a239af3
・ Chillhop: https://chll.to/2b2bc310

🙌 Follow Jussi Halme
・ Spotify: https://chll.to/dd4a82d2
・ Apple Music: https://chll.to/4961c878
・ Chillhop: https://chll.to/eb17b45e

🎶 Listen to Chillhop Music -    • Misha & Jussi Halme - Bliss (A Felicidade)...