Difference between revisions of "ISSS608 2017-18 T3 Assign Sameer Panda"

From Visual Analytics and Applications
Jump to navigation Jump to search
 
(21 intermediate revisions by the same user not shown)
Line 32: Line 32:
 
| style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53; text-align:center;" width="100%" |   
 
| style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53; text-align:center;" width="100%" |   
 
;   
 
;   
−
<font size = 3; font color="#FFFFFF"><span style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53;"> Overview </span></font>  
+
<font size = 3.75; font color="#FFFFFF"><span style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53;"> Overview </span></font>  
 
|  
 
|  
 
|}
 
|}
Line 40: Line 40:
 
Last year, the Kasios Furniture Company was implicated in environmental damage to the Boonsong Lekagul Wildlife Preserve for both dumping toxic waste and polluting the air with chemicals from its manufacturing process. But Kasios is not taking these accusations lying down, and they deny any accusation of industrial waste dumping! Kasios’ spokespersons state that there isn’t any ground contamination near the remote ranger station that was suggested by last year’s mini-challenge 1 and 3 participants, and they have inspected that area and found it as pristine as the rest of the preserve.
 
Last year, the Kasios Furniture Company was implicated in environmental damage to the Boonsong Lekagul Wildlife Preserve for both dumping toxic waste and polluting the air with chemicals from its manufacturing process. But Kasios is not taking these accusations lying down, and they deny any accusation of industrial waste dumping! Kasios’ spokespersons state that there isn’t any ground contamination near the remote ranger station that was suggested by last year’s mini-challenge 1 and 3 participants, and they have inspected that area and found it as pristine as the rest of the preserve.
 
</span></font>
 
</span></font>
−
<br/>
+
<br/><br/>
−
==<font size="5">To Be a Visual Detective</font>==
+
{|style="background-color:#FDFEFE;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53; text-align:center;" width="100%" | 
 +
; 
 +
<font size = 3.75; font color="#FFFFFF"><span style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53;">Mini - Challenge 2</span></font>  
 +
|
 +
|}
 
<font size = 3.5><span style="font-family:Verdana;">  
 
<font size = 3.5><span style="font-family:Verdana;">  
−
* We need to investigate the hydrology data from across the Preserve.<br/>
+
Outraged ornithology professors from Mistford College journeyed out to look over the dumping site themselves and perform soil analyses. They returned to report that the site looked like there had been recent excavation and building activities going on. Boonsong Preserve rangers later confirmed that a new ranger station was being built at that site! Soil samples taken from the site were inconclusive in detecting Methylosmolene (the toxic manufacturing chemical in the suspected dumping) or any other contaminant, as new top soil had been trucked in.
−
<br/>
 
−
Time series graphs are important tools in various applications of statistics.  
 
−
<br/>
 
 
<br/></span></font>  
 
<br/></span></font>  
  
−
==<font size="5">Visualization</font>==
+
{|style="background-color:#FDFEFE;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
−
<font size = 4><span style="font-family:Verdana;">  
+
| style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53; text-align:center;" width="100%" | 
−
We use a lot visual metrics to formulate the trend of each indicator that has been chosen for the analysis. Below we have given some sample visuals of the time series trend taking for example, Afghanistan and Singapore countries as sample.</span></font>  
+
; 
 +
<font size = 3.75; font color="#FFFFFF"><span style="font-family:Verdana; font-size:100%; solid #1B338F; background:#0b3d53;">Shortcut to Solutions</span></font>  
 +
|
 +
|}
 
<br/>
 
<br/>
−
* <font size="4.25">'''Plot 1'''</font>: <font size = 4><span style="font-family:Verdana;"> In this visualization, we have plotted the time series trend of '''Adjusted Savings from Carbon dioxide damage in USD''' in Afghanistan. We can clearly see, from 1960-1965 there was no readings of this measure in the nation, after 1965 there has been a uniform trend over the years until 2006, after 2007, there was an uptrend of the savings value. It is evident that the value is the maximum in 2017, making the value for the year 2018 still higher.<br/><br/</span></font>
+
<font size = 3.5><span style="font-family:Verdana;"> Tableau Public [https://public.tableau.com/views/ISSS608_2018-19_T3_G2Assign_SAMEER_PANDA/TheStoryofWater?:embed=y&:display_count=yes| link]
−
<br/>
+
<br/></span></font>  
−
* <font size="4.25">'''Plot 2'''</font>: <font size = 4><span style="font-family:Verdana;"> In this visualization, we have plotted the time series trend of '''Education Expenditure for Afghanistan in % GNI'''. We can clearly see, from 1960-1965 there was no readings of this measure in the nation, after 1965 till 1970 there has been fluctuating expenditure on the education, but after 1970 its a perfect uniform trend over the years until 2010, At 2011, there had been a huge downfall in the trend and then it again rose and fell.<br/><br/></span></font>
+
{|style="background-color:#F44336;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="1"  |
−
<br/>
+
| style="font-family:Verdana; font-size:100%; solid #1B338F; background:#FDFEFE; text-align:center;" width="33.33%" | 
−
* <font size="4.25">'''Plot 3'''</font>: <font size = 4><span style="font-family:Verdana;"> In this visualization, we have plotted the time series trend of '''Net Official Development Assistance received''' from India. We can clearly see, from 1960-2017 there has been irregular trend, no any repetitive trends present and the overall trend over the years has increased, the value of 500 Million USD in 1960 has rose to 2.5 Billion USD in 2017.<br/><br/></span></font>
+
<div style="text-align:center; padding-top:25px;">  
−
<br/>
+
<font size = 4><span style="font-family:Verdana;">[[ISSS608_2018-19_T3_Assign_SAMEER PANDA_Visualizations| Q1]]</span></font>  
−
* <font size="4.25">'''Plot 4'''</font>: <font size = 4><span style="font-family:Verdana;"> In this visualization, we have plotted the time series trend of '''The Exports and Goods and services and Change in Inventories of Singapore in USD'''.The trend clearly shows that there has been a consistent rise in the vale of exports of goods from Singapore. The other graph tells us the changes has been so wide, regularly there has been eradication of goods stock in Singapore over the years.<br/><br/><br/><br/></span></font>
+
</div>
 +
| style="font-family:Verdana; font-size:100%; solid #1B338F; background:#FDFEFE; text-align:center;" width="33.33%" | 
 +
<div style="text-align:center; padding-top:25px;">  
 +
<font size = 4><span style="font-family:Verdana;">[[ISSS608_2018-19_T3_Assign_SAMEER PANDA_Visualizations| Q2]]</span></font>  
  
−
=<font size="5">Tools for Visualization and Data Cleaning</font>=
+
</div>
−
==<font size="4.75">Visualization</font>==
+
| style="font-family:Verdana; font-size:100%; solid #1B338F; background:#FDFEFE; text-align:center;" width="33.33%" | 
−
<font size = 4><span style="font-family:Verdana;">  
+
<div style="text-align:center; padding-top:25px;">  
−
* We use different tools for the visualization of the data. These include R Markdown, R Shiny, Tableau for now.<br/>
+
<font size = 4><span style="font-family:Verdana;">[[ISSS608_2018-19_T3_Assign_SAMEER PANDA_Visualizations| Q3]]</span></font>  
−
<br/>
+
</div>
−
* We use the R tool to model the entire project. In R Shiny, we use the '''xts''' package for data manipulation and beneficiary in plotting time series chart. We also use '''ggplot2''', '''plotly''', '''lubridate''' for plotting visuals in R and manipulating the date structure. Following it, we use '''dynlm/ardl''' a tool for time series regression analysis. We have also planned to forecast the future values of the indicators for a country using the R package '''forecast'''.<br/>
 
−
<br/>
 
−
* We also use the '''Tableau''' for the quick visualization of any data. The Tableau has more packages for making the visuals with much less effort. In Tableau there is a restriction to use a limited number of rows for visualization, hence we use only a certain specific rows for the visuals in Tableau.<br/></span></font>
 
−
==<font size="4.75">Data Cleaning</font>==
 
−
<font size = 4><span style="font-family:Verdana;">  
 
−
* We have a lot of data to be cleaned for the proper data set for the analysis. The data cleaning is done using the '''SAS-JMP''' tool, removing the necessary rows and recoding the missing values. Besides, we also use '''Microsoft Excel 365''' for small and quick cleaning.<br/>
 
−
<br/></span></font>
 

Latest revision as of 00:37, 9 July 2018

Oil-Spill.jpg  VAST Challenge 2018: Like a Duck to Water

Cover

Introduction

Data Preparation

Visual Solutions & Insights

Conclusions


Overview

According to Kasios, those funny colored satellite images from the Preserve only prove that it is a diverse, changing habitat and that the peculiar images Mitch identified are not conclusive evidence of any wrongdoing. They argue that the other industries should be taking as good care of the area as Kasios corporate and its volunteer squads do year round. To show their goodwill, Kasios reports that they recently donated staff time and money to refurbish ranger stations and campgrounds across the Preserve! Does Kasios have a case here? Perhaps some new visualization of river contaminants and analyses within the Preserve may help illustrate that the new Kasios story doesn't hold water (or does it?).

Last year, the Kasios Furniture Company was implicated in environmental damage to the Boonsong Lekagul Wildlife Preserve for both dumping toxic waste and polluting the air with chemicals from its manufacturing process. But Kasios is not taking these accusations lying down, and they deny any accusation of industrial waste dumping! Kasios’ spokespersons state that there isn’t any ground contamination near the remote ranger station that was suggested by last year’s mini-challenge 1 and 3 participants, and they have inspected that area and found it as pristine as the rest of the preserve.

Mini - Challenge 2

Outraged ornithology professors from Mistford College journeyed out to look over the dumping site themselves and perform soil analyses. They returned to report that the site looked like there had been recent excavation and building activities going on. Boonsong Preserve rangers later confirmed that a new ranger station was being built at that site! Soil samples taken from the site were inconclusive in detecting Methylosmolene (the toxic manufacturing chemical in the suspected dumping) or any other contaminant, as new top soil had been trucked in.

Shortcut to Solutions


Tableau Public link

Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=ISSS608_2017-18_T3_Assign_Sameer_Panda&oldid=9546’