now i will inport my data and input the first few rows
data_playlist <-read.csv("playlist - data_clean.csv")
head(data_playlist)
## genre artist title
## 1 Genre 1 - hiphop/rap Alesso When I'm Gone
## 2 Genre 1 - hiphop/rap Aliyah's Interlude It Girl
## 3 Genre 1 - hiphop/rap Big Sean Beware
## 4 Genre 1 - hiphop/rap Clipse Ma, I don't love her
## 5 Genre 1 - hiphop/rap Common Be
## 6 Genre 1 - hiphop/rap Drake Nice for what
summary of the data
arrange(data_playlist)
## genre artist
## 1 Genre 1 - hiphop/rap Alesso
## 2 Genre 1 - hiphop/rap Aliyah's Interlude
## 3 Genre 1 - hiphop/rap Big Sean
## 4 Genre 1 - hiphop/rap Clipse
## 5 Genre 1 - hiphop/rap Common
## 6 Genre 1 - hiphop/rap Drake
## 7 Genre 1 - hiphop/rap Isaiah Rashad
## 8 Genre 1 - hiphop/rap Jcole
## 9 Genre 1 - hiphop/rap Jcole
## 10 Genre 1 - hiphop/rap Jcole
## 11 Genre 1 - hiphop/rap Kanye West
## 12 Genre 1 - hiphop/rap Kanye West
## 13 Genre 1 - hiphop/rap Kanye west
## 14 Genre 1 - hiphop/rap Ken carson
## 15 Genre 1 - hiphop/rap Kendrick Lamar
## 16 Genre 1 - hiphop/rap Lakeyah
## 17 Genre 1 - hiphop/rap little simz
## 18 Genre 1 - hiphop/rap Mac Miller
## 19 Genre 1 - hiphop/rap Mac Miller
## 20 Genre 1 - hiphop/rap MF DOOM
## 21 Genre 1 - hiphop/rap Outkast
## 22 Genre 1 - hiphop/rap PnB Rock
## 23 Genre 1 - hiphop/rap Rod Wave
## 24 Genre 1 - hiphop/rap Russ
## 25 Genre 1 - hiphop/rap Stormzy
## 26 Genre 1 - hiphop/rap Yung Filly
## 27 Genre 2 - pop/kpop/Latin Alec Benjamin
## 28 Genre 2 - pop/kpop/Latin ariana grande
## 29 Genre 2 - pop/kpop/Latin ariana grande
## 30 Genre 2 - pop/kpop/Latin bad bunny
## 31 Genre 2 - pop/kpop/Latin Beyonce
## 32 Genre 2 - pop/kpop/Latin Franglish
## 33 Genre 2 - pop/kpop/Latin Frank Ocean
## 34 Genre 2 - pop/kpop/Latin J-Hope
## 35 Genre 2 - pop/kpop/Latin Jeremy Zucker
## 36 Genre 2 - pop/kpop/Latin Kali Uchis
## 37 Genre 2 - pop/kpop/Latin Lana Del Rey
## 38 Genre 2 - pop/kpop/Latin Lauv
## 39 Genre 2 - pop/kpop/Latin Natalia lafourcade
## 40 Genre 2 - pop/kpop/Latin olivia.R
## 41 Genre 2 - pop/kpop/Latin Pitbull
## 42 Genre 2 - pop/kpop/Latin Post Malone
## 43 Genre 2 - pop/kpop/Latin renee rap
## 44 Genre 2 - pop/kpop/Latin Rosalia and Rauw Alejandro
## 45 Genre 2 - pop/kpop/Latin shinee
## 46 Genre 2 - pop/kpop/Latin SOMA
## 47 Genre 2 - pop/kpop/Latin Taeyang
## 48 Genre 2 - pop/kpop/Latin Taylor Swift
## 49 Genre 3 - house/ska Beyonce
## 50 Genre 3 - house/ska KAYTRANADA
## 51 Genre 3 - house/ska KAYTRANDA
## 52 Genre 3 - house/ska Sublime
## 53 Genre 3 - house/ska Tobias Dray
## 54 Genre 4 - rnb/soul Amerie
## 55 Genre 4 - rnb/soul Beyonce
## 56 Genre 4 - rnb/soul Brent faiyaz
## 57 Genre 4 - rnb/soul Brent faiyaz
## 58 Genre 4 - rnb/soul Brent Faiyaz
## 59 Genre 4 - rnb/soul Childish Gambino
## 60 Genre 4 - rnb/soul Ciara
## 61 Genre 4 - rnb/soul Destinys child
## 62 Genre 4 - rnb/soul Drake
## 63 Genre 4 - rnb/soul Ella Mai
## 64 Genre 4 - rnb/soul Ella Mai
## 65 Genre 4 - rnb/soul Fantasia
## 66 Genre 4 - rnb/soul Fountains of Wayne
## 67 Genre 4 - rnb/soul Frank ocean
## 68 Genre 4 - rnb/soul Ghost town djs
## 69 Genre 4 - rnb/soul Giveon
## 70 Genre 4 - rnb/soul Jcole
## 71 Genre 4 - rnb/soul Jhene Aiko
## 72 Genre 4 - rnb/soul Khamari
## 73 Genre 4 - rnb/soul Kieth Sweat
## 74 Genre 4 - rnb/soul lauren hill
## 75 Genre 4 - rnb/soul Lauryn Hill
## 76 Genre 4 - rnb/soul Lauryn Hill
## 77 Genre 4 - rnb/soul Leon Bridges
## 78 Genre 4 - rnb/soul Loony
## 79 Genre 4 - rnb/soul Mariah the Scientist
## 80 Genre 4 - rnb/soul Marvin Gaye
## 81 Genre 4 - rnb/soul Maxwell
## 82 Genre 4 - rnb/soul Nelccia
## 83 Genre 4 - rnb/soul Nico Segal
## 84 Genre 4 - rnb/soul Queen Naija
## 85 Genre 4 - rnb/soul Sade
## 86 Genre 4 - rnb/soul Solange
## 87 Genre 4 - rnb/soul Sonder
## 88 Genre 4 - rnb/soul Soul for real
## 89 Genre 4 - rnb/soul Summer Walker
## 90 Genre 4 - rnb/soul SZA
## 91 Genre 4 - rnb/soul sza
## 92 Genre 4 - rnb/soul sza
## 93 Genre 4 - rnb/soul SZA
## 94 Genre 4 - rnb/soul Tayc
## 95 Genre 4 - rnb/soul Thee sacred souls
## 96 Genre 4 - rnb/soul Thee sacred souls
## 97 Genre 5 - alt/indie/folk Aidan Bissett
## 98 Genre 5 - alt/indie/folk AJR
## 99 Genre 5 - alt/indie/folk alkaline trio
## 100 Genre 5 - alt/indie/folk Cherry Glazerr
## 101 Genre 5 - alt/indie/folk Cherry Glazerr
## 102 Genre 5 - alt/indie/folk Cigarettes after sex
## 103 Genre 5 - alt/indie/folk Crumb
## 104 Genre 5 - alt/indie/folk Crumb
## 105 Genre 5 - alt/indie/folk Death Cab for Cutie
## 106 Genre 5 - alt/indie/folk Faye Webster
## 107 Genre 5 - alt/indie/folk Fleetwood Mac
## 108 Genre 5 - alt/indie/folk Fleetwood Mac
## 109 Genre 5 - alt/indie/folk Ginger Root
## 110 Genre 5 - alt/indie/folk Jeff Buckley
## 111 Genre 5 - alt/indie/folk Lake Street Dive
## 112 Genre 5 - alt/indie/folk Lana Del Rey
## 113 Genre 5 - alt/indie/folk laufey
## 114 Genre 5 - alt/indie/folk Mat Kerekes
## 115 Genre 5 - alt/indie/folk Men I Trust
## 116 Genre 5 - alt/indie/folk my bloody valentine
## 117 Genre 5 - alt/indie/folk Nirvana
## 118 Genre 5 - alt/indie/folk Nirvana
## 119 Genre 5 - alt/indie/folk Nirvana
## 120 Genre 5 - alt/indie/folk rilo kiley
## 121 Genre 5 - alt/indie/folk Sorry
## 122 Genre 5 - alt/indie/folk Taylor Swift
## 123 Genre 5 - alt/indie/folk Taylor Swift
## 124 Genre 5 - alt/indie/folk The Internet
## 125 Genre 5 - alt/indie/folk The Shins
## 126 Genre 5 - alt/indie/folk the strokes
## 127 Genre 5 - alt/indie/folk The Weather Machine
## 128 Genre 5 - alt/indie/folk Thundercat
## 129 Genre 5 - alt/indie/folk Video Age
## 130 Genre 5 - alt/indie/folk wilco
## 131 Genre 6 - country/rock Citizen
## 132 Genre 6 - country/rock Citizen
## 133 Genre 6 - country/rock Citizen
## 134 Genre 6 - country/rock Dolly Parton
## 135 Genre 6 - country/rock Dolly parton
## 136 Genre 6 - country/rock fleetwood mac
## 137 Genre 6 - country/rock Kacey Musgraves
## 138 Genre 6 - country/rock Luke Combs
## 139 Genre 6 - country/rock luke combs
## 140 Genre 6 - country/rock Nirvana
## 141 Genre 6 - country/rock Nirvana
## 142 Genre 6 - country/rock Queen
## 143 Genre 6 - country/rock talking heads
## 144 Genre 6 - country/rock U2
## title
## 1 When I'm Gone
## 2 It Girl
## 3 Beware
## 4 Ma, I don't love her
## 5 Be
## 6 Nice for what
## 7 Headshots
## 8 change
## 9 Crooked smile
## 10 Immortal
## 11 Everything I Am
## 12 Devil In A New Dress
## 13 Missed call
## 14 Murda musik
## 15 Money Trees
## 16 Worst thing
## 17 two worlds apart
## 18 Surf
## 19 ROS
## 20 Doomsday
## 21 Hey Ya
## 22 Selfish
## 23 Get Ready
## 24 Handsomer
## 25 Hide & Seek (FLO Remix)
## 26 Grey
## 27 Devil Doesn't Bargain
## 28 honeymoon avenue
## 29 everytime
## 30 Ojitos lindos
## 31 Break My Soul
## 32 Trop Parler
## 33 Nights
## 34 Safety Zone
## 35 Come thru
## 36 I Wish you Roses
## 37 Cinnamon Girl
## 38 I like me better
## 39 Hasta la raiz
## 40 pretty isnt pretty
## 41 Time of our lives
## 42 Goodbyes
## 43 tummy hurts
## 44 Beso
## 45 Replay
## 46 Monster Hunter
## 47 Wedding dress
## 48 The Man
## 49 My house
## 50 Vex Oh
## 51 BUS RIDE
## 52 Garden Grove
## 53 Sunsets
## 54 Can't Let Go
## 55 Summertime
## 56 Forever yours
## 57 Rehab
## 58 Missin Out
## 59 Redbone
## 60 Like a boy
## 61 Say my name
## 62 Look what You’ve done
## 63 Shot clock
## 64 Trip
## 65 When I see you
## 66 Halley's Waitress
## 67 pyramids
## 68 My boo
## 69 Still your best
## 70 In the morning
## 71 Stranger
## 72 Drifting
## 73 Get up on it
## 74 final hour
## 75 Tell Him
## 76 Doo Wop
## 77 River
## 78 Raw
## 79 From A Woman
## 80 Just to keep you satisfied
## 81 This woman’s work
## 82 Options (clean version)
## 83 Sunday Candy
## 84 Medicine
## 85 Keep Looking
## 86 Don't Touch My Hair
## 87 What You Heard
## 88 Candy rain
## 89 To summer, from cole
## 90 Kill Bill
## 91 snooze
## 92 normal girl
## 93 Good Days
## 94 Le Miel
## 95 For now
## 96 Future lover
## 97 Tripping Over Air
## 98 Burn The House Down
## 99 Scars
## 100 Soft Drink
## 101 Soft like a flower
## 102 Sunsetz
## 103 Plants
## 104 Dust Bunny
## 105 No Sunlight
## 106 A Dream With A Baseball Player
## 107 Landslide
## 108 Everywhere
## 109 Loretta
## 110 Love you should have come over
## 111 Hypotheticals
## 112 Million Dollar Man
## 113 like the movies
## 114 Shoes
## 115 Show Me How
## 116 To Here Knows When
## 117 Come As You Are
## 118 About A Girl
## 119 All Apologies
## 120 august
## 121 Showgirl
## 122 Peace
## 123 Ivy
## 124 Under Control
## 125 New Slang
## 126 call it fate, call it karma
## 127 Back O'er Oregon
## 128 Them Changes
## 129 Comic Relief
## 130 heavy metal drummer
## 131 Hyper Trophy
## 132 Jet
## 133 World
## 134 9 to 5
## 135 Jolene
## 136 everywhere
## 137 Die Fun
## 138 Hurricane
## 139 one number away
## 140 Man who sold the world mtv unplugged
## 141 Come as you are
## 142 Cool Cat
## 143 this must be the place
## 144 Every Breaking Wave
summary(data_playlist)
## genre artist title
## Length:144 Length:144 Length:144
## Class :character Class :character Class :character
## Mode :character Mode :character Mode :character
sample_n(data_playlist,6)
## genre artist title
## 1 Genre 2 - pop/kpop/Latin renee rap tummy hurts
## 2 Genre 2 - pop/kpop/Latin J-Hope Safety Zone
## 3 Genre 4 - rnb/soul Marvin Gaye Just to keep you satisfied
## 4 Genre 6 - country/rock Nirvana Man who sold the world mtv unplugged
## 5 Genre 4 - rnb/soul Maxwell This woman’s work
## 6 Genre 4 - rnb/soul sza snooze
data_playlist%>% count(genre)
## genre n
## 1 Genre 1 - hiphop/rap 26
## 2 Genre 2 - pop/kpop/Latin 22
## 3 Genre 3 - house/ska 5
## 4 Genre 4 - rnb/soul 43
## 5 Genre 5 - alt/indie/folk 34
## 6 Genre 6 - country/rock 14
this graph shows the number of songs in each genre
sample_n(data_playlist, 10)
## genre artist title
## 1 Genre 4 - rnb/soul Brent faiyaz Forever yours
## 2 Genre 4 - rnb/soul Frank ocean pyramids
## 3 Genre 4 - rnb/soul Thee sacred souls For now
## 4 Genre 1 - hiphop/rap MF DOOM Doomsday
## 5 Genre 5 - alt/indie/folk Mat Kerekes Shoes
## 6 Genre 5 - alt/indie/folk my bloody valentine To Here Knows When
## 7 Genre 2 - pop/kpop/Latin Franglish Trop Parler
## 8 Genre 2 - pop/kpop/Latin Alec Benjamin Devil Doesn't Bargain
## 9 Genre 4 - rnb/soul Kieth Sweat Get up on it
## 10 Genre 6 - country/rock Dolly Parton 9 to 5
1/10 of these songs are on my playlist