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've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
A solution to last week’s challenge can be found here.
Sports franchises are not only valuable, but they often become integral to the identity of the cities they represent. These “big league” teams usually inhabit only the largest cities to ensure there are plenty of fans nearby to buy tickets and jerseys! The NFL, NBA, MLB, MLS, and NHL have different demographics and they don’t always inhabit the same cities.
For this week’s challenge, use the 5 datasets provided to find the cities that do not have a team from all 5 leagues.
Your output should list the teams and their leagues for those cities. Note that some of the city information is missing a state, but you can grab those missing values from another dataset that has the same city!
Pretty straight forward challenge, although I love the sports theme. -1 Union -1 Text to Column -1 Data Cleansing -1 Select -1 Summation (I used a comma separator vice the new line for astetics) -1 Filter -1 Sort Technically, the Bronx is a bureau of New York City, so really shouldn't be on the list..