What you tried to do. This is how it's done https://www.cuindependent.com/2016/03/12/top-ten-overrated-bands-of-all-time/

words and unique words by genrehttps://old.reddit.com/r/dataisbeautiful/comments/8j7eg9/total_unique_number_of_words_in_song_lyrics_by/

being first counts for a lot