[Week 2_Homework] Exercise 1: Visualizing Time

HOMEWORK (week 2)

Find 3 Data Sources:

Add at least three data sources to the Data Sources Wiki that you might be interested in working with throughout the duration of this class. You can either add to the existing categories or start a new category. Please mark your name next to your datasets.

Gapminder  -> I’ve often used this program to see the world’s overall problem and objective information based on the data. 

National Nutrient Database 

Box Office Mojo  -> I want to figure out relations between box office hit movies and the social trends and issues’ timeline when the movies release.

Google Trends -> I’ll search for google trends’ data to find which movies were hit at that time based on social attention.

Google NGram 


 

Find 3 Time Series Charts:

Find three different examples of time series charts that we discussed in class and write a few sentences about each. What type of data do you have? Why do you think the author chose this way of visualizing? What do you dislike/like about each one?


Line Chart

INEQUALITY AND NEW YORK’S SUBWAY

Screen Shot 2015-09-16 at 12.14.57 AM

Explanation & Comment: New York City has a problem with income inequality. And it’s getting worse—the top of the spectrum is gaining and the bottom is losing. Along individual subway lines, earnings range from poverty to considerable wealth. The interactive infographic here charts these shifts, using data on median household income, from the U.S. Census Bureau, for census tracts with subway stations.

This interactive infographic here charts how median household income swings from station to station. I think this is a great example of interactive data visualization because the line graphs are visually simple, but it is self-explanatory by graphic and the readability of the chart is good. Also, when I click each subway line which are separated by its color, the line graphs are interactively changed, so I could easily figure out the topic and agenda of this visualized data.

http://projects.newyorker.com/story/subway/

A RELATED ARTICLE http://www.newyorker.com/news/news-desk/idea-of-the-week-inequality-and-new-yorks-subway


Scatterplot + Trendline

Explanation & Comment: As you can see from the thick blanket of points at the frontier of the scatter plot, much of its yearly acquisitions are of recent pieces — the art of our time. Still, the average acquired painting was painted about 30 years before it joined MoMA’s collection.  I love this data visualization because I’m a big fan of MoMA’s painting collections and the artists in this dataset. Actually, I did a visualization work that has a similar concept with this before by analyzing some masterpieces’ painting.

There are 956 paintings that are wider than they are tall and 1,079 that are taller than they are wide. There are 131 square paintings. Width is less constrained than height

http://fivethirtyeight.com/features/a-nerds-guide-to-the-2229-paintings-at-moma/

My Project:

This slideshow requires JavaScript.


Small Multiples

http://www.economist.com/blogs/graphicdetail/2015/09/daily-chart-9

Explanation & Comment: This data visualization shows how each country generally spend their money by using simple circle diagram in Small Multiples type chart. No wonder this data visualization shows that “Health” is a predominant concern in the U.S. and South Korea spends more money in “Education” area than other countries, but I doubt the alcohol and tobacco section of South Korea.


Find and clean a time series data set:

Find a set of time series data that interests you, download it, bring it into Excel and do any relevant cleaning/organizing that you would need to do to be ready to use this data in class next week.

Yearly Box Office

Total Grosses of all Movies Released in 2015 

Rank Movie Title (click to view) Studio
Total Gross /Theaters Opening / Theaters Open Close
1 Jurassic World Uni. $648,990,716 4,291 $208,806,270 4,274 6/12
2 Avengers: Age of Ultron BV $458,582,882 4,276 $191,271,109 4,276 5/1
3 Inside Out BV $351,643,444 4,158 $90,440,272 3,946 6/19
4 Furious 7 Uni. $351,032,910 4,022 $147,187,040 4,004 4/3
5 Minions Uni. $331,681,250 4,311 $115,718,405 4,301 7/10
6 Cinderella (2015) BV $201,148,159 3,848 $67,877,361 3,845 3/13
7 Mission: Impossible – Rogue Nation Par. $188,463,250 3,988 $55,520,089 3,956 7/31
8 Pitch Perfect 2 Uni. $183,785,415 3,660 $69,216,890 3,473 5/15 7/30
9 Home (2015) Fox $177,397,510 3,801 $52,107,731 3,708 3/27
10 Ant-Man BV $176,312,099 3,868 $57,225,526 3,856 7/17
11 Fifty Shades of Grey Uni. $166,167,230 3,655 $85,171,450 3,646 2/13
12 The SpongeBob Movie: Sponge Out of Water Par. $162,994,032 3,680 $55,365,012 3,641 2/6
13 Straight Outta Compton Uni. $155,897,995 3,142 $60,200,180 2,757 8/14
14 San Andreas WB $154,831,320 3,812 $54,588,173 3,777 5/29
15 Mad Max: Fury Road WB $153,506,278 3,722 $45,428,128 3,702 5/15
16 The Divergent Series: Insurgent LG/S $130,179,072 3,875 $52,263,680 3,875 3/20 7/9
17 Kingsman: The Secret Service Fox $128,261,724 3,282 $36,206,331 3,204 2/13 7/9
18 Spy Fox $110,654,743 3,715 $29,085,719 3,711 6/5
19 Trainwreck Uni. $108,783,085 3,171 $30,097,040 3,158 7/17
20 Tomorrowland BV $93,417,865 3,972 $33,028,165 3,972 5/22
21 Get Hard WB $90,411,453 3,212 $33,803,253 3,175 3/27 7/9
22 Terminator: Genisys Par. $89,740,328 3,783 $27,018,486 3,758 7/1
23 Taken 3 Fox $89,256,424 3,594 $39,201,657 3,594 1/9 5/14
24 Ted 2 Uni. $81,284,830 3,448 $33,507,870 3,442 6/26
25 Paddington W/Dim. $76,223,578 3,355 $18,966,676 3,303 1/16 6/18
26 Pixels Sony $75,408,562 3,723 $24,011,616 3,723 7/24
27 Paul Blart: Mall Cop 2 Sony $71,038,190 3,633 $23,762,435 3,633 4/17
28 Magic Mike XXL WB $65,992,794 3,376 $12,857,184 3,355 7/1
29 The Wedding Ringer SGem $64,460,211 3,003 $20,649,306 3,003 1/16 4/5
30 Vacation WB (NL) $57,811,925 3,430 $14,681,108 3,411 7/29
31 Fantastic Four Fox $55,409,219 4,004 $25,685,737 3,995 8/7
32 Focus (2015) WB $53,862,963 3,323 $18,685,137 3,323 2/27 5/7
33 Insidious Chapter 3 Focus $52,218,558 3,014 $22,692,741 3,002 6/5
34 Southpaw Wein. $51,870,635 2,772 $16,701,294 2,772 7/24
35 Poltergeist (2015) Fox $47,425,125 3,242 $22,620,386 3,240 5/22 8/6
36 Jupiter Ascending WB $47,387,723 3,181 $18,372,372 3,181 2/6 5/7
37 McFarland, USA BV $44,482,410 2,792 $11,020,798 2,755 2/20 7/9
38 The Man From U.N.C.L.E. WB $43,266,782 3,673 $13,421,036 3,638 8/14
39 The Age of Adaline LGF $42,629,776 3,070 $13,203,458 2,991 4/24 7/9
40 The Gift (2015) STX $42,470,790 2,503 $11,854,273 2,503 8/7
41 Max (2015) WB $42,367,725 2,870 $12,155,254 2,855 6/26
42 War Room TriS $40,341,726 1,647 $11,351,389 1,135 8/28
43 The Longest Ride Fox $37,446,117 3,371 $13,019,686 3,366 4/10 7/9
44 The Boy Next Door Uni. $35,423,380 2,615 $14,910,105 2,602 1/23 3/12
45 Hot Pursuit WB $34,580,201 3,037 $13,942,258 3,003 5/8 7/30
46 The DUFF LGF $34,030,343 2,622 $10,809,149 2,575 2/20 5/14
47 Woman in Gold Wein. $33,307,195 2,011 $2,091,551 258 4/1 8/13
48 The Second Best Exotic Marigold Hotel FoxS $33,078,266 2,022 $8,540,370 1,573 3/6 6/25
49 Unfriended Uni. $32,482,090 2,775 $15,845,115 2,739 4/17 5/28
50 Entourage WB $32,363,404 3,108 $10,283,250 3,108 6/3 8/13
51 Paper Towns Fox $31,822,614 3,031 $12,650,140 3,031 7/24
52 Chappie Sony $31,569,268 3,201 $13,346,782 3,201 3/6
53 The Perfect Guy SGem $27,578,967 2,221 $25,888,154 2,221 9/11
54 The Visit Uni. $27,038,785 3,069 $25,427,560 3,069 9/11
55 Sinister 2 Focus $26,591,808 2,799 $10,542,116 2,766 8/21
56 The Woman in Black 2: Angel of Death Rela. $26,501,323 2,602 $15,027,415 2,602 1/2 3/19
57 Run All Night WB $26,461,644 3,171 $11,012,305 3,171 3/13 5/7
58 Ricki and the Flash TriS $26,366,507 2,064 $6,610,961 1,603 8/7
59 The Lazarus Effect Rela. $25,801,047 2,666 $10,203,437 2,666 2/27 6/11
60 Ex Machina A24 $25,442,958 2,004 $237,264 4 4/10
61 No Escape Wein. $24,412,812 3,415 $8,111,264 3,355 8/26
62 The Gallows WB (NL) $22,759,664 2,720 $9,808,463 2,720 7/10
63 Project Almanac Par. $22,348,241 2,900 $8,310,252 2,893 1/30 3/26
64 Hitman: Agent 47 Fox $21,734,212 3,273 $8,326,530 3,261 8/21
65 Black or White Rela. $21,571,189 1,823 $6,213,362 1,823 1/30 5/14
66 Aloha Sony $21,067,116 2,815 $9,670,235 2,815 5/29 7/30
67 A Walk in the Woods BG $20,465,445 2,139 $8,246,267 1,960 9/2
68 Still Alice SPC $18,754,371 1,318 $197,000 12 1/16 5/21
69 Shaun the Sheep Movie LGF $18,682,066 2,360 $4,038,962 2,320 8/5
70 Dope ORF $17,483,493 2,002 $6,100,010 2,002 6/19
71 Mr. Holmes RAtt. $17,234,281 898 $2,434,908 361 7/17
72 Seventh Son Uni. $17,223,265 2,875 $7,217,640 2,875 2/6 3/19
73 Monkey Kingdom BV $16,432,322 2,012 $4,577,861 2,012 4/17 7/23
74 It Follows RTWC $14,674,076 1,655 $160,089 4 3/13
75 American Ultra LGF $14,163,502 2,778 $5,454,284 2,778 8/21
76 The Transporter Refueled EC $13,746,544 3,434 $7,355,622 3,434 9/4
77 Do You Believe? PFR $12,985,600 1,356 $3,591,282 1,320 3/20
78 Love & Mercy RAtt. $12,526,111 791 $2,122,177 481 6/5
79 Strange Magic BV $12,429,583 3,020 $5,504,441 3,020 1/23
80 Hot Tub Time Machine 2 Par. $12,314,651 2,901 $5,963,324 2,880 2/20 3/26
81 Self/Less Focus $12,279,691 2,353 $5,403,460 2,353 7/10 8/27
82 Far from the Madding Crowd FoxS $12,236,500 902 $164,985 10 5/1 8/13
83 The Gunman ORF $10,664,749 2,816 $5,028,702 2,816 3/20 4/30
84 Unfinished Business Fox $10,219,501 2,777 $4,772,613 2,777 3/6 4/16
85 Bajrangi Bhaijaan Eros $8,178,001 257 $2,621,282 257 7/17
86 Amy A24 $8,155,237 435 $222,500 6 7/3
87 Dragon Ball Z: Resurrection ‘F’ FUN $8,008,363 913 $1,817,937 183 8/4
88 Blackhat Uni. $7,889,395 2,568 $3,901,815 2,567 1/16 2/5
89 Mortdecai LGF $7,696,134 2,648 $4,200,586 2,648 1/23 2/19
90 While We’re Young A24 $7,587,485 762 $227,688 4 3/27
91 I’ll See You In My Dreams BST $7,449,681 290 $52,091 3 5/15
92 Un Gallo con Muchos Huevos PNT $6,916,143 616 $3,424,702 395 9/4
93 Me and Earl and the Dying Girl FoxS $6,758,416 870 $196,496 15 6/12
94 Baahubali: The Beginning BSC $6,738,000 236 $3,575,000 236 7/9
95 Little Boy ORF $6,485,961 1,045 $2,750,356 1,045 4/24 6/18
96 The Loft ORF $6,002,684 1,841 $2,747,342 1,841 1/30 2/26
97 Danny Collins BST $5,637,066 739 $72,459 5 3/20 6/4
98 True Story FoxS $4,719,695 856 $1,950,214 831 4/17 6/4
99 The Water Diviner WB $4,196,641 385 $1,220,335 320 4/24
100 Irrational Man SPC $3,875,769 925 $175,312 7 7/17
Summary of 451 Movies on Chart:
Totals: $6,926,991,743
Averages: $15,359,183

Link Source: http://www.boxofficemojo.com/yearly/chart/?yr=2015&p=.htm

Relevant Links ( Issues and events of the U.S in 2015) 

http://www.futuretimeline.net/21stcentury/2015.htm#.Vfj08J1Viko

http://www.infoplease.com/news/2015/current-events/

Comment: I would like to make a data visualization by utilizing this chart and figure out relations between box office hit movies and the social trends and issues timeline of U.S. in 2015. So, I want to know the social issues have an effect on the movies’ hit.

[Excel Data File] : Box_office_movie_rank_2015

Deliver:

Post a URL or .zip of your three visualizations and accompanying explanations (named: lastName_Ex1) and your cleaned data set to Exercise 1 on Canvas before the start of next class. Add your data sources to the Wiki with your name next to the ones you’ve added.

Advertisements

Author: Jiyeon Kang (Jenny)

MFA Student of Design and Technology at Parsons School of Design dreamealist@gmail.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s