How to Clean Up Messy Excel files in R | 7 Easy Strategies

Importing messy Excel files into R can be super tedious. In this video, I show you 7 examples and how to clean them up like a pro. CODE: https://gist.github.com/AlbertRapp/05... Data comes from https://foresightbi.com.ng/microsoft-... Example 2 was constructed from example 1 just like described in the video. Last example comes from Janitor Package https://github.com/sfirke/janitor/blo... SUPPORT THIS CHANNEL Sponsor a coffee and help me create better videos at https://www.buymeacoffee.com/rappa753 MORE VIDEOS 📺 Avoid duplicate R code in 150 seconds    • Avoid duplicate code with powerful functio...   📺 Use functions instead of for-loops    • Use functions instead of for-loops in 150 ...   📺 Fast explainer playlist    • Explainer videos   Subscribe at 👉    / @rappa753   MORE CONTENT weekly 3-minute newsletter about R, DataViz and webdev at https://alberts-newsletter.beehiiv.co... Twitter account at   / rappa753   TIME CODES 00:00 Intro 00:07 Example 1: Import, fix column names and rearrange data 03:12 Example 2: Fix weird dates from Excel 03:50 Example 3: Split one-column data 04:58 Example 4: Split numbers and units 05:33 Example 5: Fix common typos that destroy your data 06:17 Example 6: Split multi-item columns 06:59 Example 7: Remove empty or constant columns ------------------- Music Promoted by Music & Gene at YouTube:    / musicgene   https://geniemindcreation.wixsite.com... Music by MBB |   / mbbofficial      / mbbmusic     / mbb_music   Buy Music Licenses at www.mbb-music.com --------------------- #rstats #excel #datacleaning