Preppin' Data

Due to the social distancing and isolation caused by Covid-19, all football games have been postponed across the majority of the world. Therefore to help fill the void, this week’s challenge is all about analysing football team line-ups and in-particular the Premier League games for Liverpool. We start with a nicely formatted spreadsheet that includes the following: Match Details - Including dates, teams, location and formation Match Day Squad - 18 players broken down into Starting XI & Substitutes Starting XI - the 11 players who started the game for Liverpool Substitutes - the 7 players who started as a substitute for Liverpool Substitution Information - Includes the Player On/Off and the Time From this we want to answer some questions about the playing time of each of the players. Requirements Input Data Update the headers for Match Details, Starting XI, Substitutes. Ideally this will be done without just renaming each individual header separately. Note, for su...

You can find our full solution workflow below and download it here ! Our full solution workflow. Learning Objectives: • Explore some other filtering methods. • Practice using splits and pivots. • Learn how do to multiple aggregation types on the same field. Filtering out shows with less than 10000 viewers Here is a filtering method you may now have come across yet: On the [Members] field, click the 3 dots, then click Filter, and then select Range of Values. This gives us 3 options: - Range - Minimum - Maximum This allows us to use a slider or text boxes to define the filter condition opposed to having to manually write a filter calculation. In the case of this challenge, selecting Minimum and entering in 10000 will filter out the low viewership shows as required. Splitting & Pivoting the genres so they can be aggregated In order to calculate the viewerships and rating for each genre we need to transition from having multiple genres in a single row to...

Due to the comparable commercial successes of both Chin & Beard Suds Co and Your Name (Kimi No Na Wa) we've decided to pull together funding in order to produce a Chin & Beard Suds Co anime to raise our profile even further and hitting that otaku market. We're aiming to release a short series: Endless Legend of the Soap Heroes ( Kono Sekken Wa Hidoi), and a follow up movie: Endless Legend of the Soap Heroes: The Legend's End (Kono Sekken Wa Hidoi:   Atsui Gomi No Kaori ) by the end of 2022. However we haven't been able to decide on what genres to theme our anime around. We'd like you to help us make this decision by using a bunch of data scrapped from MyAnimeList.net to figure out the most popular genres. We also want to find prime examples of these genres to rip-off copy trace-over   just straight up put our own watermark on  use for inspiration. A snippet of the input. Requirements Input the data . Consider only TV shows and Movies - ...