Tidy Country

Creating Tidy Text from Billboard Lists.

By Monty Reynolds

January 25, 2021

library(reticulate)

artists = ['Luke Combs', 'Walker Hayes', 'Gabby Barrett', 'Luke Combs', 'Chris Young + Kane Brown', 'Gabby Barrett', 'Ryan Hurd With Maren Morris', 'Chris Stapleton', 'Nelly & Florida Georgia Line', 'Dan + Shay', 'Keith Urban Duet With P!nk', 'Elle King & Miranda Lambert', 'Thomas Rhett', 'Miranda Lambert', 'Morgan Wallen', 'Eric Church', 'Lainey Wilson', 'Jordan Davis', 'Dierks Bentley', 'Niko Moon', 'Morgan Wallen', 'Jason Aldean & Carrie Underwood', 'Cole Swindell', 'Sam Hunt', 'Thomas Rhett', 'Lee Brice', 'Luke Bryan', 'Elvie Shane', 'Jake Owen', 'Chase Rice Featuring Florida Georgia Line', 'Jason Aldean', 'Chris Stapleton', 'Morgan Wallen', 'Jameson Rodgers Featuring Luke Combs', 'Luke Bryan', 'Old Dominion', 'Florida Georgia Line', 'Dylan Scott', 'Justin Moore', 'Parmalee x Blanco Brown', 'Jordan Davis Featuring Luke Bryan', 'Morgan Wallen', 'Blake Shelton', 'Kenny Chesney', 'Tenille Arts', 'Morgan Wallen', 'Brett Young', 'Carly Pearce', 'Dustin Lynch', 'Scotty McCreery', 'Darius Rucker', 'Kelsea Ballerini', 'Kane Brown X blackbear', 'Luke Combs', 'Priscilla Block', 'Blake Shelton Featuring Gwen Stefani', 'Dan + Shay', 'Little Big Town', 'Dustin Lynch Featuring Lauren Alaina Or MacKenzie Porter', 'Michael Ray', 'Garth Brooks & Trisha Yearwood', 'Morgan Wallen', 'Parker McCollum', 'Tim McGraw & Tyler Hubbard', 'Zac Brown Band', 'Kelsea Ballerini Featuring Kenny Chesney', 'Rascal Flatts', 'Kenny Chesney', 'Jon Pardi', 'Jimmie Allen & Brad Paisley', 'Lady A', 'Kane Brown', 'Chris Lane', 'Morgan Wallen', 'Morgan Wallen', 'Lady A', 'HARDY', 'Parker McCollum', 'Morgan Wallen', 'Taylor Swift', 'Russell Dickerson', 'Kane Brown', 'Morgan Wallen', 'Aaron Lewis', 'Lee Brice', 'Taylor Swift', 'Trey Lewis', 'HARDY Featuring Lauren Alaina & Devin Dawson', 'Jon Pardi', 'Russell Dickerson', 'Brothers Osborne', 'Dan + Shay', 'Kelsea Ballerini & LANY', 'Garth Brooks', 'Warren Zeiders', 'Kelly Clarkson & Brett Eldredge', 'Carrie Underwood', 'Carrie Underwood & John Legend', 'Mitchell Tenpenny', 'Ingrid Andress']

songs = ['Forever After All','Fancy Like','I Hope','Better Together', 'Famous Friends', 'The Good Ones', 'Chasing After You', 'Starting Over', 'Lil Bit', 'Glad You Exist', 'One Too Many', 'Drunk (And I Dont Wanna Go Home)', 'Whats Your Country Song', 'Settling Down', 'Sand In My Boots', 'Hell Of A View', 'Things A Man Oughta Know', 'Almost Maybes', 'Gone', 'Good Time', 'Wasted On You', 'If I Didnt Love You', 'Single Saturday Night', 'Breaking Up Was Easy In The 90s', 'Country Again', 'Memory I Dont Mess With', 'Waves', 'My Boy', 'Made For You', 'Drinkin Beer. Talkin God. Amen.', 'Blame It On You', 'You Should Probably Leave', 'More Than My Hometown', 'Cold Beer Calling My Name', 'Down To One', 'I Was On A Boat That Day', 'Long Live', 'Nobody', 'We Didnt Have Much', 'Just The Way', 'Buy Dirt', 'Somebodys Problem', 'Minimum Wage', 'Knowing You', 'Somebody Like That', '7 Summers', 'Lady', 'Next Girl', 'Mommas House', 'You Time', 'Beers And Sunshine', 'Hole In The Bottle', 'Memory', 'Cold As You', 'Just About Over You', 'Happy Anywhere', 'I Should Probably Go To Bed', 'Wine, Beer, Whiskey', 'Thinking Bout You', 'Whiskey And Rain', 'Shallow', 'Still Goin Down', 'Pretty Heart', 'Undivided', 'Same Boat', 'Half Of My Hometown', 'How They Remember You', 'Happy Does', 'Tequila Little Time', 'Freedom Was A Highway', 'Like A Lady', 'Worship You', 'Big, Big Plans', '865', 'Warning', 'Champagne Night', 'Give Heaven Some Hell', 'To Be Loved By You', 'Dangerous', 'Love Story (Taylors Version)', 'Home Sweet', 'One Mississippi', 'Livin The Dream', 'Am I The Only One', 'One Of Them Girls', 'Mr. Perfectly Fine (Taylors Version) (From The Vault)', 'Dicked Down In Dallas', 'One Beer', 'Aint Always The Cowboy', 'Love You Like I Used To', 'All Night', 'Take Me Home For Christmas', 'I Quit Drinking', 'Thats What Cowboys Do', 'Ride The Lightning', 'Under The Mistletoe', 'Favorite Time Of Year', 'Hallelujah', 'Truth About You', 'Lady Like']