This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are posting this because we would love to learn how to handle the data cleansing with fewer REGEX statements. Or a completely different way to handle the data.
Lots of Learning opportunities for data preparation and blending.
1. A hyphen in the album name (same as other delimiter) 2. US Artist name included "The". But the UK artist name did not in "The". Ex. "The Beatles" and "BEATLES". 3. UK Artist name was all caps. US Artist name was in Title format 4. Some hidden spaces and delimiters were not easily/automatically found 5. Regex functionality is very powerful but still requires some effort. 6. It takes a little effort to properly word/phrase your search in community.
Interesting observations: Surprised that the below UK artists did not make the UK Ranking.
Led Zeppelin (four albums in the US), Elton John, Def Leppard, The Rolling Stones, Eric Clapton, AC/DC
There is a large difference between the ranking the artist achieved in the UK and the US.
We hope all of you enjoy and discover some other surprises.
We decided to investigate whether there is a correlation between economic freedom and happiness of a country. We also investigate some specifics of the happiness metrics seeking a more clear indicator of happiness. We also mapped the top 15 happiest countries to visualize whether the happiest countries are or are not in the same region.
Between Hulu, Netflix, Disney+, and Amazon Prime, which is the best streaming servicebased on several personal preferences?
What is the best streaming platform based on the following:
TV vs. movie preference
Chosen recognized actors/actresses
New content vs classic content
IMDB rating minimum
Family content requirement
Based on the preferences chosen above, the output would reflect the total content that fits your requirements and how well the average content fits your requirements. This analytic app will determine the best streaming service for you!
Spotify metadata provides a lot of information about their tracks describing different aspects of songs such as acousticness, liveness, and danceability, among others. We decided to answer the question of "What country has the "danciest" music?".