Bay Wheels is a public bicycle sharing system in the San Francisco Bay Area, California. Motivate, in collaboration with the Metropolitan Transportation Commission and the Bay Area Air Quality Management District, operates it. Bay Wheels is the first regional and large-scale bicycle sharing scheme in California and the United States’ West Coast. In August of 2013, the Bay Area Bike Share program was launched. The Bay Wheels system had over 2,600 bicycles in 262 stations across San Francisco, the East Bay, and San Jose as of January 2018.
The dataset that I will be wrangling, analyzing and visualizing is the tweet archive of Twitter user @dog_rates, also known as WeRateDogs. WeRateDogs is a Twitter account that rates people’s dogs with a humorous comment about the dog. These ratings almost always have a denominator of 10. The numerators, though? Almost always greater than 10. 11/10, 12/10, 13/10, etc. Why? Because “they’re good dogs Brent.” WeRateDogs has over 4 million followers and has received international media coverage.
Data: The analysis is performed on the soccer database which comes from Kaggle. It contains data for soccer matches, players, and teams from several European countries from 2008 to 2016.
Code for retrieving teams data into a csv file from SQLite database:
WITH t1 as (SELECT c.name country_name,l.name league_name, m.id match_id, m.season, m.stage, m.date, m.home_team_goal, m.away_team_goal, t.team_long_name home_team, t.team_short_name home_team_abbr, ta.chanceCreationPassing, ta.chanceCreationPassingClass, ta.chanceCreationShooting, ta.chanceCreationShootingClass…