Best Selling Cars in 2014

https://www.google.com/fusiontables/data?docid=1nQCcpLRRsesXRw9SnXVKGJQTQBgQ2JQ1ZHxsAYf-#card:id=2

Screen Shot 2015-03-14 at 6.08.51 PM
What gas prices? Full-size pickups make up the top three. Then again, a large chunk are used in commercial applications.

 

Screen Shot 2015-03-14 at 6.09.10 PM

Screen Shot 2015-03-14 at 6.09.37 PM

Screen Shot 2015-03-14 at 6.09.47 PM

Screen Shot 2015-03-14 at 6.13.53 PM
Most cars on this list originate from the United States or Japan. Only a few come from South Korea or Germany.  Doesn’t mean there aren’t any red hot Ferraris sold here.

 

Screen Shot 2015-03-14 at 6.14.25 PM

Screen Shot 2015-03-14 at 6.14.31 PM
A breakdown of sales by brand. Ford has the most sales on the list.

 

Screen Shot 2015-03-14 at 6.14.34 PM

Screen Shot 2015-03-14 at 6.14.41 PM

 

Sorry this post has so many photos, so I’ll make up to you all by posting this adorable husky.

Lauren Gao’s Google Fusion Tables: Where in the World did Nancy Drew Go?

Well, wrong game. However, for this week’s assignment, I put together 10 of the Nancy Drew adventure series games to practice using Google’s Fusion Tables. While ten games, each with different locations, are not enough to grasp how well-traveled Nancy Drew is, I collected information on where each game was located, what year the game was published, how many supporting characters there were, and what kind of mystery Nancy Drew had to solve. Most games were set in actual states or locations, but often the town or building in question was a fictionalized location. A trend that came up during my data visualizations was that the later the year, the more supporting characters the game was likely to have. Additionally, the type of mystery with the most supporting characters was “Robbery”, which was the mystery in the game “Secret of the Scarlet Hand”.

https://www.google.com/fusiontables/DataSource?docid=1T8kwjpf1RqWo8QU5uDq4abMY3MH-c-P2IIAx0Aei

Screenshot (36)Screenshot (37)

Screenshot (38)

Screenshot (39)

 

Screenshot (40)

Screenshot (42)

 

Google Fusion Tables: an easy way to create data visualizations

I have selected some of my favorite movies from different genres and nationalities. I was curious to figure out how much each one had cost to be produced. In the case of movie series, I have chosen the one that I like most: Harry Potter and the Half-Blood Prince; Star Wars Episode III: Revenge of the Sith; Back to the Future Part II; Hunger Games: Catching Fire. I also have chosen two Brazilian movies that I admire very much. As I expected, the Brazilian productions had spent very lower budgets than the Hollywood creations, and it is nice to verify this data through visualizations.

Chart-card
Default Card image.
pie-graph
My movies’ preferences per genre.
bar-grah-CORRECT
Comparison of movies’ budgets.
Location-studios-2
Location of the studios. It is interesting to observe that most of the continents host one of my favorite movies’ studios.
Network-graph
Genres such as Animation and Science Fiction share similar locations.

Link for google Fusion Tables:

https://www.google.com/fusiontables/DataSource?docid=156_b0bEG8Url9J8yqe3xm5m7bFQlQDOQgBEDECcv

Link for the Spreadsheet:

https://docs.google.com/spreadsheets/d/1PX_0hpj46zaOQBs3ZmVjtjPjk1kJD-1I0h_OpVHIAzc/edit#gid=0

Spring Must be Here: Baseball and Numbers, Together Again

My Fusion Tables Link and Google Sheets Link

Screen Shot 2015-03-12 at 8.58.46 PM
Pictures and facts for all ten New York starting pitchers.
Screen Shot 2015-03-12 at 8.59.51 PM
This heat map accentuates New England and the Dominican Republic; both areas are home to two NY pitchers. Masahiro Tanaka, a recent signee from Japan, is the only pitcher not from the Western Hemisphere.
Screen Shot 2015-03-12 at 9.29.37 PM
Although CC Sabathia stands alone with 14 years, the network of Harvey, Wheeler and Pineda can be seen together, each having 2 years pitched.
Screen Shot 2015-03-12 at 9.11.55 PM
Bartolo Colon and CC Sabathia represent more than half of the collective professional experience of the pitchers.
Screen Shot 2015-03-12 at 9.12.20 PM
Note the overall slope, as velocity decreases with age.
Screen Shot 2015-03-12 at 9.12.33 PM
The majority of the NY pitchers are under 30, and Bartolo Colon is timeless.



If you made it this far thinking about baseball and numbers, Congratulations! Let’s elect the pitcher with the “Best Hair”:

images
Jenrry Mejia
images-1
Jacob DeGrom