Programming Assignment 1 Submission

Data Visualization by University of Illinois at Urbana-Champaign

®γσ, Eng Lian Hu 白戸則道®

2016-04-30

1. Introduction

1.1 Assignment

Instructions

  1. Take the data from the GISTEMP1 GISS Surface Temperature Analysis (GISTEMP) provides the graphs and tables are updated around the middle of every month using current data files from NOAA GHCN v3 (meteorological stations), ERSST v4 (ocean areas), and SCAR (Antarctic stations), combined as described in our December 2010 publication (Hansen et al. 2010). These updated files incorporate reports for the previous month and also late reports and corrections for earlier months. site, specifically the data from “Table Data: Global and Hemispheric Monthly Means and Zonal Annual Means.” Alternatively you can use any data that you would like to explore instead.
  2. Parse the data to a suitable format for the tools that you are using – we have provided two files (in JS, TXT, and CSV formats) that contain the data used to make the visualizations here, which is a subset of the data on the GISTEMP site.
  3. Visualize the data in any meaningful way you wish, keeping in mind the requirements of the Programming Assignment 1 Rubric.
  4. Click below to download the .zip file for this programming assignment.

Programming Assignment 1 Data New.zip

If you’re interested, you can also download the original data by clicking below.

Programming Assignment Data - GISTEMP Original.zip

1.2 Preparing Environment

Loading packages.

## Loading the package 'BBmisc'
if(suppressMessages(!require('BBmisc'))) install.packages('BBmisc')
suppressMessages(library('BBmisc'))

pkgs <- c('plyr', 'dplyr', 'magrittr', 'tidyr', 'googleVis', 'htmltools', 'rCharts', 'DT', 'sparkline', 'lubridate')
suppressAll(lib(pkgs)) 
rm(pkgs)

Setup and setting adjustment.

2. Data

2.1 Collecting Data

The dataset is downloadable in zipped file via here.

Name Length Date
Programming Assignment 1 Data New/ 0.00 (rank: 07) 2015-07-28 11:08:00
Programming Assignment 1 Data New/ExcelFormattedGISTEMPData2CSV.csv 7282.00 (rank: 05) 2015-07-28 10:52:00
Programming Assignment 1 Data New/ExcelFormattedGISTEMPData2JS.js 49840.00 (rank: 02) 2015-07-28 10:57:00
Programming Assignment 1 Data New/ExcelFormattedGISTEMPData2TXT.txt 7282.00 (rank: 05) 2015-07-28 10:52:00
Programming Assignment 1 Data New/ExcelFormattedGISTEMPDataCSV.csv 9064.00 (rank: 03) 2015-07-28 11:08:00
Programming Assignment 1 Data New/ExcelFormattedGISTEMPDataJS.js 54827.00 (rank: 01) 2015-07-28 10:57:00
Programming Assignment 1 Data New/ExcelFormattedGISTEMPDataTXT.txt 9064.00 (rank: 03) 2015-07-28 10:54:00

table 2.1.1 : Summary of downloaded zipped file.

From above information, we can know the information of the zipped files, and now we try to list out the documents for this mile-stone report as well as the summary of files.

[1] “ExcelFormattedGISTEMPData2CSV.csv” “ExcelFormattedGISTEMPData2JS.js”
[3] “ExcelFormattedGISTEMPData2TXT.txt” “ExcelFormattedGISTEMPDataCSV.csv” [5] “ExcelFormattedGISTEMPDataJS.js” “ExcelFormattedGISTEMPDataTXT.txt”

size isdir mode mtime ctime atime uid gid uname grname
7282 FALSE 420 2016-04-30 04:41:44 2016-04-30 04:41:44 2016-04-30 04:41:44 1000 1000 ryoeng ryoeng
49840 FALSE 420 2016-04-30 04:41:44 2016-04-30 04:41:44 2016-04-30 04:41:44 1000 1000 ryoeng ryoeng
7282 FALSE 420 2016-04-30 04:41:44 2016-04-30 04:41:44 2016-04-30 04:41:44 1000 1000 ryoeng ryoeng
9064 FALSE 420 2016-04-30 04:41:44 2016-04-30 04:41:44 2016-04-30 04:41:44 1000 1000 ryoeng ryoeng
54827 FALSE 420 2016-04-30 04:41:44 2016-04-30 04:41:44 2016-04-30 04:41:44 1000 1000 ryoeng ryoeng
9064 FALSE 420 2016-04-30 04:41:44 2016-04-30 04:41:44 2016-04-30 04:41:44 1000 1000 ryoeng ryoeng

table 2.1.2 : Summary of files.

2.2 Read Data

Read data.

[[1]]
     Year       Jan       Feb       Mar       Apr       May       Jun 
"numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" 
      Jul       Aug       Sep       Oct       Nov       Dec       J.D 
"numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" 
      D.N       DJF       MAM       JJA       SON 
"numeric" "numeric" "numeric" "numeric" "numeric" 

[[2]]
     Year      Glob      NHem      SHem  X24N.90N  X24S.24N  X90S.24S 
"numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" 
 X64N.90N  X44N.64N  X24N.44N   EQU.24N  X24S.EQU  X44S.24S  X64S.44S 
"numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" 
 X90S.64S 
"numeric" 

3. Data Visulaization

3.1 Data Table

Now we look at our data set in table format.

3.1.1 Functional Table

The table has few functions which allow you to print, save etc.

table 3.1.1 : Climate Degree Celsius from Year 1880 to 2015.

table 3.1.2 : Global Temperature over the years.

3.1.2 stylish Table

The table display with theme.

table 3.2.1 : Climate Degree Celsius from Year 1880 to 2015.

table 3.2.2 : Global Temperature over the years.

3.2 Zooming Line Chart

The zooming graph allow you to :

Remarks : kindly refer to 5.3 Speech and Blooper2 The Programming Assignment 1 Submission inside my personal blog shows a completed version. if you unable see the interactive graphs.

graph 3.2.1 : Climate Degree Celsius from Year 1880 to 2015.

From the above graph, the X Axis indicates the year and Y Axis indicates the degree celsius.

graph 3.2.2 : Globe and the North and South Hemispheres through all the given years.

The resulting graph shows an increasing mean Global Temperature over the years.

3.3 Moving Trend Line Chart

The moving trend graph enable you to compare the value of all elements at once (at the same time point).

graph 3.3.1 : Climate Degree Celsius from Year 1880 to 2015.

From the above graph, the X Axis indicates the year and Y Axis indicates the degree celsius.

graph 3.3.2 : Global Temperature over the years.

The resulting graph shows an increasing mean Global Temperature over the years.

3.4 Option Line Chart

The option line chart only allow you to choose what element(s) to be display on the graph.

graph 3.4.1 : Climate Degree Celsius from Year 1880 to 2015.

From the above graph, the X Axis indicates the year and Y Axis indicates the degree celsius.

graph 3.4.2 : Global Temperature over the years.

The resulting graph shows an increasing mean Global Temperature over the years.

3.5 Google Line Chart

Google line chart allow you to see the value of element once you move your cursor to a particular time point. Besides, you can also select the chart type from the Edit option.


Climate Degree Celsius from Year 1880 to 2015JanFebMarApr1/51,9001,9251,9501,9752,000-100-50050100
YearJanFebMarAprMayJunJulAugSepOctNovDecJ.DD.NDJFMAMJJASON
1880-29-19-17-27-13-28133584811104039-19107
1881-8-132-2-3-27311346155235-138
188210102-19-17-24356537101115353849-11385
1883-32-41-17-23-24-1133410298101220-2227
1884-17-11-33-35-31-3725181411211819186-332315
1885-64-29-23-44-41-5019201171332242425-362611
1886-41-45-41-28-27-3972510141615231919-321913
1887-65-47-31-37-33-2092011191526252327-331216
1888-42-42-47-28-21-203423344403121424-32510
1889-191545-3-11311010112119339302313
1890-46-48-41-38-48-27202824122719272625-422221
1891-45-48-14-25-17-2112135122643151825-191214
1892-24-14-35-34-24-181710164311718154-311219
1893-67-50-23-32-34-2241594625211929-30107
1894-54-31-21-40-29-4323191451412232224-302412
1895-43-42-29-22-23-24871153131421-24933
1896-22-15-29-32-19-133137216353667-273824
1897-22-19-13-10-1327232732816328-5362
1898-7-33-56-34-36-21141613202512202011-421319
1899-17-39-35-21-20-26530123444168815-25650
1900-39-62-14-4-133223463634343913-53635
1901-28-46-5-17-9333816518546-5389
1902-18-2-28-26-29-3316201315252918177-281917
1903-27-5-22-39-41-43203228252830262514-342925
1904-63-54-45-50-50-4930312921618303231-483421
1905-37-58-24-36-33-3015136113611191925-31155
1906-29-32-14-2-20-201610169287131416-121217
1907-43-50-24-40-45-42262922123331282622-362822
1908-44-35-57-45-39-37253323263331293126-472926
1909-69-46-51-59-54-52292425232333313332-553223
1910-44-43-47-38-33-36232724223435293028-392427
1911-63-60-63-55-52-4728312614915303435-563318
1912-27-14-37-21-20-26283430282727262411-263028
1913-40-43-43-36-45-4525252320720252725-412717
19142-13-22-27-19-2114552711407730-23104
1915-19-1-98-1-14163103152392-126
1916-19-21-29-24-26-41231819163038251910-262421
1917-46-55-48-38-48-3912189211837282933-451916
1918-43-31-20-38-36-27101758417161929-31142
1919-17-20-25-18-18-261010831923131310-201211
1920-14-22-6-25-24-31222010162328171612-182015
1921-2-20-26-34-34-2961582758101411-32124
1922-31-40-12-20-33-311522181856181817-211914
1923-25-35-29-37-31-2218211716620141614-33173
1924-21-25-11-33-17-2616262021122718157-201918
1925-32-32-21-24-29-32189456644101521-251632
192622813-13-23-241038213519343544-8832
1927-26-19-37-31-24-2651031352024121114-311010
1928-2-10-27-28-28-40101711638912137-28186
1929-46-57-34-41-38-422421153433262325-38258
1930-28-23-9-24-24-1763823147365921-1961
1931-10-20-6-20-21-54240323424035384-16129
193214-17-19-8-22-29141643216138723-16167
1933-31-30-27-23-25-31101517122229201816-251517
1934-25-3-28-26-10-132387140365814-22332
1935-3712-13-34-25-2298930171110103-24108
1936-28-39-24-19-15-183133182916817-20320
1937-77-16-16-6-7215942364340111-131139
19383-265-7-173423563957141111823863
1939-12-11-19-12-7-831303817756022386-133544
1940-136121666384141724551774242116738
1941132361110441465148454640444894441
194229712141512461237724645384246135870
194312331511140594153555441444397245
1944423235272621435152504677495056304946
19451551125113715248464239404541164543
1946176012-2-1533381229117221663220
1947-8-475-6-221366674062228523110
19486-12-23-96-55385293811353936-93833
194910-16-1-7-10-255383517376353938-6731
1950-27-27-8-21-12-83510262499912-14412
1951-35-43-19-11-1-711685675414733220-10161
19521613-92-5-462797417610375245-45324
1953916112098468166603258777079136744
1954-27-10-12-18-20-15843334847423-16636
195512-21-35-22-20-7337662718226537-26116
1956-16-25-22-27-27-15319111362121413-2589
1957-13-6-6-271437457434714752413807561
19583723927-646353152514266705262135
19596920175356131323810525266144732
1960-213-36-17-9021405672349223554-20135
19617191015141127406234516637345134744
1962715115-651123122471152414934035
1963-318-15-5-103725147404842666466-104342
1964-6-11-24-30-26-9331519181221121034-27516
1965-9-17-12-20-14-10214243534249-153631
1966-16-14-14-937131241034323537-64030
1967-7-194-612-815427673510112134111
1968-22-1421-5-10-52311373253336523824
1969-11-1411819411543975445366525134737
1970102389-5-1272405641552645043563
1971-3-21-19-11-7-18523372932393525-12324
1972-26-173-1-14424756674149371807456
1973273125262616724866386634424652257574
1974-14-28-5-100-5214363036234377-54133
19758714617011141232681140123733
1976-1-6-21-9-23-1528351535773537-1865
1977172124263025434946605265454845275076
197881221147-2671166354944747082143574
197915-71812614424549495663444571124247
1980304229333518455248435651505361325145
1981554149322331495744405359555459355543
1982916-2915439814340466240445177541
1983534142303619405655425848535564364948
198431182910346404645416034434751244440
198522-517101817424642394247394360154340
1986303829262614394446404347464853274576
1987364617262636545357545463565455235652
1988574249444442496258554356585765465951
1989163536331715485854545057515153295251
1990404176544638535550576360605859585655
1991425035513954576061535856595863426354
199245424723322439421366052474961344661
1993373936272723444540477550484955304841
199431326402941475053576457545347325457
1995517845472944556453596255616068406259
1996274934362926496649456159575657335649
1997333751373854506064657270626058426166
1998618962647177687560586569696777657360
1999486733343337515859576163595870335758
2000265959594043526159515955595963536053
2001454758525954636665617668656162576562
2002747691596555646768627061696776716664
2003725557556348587370706774686369586668
2004587066624242446363667766656275575767
2005725969706466667073738073736872687073
2006577164494764587768687875706674536969
2007977070756959656969646964726980716865
2008273675535148636368667368646158606468
2009625453616467697471658171716769597171
2010737992877564647267698264757178856971
2011505164665359707865666867676567617164
2012454957697662597172717966696665676872
2013675765546165617373688372726770606972
2014745077788666608075747476767273817175
2015828890747680363936333941364081803934

graph 3.5.1 : Climate Degree Celsius from Year 1880 to 2015.

From the above graph, the X Axis indicates the year and Y Axis indicates the degree celsius.


Global Temperature over the yearsGlobNHemSHemX24N…1/41,9001,9251,9501,9752,000-400-2000200400
YearGlobNHemSHemX24N.90NX24S.24NX90S.24SX64N.90NX44N.64NX24N.44NEQU.24NX24S.EQUX44S.24SX64S.44SX90S.64S
1880-19-33-5-38-16-5-89-54-22-26-5-2-839
1881-10-18-2-27-2-5-54-40-14-52-6-337
1882-9-17-1-21-104-125-20-3-12-83842
1883-19-30-8-34-22-2-28-57-20-25-19-1037
1884-27-42-12-56-17-11-127-58-41-21-14-15-540
1885-31-41-21-61-17-20-119-70-43-11-23-27-738
1886-30-39-21-49-24-20-124-43-38-24-24-18-2128
1887-33-37-28-46-27-26-158-52-21-24-31-24-2921
1888-20-22-17-427-33-141-43-2278-30-3816
1889-11-16-6-254-17-82-13-21-311-16-1719
1890-36-40-33-44-39-26-127-41-30-35-43-16-404
1891-23-23-24-33-16-23-118-17-27-8-24-20-289
1892-26-30-21-29-30-16-119-30-12-32-29-4-345
1893-29-39-19-37-40-7-76-35-30-43-363-222
1894-30-37-23-26-38-22-121-17-9-53-23-16-32-12
1895-21-28-14-34-13-19-86-38-18-19-8-21-13-1
1896-14-20-8-333-18-113-34-12-28-15-223
1897-11-13-9-3016-28-73-31-191318-21-375
1898-28-28-29-28-29-29-121-2-21-28-29-27-308
1899-16-17-15-18-13-17-994-12-16-10-13-2313
1900-8-3-13-1215-34-50-3-81119-31-3812
1901-13-8-19-10-5-28-41-1-9-3-6-29-261
1902-26-29-23-47-5-33-145-40-26-3-8-27-426
1903-35-35-35-39-32-33-37-30-46-27-37-37-25-43
1904-44-45-42-46-46-38-23-53-47-45-48-36-38-108
1905-27-28-26-37-13-36-12-16-57-15-11-37-34-20
1906-21-20-23-19-22-24-294-32-22-21-23-22-49
1907-39-46-31-56-34-28-68-69-44-33-36-25-31-101
1908-42-45-39-46-47-33-39-50-45-45-49-31-3882
1909-47-48-46-47-53-40-72-49-40-50-55-38-41-32
1910-42-43-41-36-54-32-62-13-44-54-54-32-3243
1911-44-41-47-37-47-47-24-36-43-47-47-43-5331
1912-35-47-22-57-22-30-60-70-48-33-11-37-13-137
1913-33-42-25-40-31-31-51-27-46-45-16-29-31-75
1914-15-18-13-22-7-19-50-6-25-12-2-17-23-16
1915-10-9-11-161-18-50-6-132-1-10-23-182
1916-33-35-30-27-45-22-25-43-19-47-42-22-17-104
1917-39-52-26-40-61-9-64-39-36-70-51-17437
1918-24-32-17-32-27-14-108-13-23-32-22-8-234
1919-21-32-10-39-14-13-80-44-25-23-5-7-2244
1920-25-26-24-16-27-3013-8-29-40-14-20-44-69
1921-19-8-317-27-35524-4-30-25-25-49-52
1922-26-25-27-18-32-25-22-31-8-35-29-23-27-5
1923-22-18-27-7-30-2829-3-21-33-27-26-28-34
1924-26-15-38-7-25-4738-15-16-26-24-38-60-49
1925-19-7-303-22-36-427-11-22-22-24-55-59
1926-84-2163-385225-1815-32-46-39
1927-20-10-29-9-14-37-4-12-9-12-17-31-41-130
1928-20-7-33-3-14-4659-7-18-14-14-32-62-205
1929-35-30-40-33-27-481-50-33-26-29-41-57-97
1930-132-2910-12-384816-5-9-15-31-42-237
1931-95-2353-38488-1060-42-31-26
1932-16-3-307-17-382531-15-17-18-25-57-81
1933-28-24-31-21-29-33-29-38-8-29-29-22-46-94
1934-131-2721-27-287440-8-28-26-23-34-31
1935-19-8-290-22-33227-11-20-24-29-34-139
1936-14-3-26-1-14-272418-21-6-23-27-2826
1937-113-1621-6-18108822-14-21-1474
1938-214-1837-26-10123446-21-31-9-8-72
1939-37-1324-17-9513310-17-18-5-10-155
194081431019-7883-1019181-2116
1941131610-339-6-21-11744342-18-26
194210146141513601515148-5-69
19431421738091183316-45131136
19442628243922181035014113232-1-49
1945139161022345-1693514-4-143
1946-37-128-1-16-152205-7-18-1641
1947-35-1214-9-13100-156-9-9-16-1128
1948-90-1814-18-208362-22-14-19-16-83
1949-9-2-1612-18-1922177-22-13-15-13-152
1950-18-16-19-8-27-144-344-28-26-5-21-68
1951-75-187-6-2213121-13-20-21-48
195215-392-710-71803-90-21
1953822-6335-1481371565-10-12-93
1954-12-4-203-21-1458-20-1-14-28-16-4-69
1955-14-9-192-32-7-43-723-27-38-16-19130
1956-20-25-14-24-321-21-47-10-27-37-11059
195734327-1322-1168-8-939
1958616-51020-17-1518122614-9-7-68
1959311-4156-135017258-4-15-36
1960-38-1391-2035-6105-3-10-4-86
196158318-34-183717-7111-1112
1962314-927-4-13583414-4-56-9-85
1963615-31611-12-53213139-11-205
1964-20-20-21-24-14-26-67-22-11-14-13-30-9-44
1965-10-13-7-17-3-12-20-24-11-71-210-6
1966-50-10-128-16-67-16817-1-24-1715
1967-23-813-14-24326-6-11-16-7-727
1968-7-5-9-8-6-8-17-2-8-1-10-122-14
19696-214-263245-59-153529213-4
19703-39-10611-17-14-6669041
1971-9-15-3-6-269-60-10-30-2241125
19721-1820-351616-45-49-2262614255
19731510201217142026262820-129
1974-8-194-17-1917-29-11-18-23-1621-658
1975-1-5212-22122235-6-29-1413428
1976-11-21-2-26-112-4-33-28-14-7910-36
1977181224141625242271023233713
19787212-3915-80-31072016-5
197917826-32525-596924273238-24
198028163963046321231283537104
19813339275019351297792216293754
198213621-62714-277-824301830-27
19833126352444203267-6305820294
19841652731925397-12830162458
198512025-3112941-27-1418293814
1986191425112421724418302626-3
198734274176027-2613145663332118
198840374340384275492332453918105
19892929294216334067271022372534
19904451366138356083483639383228
19914241444639437459283444333499
199223123373028-1937-22041213342
19932420291334236323-829382635-13
199432362743322136464327372725-11
19954658347044231409533404932168
199635284226344579191331373531111
199748534254533478872652544338-4
19986373547972369192686381433221
1999425232732632478277193250163
200042513371283311075562233471034
200155644680454410481714148582049
200263715681614812696585567492987
200362725280644114394525968472359
200455674275573264926856585021-6
2005698455996545200116566169522076
2006648047965640173105675558541936
20076683491104748201129694450546117
2008546642883940144102613345561050
200965715974685112758676671611885
201071885598694819986747266662338
201160715093375821190573837682693
201263775097514418989734657602532
2013667656885854123103685758643067
20147591581066754185113767064762347

graph 3.5.2 : Global Temperature over the years.

The resulting graph shows an increasing mean Global Temperature over the years.

4. Conclusion

In the paper I’ve plot few line charts by calling rCharts3 rCharts is an R package to create, customize and publish interactive javascript visualizations from R using a familiar lattice style plotting interface. package.

5. Appendices

5.1 Documenting File Creation

It’s useful to record some information about how your file was created.

[1] “2016-04-30 04:41:56 EDT” setting value
version R version 3.2.3 (2015-12-10) system x86_64, linux-gnu
ui X11
language (EN)
collate en_US.UTF-8
tz America/New_York
date 2016-04-30
sysname release “Linux” “3.10.0-229.20.1.el7.x86_64” version nodename “#1 SMP Tue Nov 3 19:10:07 UTC 2015” “Scibrokes” machine login “x86_64” “unknown” user effective_user “ryoeng” “ryoeng”

5.2 Versions’ Log

5.3 Speech and Blooper

I faced below issue during preparation of this assignment.

5.4 References

X24N.90N