Import your data

data <- read_excel("../00_data/myData.xlsx")

Chapter 14

Tools

Detect matches

data$genre
##   [1] "Big Band/Jazz"                      
##   [2] "Rock n' Roll/Rhythm & Blues"        
##   [3] "Rock n' Roll/Rhythm & Blues"        
##   [4] "Big Band/Jazz"                      
##   [5] "NA"                                 
##   [6] "NA"                                 
##   [7] "Soul/Gospel/R&B"                    
##   [8] "Rock n' Roll/Rhythm & Blues"        
##   [9] "NA"                                 
##  [10] "Big Band/Jazz"                      
##  [11] "Big Band/Jazz"                      
##  [12] "NA"                                 
##  [13] "Big Band/Jazz"                      
##  [14] "Soul/Gospel/R&B"                    
##  [15] "Hip-Hop/Rap"                        
##  [16] "Blues/Blues Rock"                   
##  [17] "Country/Folk/Country Rock/Folk Rock"
##  [18] "Indie/Alternative Rock"             
##  [19] "NA"                                 
##  [20] "Soul/Gospel/R&B"                    
##  [21] "Soul/Gospel/R&B"                    
##  [22] "NA"                                 
##  [23] "Soul/Gospel/R&B"                    
##  [24] "Blues/Blues Rock"                   
##  [25] "Big Band/Jazz"                      
##  [26] "Soul/Gospel/R&B"                    
##  [27] "Soul/Gospel/R&B"                    
##  [28] "Blues/Blues Rock"                   
##  [29] "Punk/Post-Punk/New Wave/Power Pop"  
##  [30] "Blues/Blues Rock"                   
##  [31] "Electronic"                         
##  [32] "Soul/Gospel/R&B"                    
##  [33] "NA"                                 
##  [34] "Soul/Gospel/R&B"                    
##  [35] "Indie/Alternative Rock"             
##  [36] "Soul/Gospel/R&B"                    
##  [37] "Blues/Blues Rock"                   
##  [38] "Country/Folk/Country Rock/Folk Rock"
##  [39] "Funk/Disco"                         
##  [40] "NA"                                 
##  [41] "NA"                                 
##  [42] "Soul/Gospel/R&B"                    
##  [43] "Country/Folk/Country Rock/Folk Rock"
##  [44] "NA"                                 
##  [45] "Soul/Gospel/R&B"                    
##  [46] "NA"                                 
##  [47] "NA"                                 
##  [48] "Country/Folk/Country Rock/Folk Rock"
##  [49] "Soul/Gospel/R&B"                    
##  [50] "Soul/Gospel/R&B"                    
##  [51] "Funk/Disco"                         
##  [52] "Soul/Gospel/R&B"                    
##  [53] "NA"                                 
##  [54] "Country/Folk/Country Rock/Folk Rock"
##  [55] "Soul/Gospel/R&B"                    
##  [56] "Indie/Alternative Rock"             
##  [57] "Soul/Gospel/R&B"                    
##  [58] "Latin"                              
##  [59] "Big Band/Jazz"                      
##  [60] "Rock n' Roll/Rhythm & Blues"        
##  [61] "NA"                                 
##  [62] "Rock n' Roll/Rhythm & Blues"        
##  [63] "Blues/Blues Rock"                   
##  [64] "Country/Folk/Country Rock/Folk Rock"
##  [65] "Soul/Gospel/R&B"                    
##  [66] "Soul/Gospel/R&B"                    
##  [67] "NA"                                 
##  [68] "NA"                                 
##  [69] "Funk/Disco"                         
##  [70] "Indie/Alternative Rock"             
##  [71] "Punk/Post-Punk/New Wave/Power Pop"  
##  [72] "Big Band/Jazz"                      
##  [73] "Soul/Gospel/R&B"                    
##  [74] "Electronic"                         
##  [75] "Country/Folk/Country Rock/Folk Rock"
##  [76] "Country/Folk/Country Rock/Folk Rock"
##  [77] "NA"                                 
##  [78] "Indie/Alternative Rock"             
##  [79] "Big Band/Jazz"                      
##  [80] "Soul/Gospel/R&B"                    
##  [81] "Country/Folk/Country Rock/Folk Rock"
##  [82] "NA"                                 
##  [83] "NA"                                 
##  [84] "NA"                                 
##  [85] "Soul/Gospel/R&B"                    
##  [86] "NA"                                 
##  [87] "Latin"                              
##  [88] "Country/Folk/Country Rock/Folk Rock"
##  [89] "Electronic"                         
##  [90] "Big Band/Jazz"                      
##  [91] "Soul/Gospel/R&B"                    
##  [92] "Country/Folk/Country Rock/Folk Rock"
##  [93] "Latin"                              
##  [94] "NA"                                 
##  [95] "NA"                                 
##  [96] "Blues/Blues Rock"                   
##  [97] "NA"                                 
##  [98] "Blues/Blues Rock"                   
##  [99] "Blues/Blues Rock"                   
## [100] "Blues/Blues Rock"                   
## [101] "Blues/Blues Rock"                   
## [102] "Blues/Blues Rock"                   
## [103] "NA"                                 
## [104] "NA"                                 
## [105] "Hip-Hop/Rap"                        
## [106] "Country/Folk/Country Rock/Folk Rock"
## [107] "Hip-Hop/Rap"                        
## [108] "Blues/Blues Rock"                   
## [109] "Soul/Gospel/R&B"                    
## [110] "Blues/Blues Rock"                   
## [111] "Blues/Blues Rock"                   
## [112] "Country/Folk/Country Rock/Folk Rock"
## [113] "NA"                                 
## [114] "Blues/Blues Rock"                   
## [115] "Blues/Blues Rock"                   
## [116] "Soul/Gospel/R&B"                    
## [117] "NA"                                 
## [118] "Soul/Gospel/R&B"                    
## [119] "NA"                                 
## [120] "Blues/Blues Rock"                   
## [121] "Blues/Blues Rock"                   
## [122] "Blues/Blues Rock"                   
## [123] "Blues/Blues Rock"                   
## [124] "NA"                                 
## [125] "NA"                                 
## [126] "NA"                                 
## [127] "Country/Folk/Country Rock/Folk Rock"
## [128] "NA"                                 
## [129] "NA"                                 
## [130] "NA"                                 
## [131] "Hip-Hop/Rap"                        
## [132] "NA"                                 
## [133] "Blues/Blues Rock"                   
## [134] "Blues/Blues Rock"                   
## [135] "Blues/Blues Rock"                   
## [136] "Soul/Gospel/R&B"                    
## [137] "Country/Folk/Country Rock/Folk Rock"
## [138] "Blues/Blues Rock"                   
## [139] "NA"                                 
## [140] "Punk/Post-Punk/New Wave/Power Pop"  
## [141] "NA"                                 
## [142] "Soul/Gospel/R&B"                    
## [143] "NA"                                 
## [144] "Blues/Blues Rock"                   
## [145] "NA"                                 
## [146] "Country/Folk/Country Rock/Folk Rock"
## [147] "Country/Folk/Country Rock/Folk Rock"
## [148] "Blues/Blues Rock"                   
## [149] "NA"                                 
## [150] "NA"                                 
## [151] "Blues/Blues Rock"                   
## [152] "Hip-Hop/Rap"                        
## [153] "NA"                                 
## [154] "Soul/Gospel/R&B"                    
## [155] "NA"                                 
## [156] "Soul/Gospel/R&B"                    
## [157] "Blues/Blues Rock"                   
## [158] "Country/Folk/Country Rock/Folk Rock"
## [159] "NA"                                 
## [160] "Blues/Blues Rock"                   
## [161] "NA"                                 
## [162] "Soul/Gospel/R&B"                    
## [163] "Punk/Post-Punk/New Wave/Power Pop"  
## [164] "Blues/Blues Rock"                   
## [165] "Soul/Gospel/R&B"                    
## [166] "NA"                                 
## [167] "Hip-Hop/Rap"                        
## [168] "Blues/Blues Rock"                   
## [169] "Country/Folk/Country Rock/Folk Rock"
## [170] "Hard Rock/Metal"                    
## [171] "Hard Rock/Metal"                    
## [172] "Country/Folk/Country Rock/Folk Rock"
## [173] "NA"                                 
## [174] "Blues/Blues Rock"                   
## [175] "Rock n' Roll/Rhythm & Blues"        
## [176] "Punk/Post-Punk/New Wave/Power Pop"  
## [177] "NA"                                 
## [178] "NA"                                 
## [179] "Punk/Post-Punk/New Wave/Power Pop"  
## [180] "NA"                                 
## [181] "Hip-Hop/Rap"                        
## [182] "Blues/Blues Rock"                   
## [183] "Hip-Hop/Rap"                        
## [184] "Blues/Blues Rock"                   
## [185] "Blues/Blues Rock"                   
## [186] "Blues/Blues Rock"                   
## [187] "NA"                                 
## [188] "Soul/Gospel/R&B"                    
## [189] "Punk/Post-Punk/New Wave/Power Pop"  
## [190] "NA"                                 
## [191] "NA"                                 
## [192] "Big Band/Jazz"                      
## [193] "NA"                                 
## [194] "Punk/Post-Punk/New Wave/Power Pop"  
## [195] "NA"                                 
## [196] "Hard Rock/Metal"                    
## [197] "Country/Folk/Country Rock/Folk Rock"
## [198] "NA"                                 
## [199] "Country/Folk/Country Rock/Folk Rock"
## [200] "Country/Folk/Country Rock/Folk Rock"
## [201] "Country/Folk/Country Rock/Folk Rock"
## [202] "Blues/Blues Rock"                   
## [203] "Soul/Gospel/R&B"                    
## [204] "Blues/Blues Rock"                   
## [205] "Blues/Blues Rock"                   
## [206] "NA"                                 
## [207] "Hip-Hop/Rap"                        
## [208] "Hard Rock/Metal"                    
## [209] "Singer-Songwriter/Heartland Rock"   
## [210] "Blues/Blues Rock"                   
## [211] "Blues/Blues Rock"                   
## [212] "Funk/Disco"                         
## [213] "NA"                                 
## [214] "NA"                                 
## [215] "Punk/Post-Punk/New Wave/Power Pop"  
## [216] "Singer-Songwriter/Heartland Rock"   
## [217] "Singer-Songwriter/Heartland Rock"   
## [218] "NA"                                 
## [219] "Punk/Post-Punk/New Wave/Power Pop"  
## [220] "Funk/Disco"                         
## [221] "NA"                                 
## [222] "Country/Folk/Country Rock/Folk Rock"
## [223] "Singer-Songwriter/Heartland Rock"   
## [224] "Hip-Hop/Rap"                        
## [225] "Country/Folk/Country Rock/Folk Rock"
## [226] "Blues/Blues ROck"                   
## [227] "Soul/Gospel/R&B"                    
## [228] "Hard Rock/Metal"                    
## [229] "NA"                                 
## [230] "NA"                                 
## [231] "Blues/Blues Rock"                   
## [232] "Soul/Gospel/R&B"                    
## [233] "Blues/Blues Rock"                   
## [234] "Funk/Disco"                         
## [235] "Hip-Hop/Rap"                        
## [236] "Country/Folk/Country Rock/Folk Rock"
## [237] "NA"                                 
## [238] "Blues/Blues Rock"                   
## [239] "NA"                                 
## [240] "Hard Rock/Metal"                    
## [241] "Country/Folk/Country Rock/Folk Rock"
## [242] "NA"                                 
## [243] "Blues/Blues Rock"                   
## [244] "Hip-Hop/Rap"                        
## [245] "Blues/Blues Rock"                   
## [246] "Hip-Hop/Rap"                        
## [247] "Hard Rock/Metal"                    
## [248] "Funk/Disco"                         
## [249] "Blues/Blues Rock"                   
## [250] "Hip-Hop/Rap"                        
## [251] "NA"                                 
## [252] "Soul/Gospel/R&B"                    
## [253] "Punk/Post-Punk/New Wave/Power Pop"  
## [254] "NA"                                 
## [255] "Country/Folk/Country Rock/Folk Rock"
## [256] "NA"                                 
## [257] "Indie/Alternative Rock"             
## [258] "Hip-Hop/Rap"                        
## [259] "Soul/Gospel/R&B"                    
## [260] "NA"                                 
## [261] "NA"                                 
## [262] "NA"                                 
## [263] "Reggae"                             
## [264] "NA"                                 
## [265] "Hip-Hop/Rap"                        
## [266] "Country/Folk/Country Rock/Folk Rock"
## [267] "Singer-Songwriter/Heartland Rock"   
## [268] "NA"                                 
## [269] "Soul/Gospel/R&B"                    
## [270] "Electronic"                         
## [271] "Soul/Gospel/R&B"                    
## [272] "NA"                                 
## [273] "NA"                                 
## [274] "Singer-Songwriter/Heartland Rock"   
## [275] "NA"                                 
## [276] "Hip-Hop/Rap"                        
## [277] "Hip-Hop/Rap"                        
## [278] "Punk/Post-Punk/New Wave/Power Pop"  
## [279] "NA"                                 
## [280] "Soul/Gospel/R&B"                    
## [281] "Blues/Blues Rock"                   
## [282] "NA"                                 
## [283] "Big Band/Jazz"                      
## [284] "NA"                                 
## [285] "Hip-Hop/Rap"                        
## [286] "Punk/Post-Punk/New Wave/Power Pop"  
## [287] "NA"                                 
## [288] "Funk/Disco"                         
## [289] "Indie/Alternative Rock"             
## [290] "NA"                                 
## [291] "Singer-Songwriter/Heartland Rock"   
## [292] "Hard Rock/Metal"                    
## [293] "Hip-Hop/Rap"                        
## [294] "Punk/Post-Punk/New Wave/Power Pop"  
## [295] "Reggae"                             
## [296] "Soul/Gospel/R&B"                    
## [297] "Singer-Songwriter/Heartland Rock"   
## [298] "Punk/Post-Punk/New Wave/Power Pop"  
## [299] "Country/Folk/Country Rock/Folk Rock"
## [300] "Hip-Hop/Rap"                        
## [301] "NA"                                 
## [302] "Soul/Gospel/R&B"                    
## [303] "Country/Folk/Country Rock/Folk Rock"
## [304] "Soul/Gospel/R&B"                    
## [305] "Punk/Post-Punk/New Wave/Power Pop"  
## [306] "NA"                                 
## [307] "NA"                                 
## [308] "Hip-Hop/Rap"                        
## [309] "Reggae"                             
## [310] "NA"                                 
## [311] "Electronic"                         
## [312] "NA"                                 
## [313] "Singer-Songwriter/Heartland Rock"   
## [314] "NA"                                 
## [315] "NA"                                 
## [316] "Blues/Blues Rock"                   
## [317] "Reggae"                             
## [318] "Soul/Gospel/R&B"                    
## [319] "Funk/Disco"                         
## [320] "NA"                                 
## [321] "NA"                                 
## [322] "Soul/Gospel/R&B"                    
## [323] "NA"                                 
## [324] "Singer-Songwriter/Heartland Rock"   
## [325] "NA"                                 
## [326] "Singer-Songwriter/Heartland Rock"   
## [327] "Indie/Alternative Rock"             
## [328] "Funk/Disco"                         
## [329] "Reggae"                             
## [330] "Soul/Gospel/R&B"                    
## [331] "NA"                                 
## [332] "NA"                                 
## [333] "NA"                                 
## [334] "Indie/Alternative Rock"             
## [335] "NA"                                 
## [336] "Punk/Post-Punk/New Wave/Power Pop"  
## [337] "NA"                                 
## [338] "Soul/Gospel/R&B"                    
## [339] "Blues/Blues Rock"                   
## [340] "Country/Folk/Country Rock/Folk Rock"
## [341] "NA"                                 
## [342] "Punk/Post-Punk/New Wave/Power Pop"  
## [343] "NA"                                 
## [344] "Hip-Hop/Rap"                        
## [345] "Country/Folk/Country Rock/Folk Rock"
## [346] "Singer-Songwriter/Heartland Rock"   
## [347] "NA"                                 
## [348] "Indie/Alternative Rock"             
## [349] "Hip-Hop/Rap"                        
## [350] "Hard Rock/Metal"                    
## [351] "Country/Folk/Country Rock/Folk Rock"
## [352] "NA"                                 
## [353] "NA"                                 
## [354] "Hard Rock/Metal"                    
## [355] "Country/Folk/Country Rock/Folk Rock"
## [356] "NA"                                 
## [357] "Funk/Disco"                         
## [358] "Funk/Disco"                         
## [359] "Soul/Gospel/R&B"                    
## [360] "Punk/Post-Punk/New Wave/Power Pop"  
## [361] "Funk/Disco"                         
## [362] "Singer-Songwriter/Heartland Rock"   
## [363] "Hip-Hop/Rap"                        
## [364] "Hard Rock/Metal"                    
## [365] "Hip-Hop/Rap"                        
## [366] "Punk/Post-Punk/New Wave/Power Pop"  
## [367] "Hip-Hop/Rap"                        
## [368] "Hip-Hop/Rap"                        
## [369] "Singer-Songwriter/Heartland Rock"   
## [370] "Soul/Gospel/R&B"                    
## [371] "Soul/Gospel/R&B"                    
## [372] "Punk/Post-Punk/New Wave/Power Pop"  
## [373] "Indie/Alternative Rock"             
## [374] "NA"                                 
## [375] "Hard Rock/Metal"                    
## [376] "Big Band/Jazz"                      
## [377] "Rock n' Roll/Rhythm & Blues"        
## [378] "Indie/Alternative Rock"             
## [379] "Country/Folk/Country Rock/Folk Rock"
## [380] "NA"                                 
## [381] "Hard Rock/Metal"                    
## [382] "Hip-Hop/Rap"                        
## [383] "Indie/Alternative Rock"             
## [384] "Soul/Gospel/R&B"                    
## [385] "Country/Folk/Country Rock/Folk Rock"
## [386] "NA"                                 
## [387] "Afrobeat"                           
## [388] "Hip-Hop/Rap"                        
## [389] "NA"                                 
## [390] "Hard Rock/Metal"                    
## [391] "NA"                                 
## [392] "NA"                                 
## [393] "Blues/Blues Rock"                   
## [394] "Hard Rock/Metal"                    
## [395] "NA"                                 
## [396] "Hip-Hop/Rap"                        
## [397] "Reggae"                             
## [398] "Punk/Post-Punk/New Wave/Power Pop"  
## [399] "Country/Folk/Country Rock/Folk Rock"
## [400] "Punk/Post-Punk/New Wave/Power Pop"  
## [401] "Punk/Post-Punk/New Wave/Power Pop"  
## [402] "Funk/Disco"                         
## [403] "Singer-Songwriter/Heartland Rock"   
## [404] "NA"                                 
## [405] "Electronic"                         
## [406] "Soul/Gospel/R&B"                    
## [407] "Punk/Post-Punk/New Wave/Power Pop"  
## [408] "Punk/Post-Punk/New Wave/Power Pop"  
## [409] "Soul/Gospel/R&B"                    
## [410] "Punk/Post-Punk/New Wave/Power Pop"  
## [411] "Electronic"                         
## [412] "Hip-Hop/Rap"                        
## [413] "Indie/Alternative Rock"             
## [414] "Indie/Alternative Rock"             
## [415] "Funk/Disco"                         
## [416] "NA"                                 
## [417] "NA"                                 
## [418] "NA"                                 
## [419] "Latin"                              
## [420] "Punk/Post-Punk/New Wave/Power Pop"  
## [421] "Indie/Alternative Rock"             
## [422] "Indie/Alternative Rock"             
## [423] "NA"                                 
## [424] "Blues/Blues Rock"                   
## [425] "NA"                                 
## [426] "Country/Folk/Country Rock/Folk Rock"
## [427] "Hip-Hop/Rap"                        
## [428] "Indie/Alternative Rock"             
## [429] "Punk/Post-Punk/New Wave/Power Pop"  
## [430] "Funk/Disco"                         
## [431] "Afrobeat"                           
## [432] "Singer-Songwriter/Heartland Rock"   
## [433] "Soul/Gospel/R&B"                    
## [434] "Punk/Post-Punk/New Wave/Power Pop"  
## [435] "Latin"                              
## [436] "Hip-Hop/Rap"                        
## [437] "Latin"                              
## [438] "Singer-Songwriter/Heartland Rock"   
## [439] "NA"                                 
## [440] "Punk/Post-Punk/New Wave/Power Pop"  
## [441] "Rock n' Roll/Rhythm & Blues"        
## [442] "Hip-Hop/Rap"                        
## [443] "Punk/Post-Punk/New Wave/Power Pop"  
## [444] "Blues/Blues Rock"                   
## [445] "Singer-Songwriter/Heartland Rock"   
## [446] "Hard Rock/Metal"                    
## [447] "Punk/Post-Punk/New Wave/Power Pop"  
## [448] "Indie/Alternative Rock"             
## [449] "Funk/Disco"                         
## [450] "Soul/Gospel/R&B"                    
## [451] "Blues/Blues Rock"                   
## [452] "Soul/Gospel/R&B"                    
## [453] "Big Band/Jazz"                      
## [454] "Singer-Songwriter/Heartland Rock"   
## [455] "Punk/Post-Punk/New Wave/Power Pop"  
## [456] "Punk/Post-Punk/New Wave/Power Pop"  
## [457] "Punk/Post-Punk/New Wave/Power Pop"  
## [458] "Punk/Post-Punk/New Wave/Power Pop"  
## [459] "Punk/Post-Punk/New Wave/Power Pop"  
## [460] "Funk/Disco"                         
## [461] "NA"                                 
## [462] "NA"                                 
## [463] "Punk/Post-Punk/New Wave/Power Pop"  
## [464] "Punk/Post-Punk/New Wave/Power Pop"  
## [465] "NA"                                 
## [466] "Hard Rock/Metal"                    
## [467] "Punk/Post-Punk/New Wave/Power Pop"  
## [468] "NA"                                 
## [469] "Punk/Post-Punk/New Wave/Power Pop"  
## [470] "Punk/Post-Punk/New Wave/Power Pop"  
## [471] "Punk/Post-Punk/New Wave/Power Pop"  
## [472] "NA"                                 
## [473] "Punk/Post-Punk/New Wave/Power Pop"  
## [474] "Punk/Post-Punk/New Wave/Power Pop"  
## [475] "NA"                                 
## [476] "Punk/Post-Punk/New Wave/Power Pop"  
## [477] "Hard Rock/Metal"                    
## [478] "Punk/Post-Punk/New Wave/Power Pop"  
## [479] "Punk/Post-Punk/New Wave/Power Pop"  
## [480] "Punk/Post-Punk/New Wave/Power Pop"  
## [481] "Punk/Post-Punk/New Wave/Power Pop"  
## [482] "NA"                                 
## [483] "Singer-Songwriter/Heartland Rock"   
## [484] "Punk/Post-Punk/New Wave/Power Pop"  
## [485] "Punk/Post-Punk/New Wave/Power Pop"  
## [486] "Punk/Post-Punk/New Wave/Power Pop"  
## [487] "Punk/Post-Punk/New Wave/Power Pop"  
## [488] "NA"                                 
## [489] "Punk/Post-Punk/New Wave/Power Pop"  
## [490] "Funk/Disco"                         
## [491] "NA"                                 
## [492] "Punk/Post-Punk/New Wave/Power Pop"  
## [493] "Punk/Post-Punk/New Wave/Power Pop"  
## [494] "Punk/Post-Punk/New Wave/Power Pop"  
## [495] "NA"                                 
## [496] "Punk/Post-Punk/New Wave/Power Pop"  
## [497] "Funk/Disco"                         
## [498] "Indie/Alternative Rock"             
## [499] "Blues/Blues Rock"                   
## [500] "NA"                                 
## [501] "Blues/Blues Rock"                   
## [502] "Punk/Post-Punk/New Wave/Power Pop"  
## [503] "Punk/Post-Punk/New Wave/Power Pop"  
## [504] "Punk/Post-Punk/New Wave/Power Pop"  
## [505] "Soul/Gospel/R&B"                    
## [506] "Rock n' Roll/Rhythm & Blues"        
## [507] "NA"                                 
## [508] "Country/Folk/Country Rock/Folk Rock"
## [509] "Punk/Post-Punk/New Wave/Power Pop"  
## [510] "Punk/Post-Punk/New Wave/Power Pop"  
## [511] "NA"                                 
## [512] "Punk/Post-Punk/New Wave/Power Pop"  
## [513] "Punk/Post-Punk/New Wave/Power Pop"  
## [514] "Punk/Post-Punk/New Wave/Power Pop"  
## [515] "Punk/Post-Punk/New Wave/Power Pop"  
## [516] "Hard Rock/Metal"                    
## [517] "Blues/Blues Rock"                   
## [518] "Punk/Post-Punk/New Wave/Power Pop"  
## [519] "Reggae"                             
## [520] "Country/Folk/Country Rock/Folk Rock"
## [521] "Singer-Songwriter/Heartland Rock"   
## [522] "Punk/Post-Punk/New Wave/Power Pop"  
## [523] "NA"                                 
## [524] "Hip-Hop/Rap"                        
## [525] "Blues/Blues Rock"                   
## [526] "Punk/Post-Punk/New Wave/Power Pop"  
## [527] "NA"                                 
## [528] "Punk/Post-Punk/New Wave/Power Pop"  
## [529] "Soul/Gospel/R&B"                    
## [530] "Soul/Gospel/R&B"                    
## [531] "NA"                                 
## [532] "Singer-Songwriter/Heartland Rock"   
## [533] "Punk/Post-Punk/New Wave/Power Pop"  
## [534] "Punk/Post-Punk/New Wave/Power Pop"  
## [535] "Indie/Alternative Rock"             
## [536] "Punk/Post-Punk/New Wave/Power Pop"  
## [537] "Hip-Hop/Rap"                        
## [538] "NA"                                 
## [539] "NA"                                 
## [540] "Hard Rock/Metal"                    
## [541] "Punk/Post-Punk/New Wave/Power Pop"  
## [542] "Hip-Hop/Rap"                        
## [543] "Hip-Hop/Rap"                        
## [544] "NA"                                 
## [545] "Funk/Disco"                         
## [546] "NA"                                 
## [547] "NA"                                 
## [548] "Hip-Hop/Rap"                        
## [549] "Hard Rock/Metal"                    
## [550] "Indie/Alternative Rock"             
## [551] "NA"                                 
## [552] "Soul/Gospel/R&B"                    
## [553] "Hip-Hop/Rap"                        
## [554] "Punk/Post-Punk/New Wave/Power Pop"  
## [555] "Punk/Post-Punk/New Wave/Power Pop"  
## [556] "Indie/Alternative Rock"             
## [557] "Hard Rock/Metal"                    
## [558] "Singer-Songwriter/Heartland Rock"   
## [559] "Hip-Hop/Rap"                        
## [560] "NA"                                 
## [561] "Hip-Hop/Rap"                        
## [562] "Hip-Hop/Rap"                        
## [563] "Hard Rock/Metal"                    
## [564] "Hip-Hop/Rap"                        
## [565] "Punk/Post-Punk/New Wave/Power Pop"  
## [566] "Indie/Alternative Rock"             
## [567] "NA"                                 
## [568] "Soul/Gospel/R&B"                    
## [569] "NA"                                 
## [570] "Country/Folk/Country Rock/Folk Rock"
## [571] "Hip-Hop/Rap"                        
## [572] "Punk/Post-Punk/New Wave/Power Pop"  
## [573] "Hip-Hop/Rap"                        
## [574] "Singer-Songwriter/Heartland Rock"   
## [575] "Indie/Alternative Rock"             
## [576] "NA"                                 
## [577] "NA"                                 
## [578] "Hip-Hop/Rap"                        
## [579] "Hard Rock/Metal"                    
## [580] "Soul/Gospel/R&B"                    
## [581] "Indie/Alternative Rock"             
## [582] "Hip-Hop/Rap"                        
## [583] "Funk/Disco"                         
## [584] "Indie/Alternative Rock"             
## [585] "Indie/Alternative Rock"             
## [586] "Indie/Alternative Rock"             
## [587] "Soul/Gospel/R&B"                    
## [588] "Hard Rock/Metal"                    
## [589] "Soul/Gospel/R&B"                    
## [590] "Blues/Blues Rock"                   
## [591] "NA"                                 
## [592] "Indie/Alternative Rock"             
## [593] "Electronic"                         
## [594] "Soul/Gospel/R&B"                    
## [595] "Hip-Hop/Rap"                        
## [596] "Indie/Alternative Rock"             
## [597] "Indie/Alternative Rock"             
## [598] "Hard Rock/Metal"                    
## [599] "Soul/Gospel/R&B"                    
## [600] "Soul/Gospel/R&B"                    
## [601] "Indie/Alternative Rock"             
## [602] "Indie/Alternative Rock"             
## [603] "NA"                                 
## [604] "Indie/Alternative Rock"             
## [605] "Rock n' Roll/Rhythm & Blues"        
## [606] "Indie/Alternative Rock"             
## [607] "Soul/Gospel/R&B"                    
## [608] "Soul/Gospel/R&B"                    
## [609] "Hip-Hop/Rap"                        
## [610] "Hip-Hop/Rap"                        
## [611] "Indie/Alternative Rock"             
## [612] "NA"                                 
## [613] "Indie/Alternative Rock"             
## [614] "NA"                                 
## [615] "Punk/Post-Punk/New Wave/Power Pop"  
## [616] "Indie/Alternative Rock"             
## [617] "Indie/Alternative Rock"             
## [618] "Country/Folk/Country Rock/Folk Rock"
## [619] "Indie/Alternative Rock"             
## [620] "Indie/Alternative Rock"             
## [621] "Electronic"                         
## [622] "NA"                                 
## [623] "Indie/Alternative Rock"             
## [624] "NA"                                 
## [625] "Indie/Alternative Rock"             
## [626] "Indie/Alternative Rock"             
## [627] "Indie/Alternative Rock"             
## [628] "Soul/Gospel/R&B"                    
## [629] "Punk/Post-Punk/New Wave/Power Pop"  
## [630] "Indie/Alternative Rock"             
## [631] "Hip-Hop/Rap"                        
## [632] "Indie/Alternative Rock"             
## [633] "Hip-Hop/Rap"                        
## [634] "Soul/Gospel/R&B"                    
## [635] "Indie/Alternative Rock"             
## [636] "Hip-Hop/Rap"                        
## [637] "Latin"                              
## [638] "Singer-Songwriter/Heartland Rock"   
## [639] "Country/Folk/Country Rock/Folk Rock"
## [640] "Hip-Hop/Rap"                        
## [641] "Country/Folk/Country Rock/Folk Rock"
## [642] "Electronic"                         
## [643] "Electronic"                         
## [644] "NA"                                 
## [645] "NA"                                 
## [646] "NA"                                 
## [647] "NA"                                 
## [648] "Indie/Alternative Rock"             
## [649] "Hip-Hop/Rap"                        
## [650] "NA"                                 
## [651] "Electronic"                         
## [652] "NA"                                 
## [653] "Hard Rock/Metal"                    
## [654] "Country/Folk/Country Rock/Folk Rock"
## [655] "Electronic"                         
## [656] "Indie/Alternative Rock"             
## [657] "Soul/Gospel/R&B"                    
## [658] "Hip-Hop/Rap"                        
## [659] "Hip-Hop/Rap"                        
## [660] "Indie/Alternative Rock"             
## [661] "Soul/Gospel/R&B"                    
## [662] "Hip-Hop/Rap"                        
## [663] "Indie/Alternative Rock"             
## [664] "Singer-Songwriter/Heartland Rock"   
## [665] "Blues/Blues Rock"                   
## [666] "NA"                                 
## [667] "Punk/Post-Punk/New Wave/Power Pop"  
## [668] "NA"                                 
## [669] "NA"                                 
## [670] "Country/Folk/Country Rock/Folk Rock"
## [671] "Blues/Blues Rock"                   
## [672] "NA"                                 
## [673] "Singer-Songwriter/Heartland Rock"   
## [674] "Singer-Songwriter/Heartland Rock"   
## [675] "Indie/Alternative Rock"             
## [676] "Country/Folk/Country Rock/Folk Rock"
## [677] "Indie/Alternative Rock"             
## [678] "Indie/Alternative Rock"             
## [679] "Electronic"                         
## [680] "Indie/Alternative Rock"             
## [681] "Indie/Alternative Rock"             
## [682] "Blues/Blues Rock"                   
## [683] "Indie/Alternative Rock"             
## [684] "Blues/Blues Rock"                   
## [685] "Hip-Hop/Rap"                        
## [686] "NA"                                 
## [687] "Indie/Alternative Rock"             
## [688] "Soul/Gospel/R&B"                    
## [689] "Blues/Blues Rock"                   
## [690] "Latin"                              
## [691] "NA"
str_detect(data$genre, "Electronic")
##   [1] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##  [13] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##  [25] FALSE FALSE FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE
##  [37] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##  [49] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##  [61] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##  [73] FALSE  TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##  [85] FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##  [97] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [109] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [121] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [133] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [145] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [157] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [169] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [181] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [193] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [205] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [217] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [229] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [241] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [253] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [265] FALSE FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [277] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [289] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [301] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE  TRUE FALSE
## [313] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [325] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [337] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [349] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [361] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [373] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [385] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [397] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE
## [409] FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [421] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [433] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [445] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [457] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [469] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [481] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [493] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [505] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [517] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [529] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [541] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [553] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [565] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [577] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [589] FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [601] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [613] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE
## [625] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [637] FALSE FALSE FALSE FALSE FALSE  TRUE  TRUE FALSE FALSE FALSE FALSE FALSE
## [649] FALSE FALSE  TRUE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE
## [661] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [673] FALSE FALSE FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE
## [685] FALSE FALSE FALSE FALSE FALSE FALSE FALSE
sum(str_detect(data$genre, "Electronic"))
## [1] 14
data %>%
    summarise(num_Electronic = sum(str_detect(genre, "Electronic")))
## # A tibble: 1 × 1
##   num_Electronic
##            <int>
## 1             14

Extract matches

data %>%
    mutate(col_Electonic = str_extract(genre, "Electronic")) %>%
    select(genre, col_Electonic) %>%
    filter(!is.na(col_Electonic))
## # A tibble: 14 × 2
##    genre      col_Electonic
##    <chr>      <chr>        
##  1 Electronic Electronic   
##  2 Electronic Electronic   
##  3 Electronic Electronic   
##  4 Electronic Electronic   
##  5 Electronic Electronic   
##  6 Electronic Electronic   
##  7 Electronic Electronic   
##  8 Electronic Electronic   
##  9 Electronic Electronic   
## 10 Electronic Electronic   
## 11 Electronic Electronic   
## 12 Electronic Electronic   
## 13 Electronic Electronic   
## 14 Electronic Electronic

Replacing matches

data %>%
    mutate(col_NA = str_replace(genre, "Electronic", "NA")) %>%
    select(genre, col_NA)
## # A tibble: 691 × 2
##    genre                       col_NA                     
##    <chr>                       <chr>                      
##  1 Big Band/Jazz               Big Band/Jazz              
##  2 Rock n' Roll/Rhythm & Blues Rock n' Roll/Rhythm & Blues
##  3 Rock n' Roll/Rhythm & Blues Rock n' Roll/Rhythm & Blues
##  4 Big Band/Jazz               Big Band/Jazz              
##  5 NA                          NA                         
##  6 NA                          NA                         
##  7 Soul/Gospel/R&B             Soul/Gospel/R&B            
##  8 Rock n' Roll/Rhythm & Blues Rock n' Roll/Rhythm & Blues
##  9 NA                          NA                         
## 10 Big Band/Jazz               Big Band/Jazz              
## # ℹ 681 more rows