Difference between revisions of "ISSS608 2017-18 T3 Assign DiyaNR visual insights"
Jump to navigation
Jump to search
(13 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
<!--MAIN HEADER --> | <!--MAIN HEADER --> | ||
{|style="background-color:#ffffff;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | {|style="background-color:#ffffff;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
− | | style="font-family:Trebuchet MS; font-size:100%; solid #ffffff; background:#F5B041 | + | | style="font-family:Trebuchet MS; font-size:100%; solid #ffffff; background:#F5B041; text-align:center;" width="20%" | |
; | ; | ||
[[ISSS608_2017-18_T3_Assign_DiyaNR_premise| <font color="#000000">PREMISE</font>]] | [[ISSS608_2017-18_T3_Assign_DiyaNR_premise| <font color="#000000">PREMISE</font>]] | ||
Line 12: | Line 12: | ||
[[ISSS608_2017-18_T3_Assign_ISSS608_2017-18_T3_Assign_DiyaNR_data| <font color="#000000">THE DATA</font>]] | [[ISSS608_2017-18_T3_Assign_ISSS608_2017-18_T3_Assign_DiyaNR_data| <font color="#000000">THE DATA</font>]] | ||
− | | style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#ffffff; text-align:center;" width="20%" | | + | | style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#ffffff; text-decoration:underline; text-align:center;" width="20%" | |
; | ; | ||
− | [[ISSS608_2017-18_T3_Assign_DiyaNR_visual_insights| <font color="#000000"> | + | [[ISSS608_2017-18_T3_Assign_DiyaNR_visual_insights| <font color="#000000">ANALYSIS</font>]] |
| style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | | style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | ||
; | ; | ||
− | [[ISSS608_2017-18_T3_Assign_DiyaNR_conclusion| <font color="#000000"> | + | [[ISSS608_2017-18_T3_Assign_DiyaNR_conclusion| <font color="#000000">OBSERVATIONS</font>]] |
| style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | | style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | ||
Line 26: | Line 26: | ||
| | | | ||
|} | |} | ||
+ | <br> | ||
+ | The analysis was done with the joint dataset consisting of 106 chemicals sampled across 10 locations. | ||
+ | The dataset covers 19 years from 1998 to 2016. The analysis was done as follows, | ||
+ | |||
+ | <div style=" text-align:left"> | ||
+ | <font size = 3; color="#000000"><span style="font-family:Trebuchet MS; font-weight:bold;"><h2>Initial Analysis</h2></span></font> | ||
+ | </div> | ||
+ | On inspection it can be observed that the chemicals have not been sampled consistently.There are chemicals which have been sampled across all years and those which have been sampled across some years.Due to this the chemicals can be grouped as follows:<br> | ||
+ | * <i>The following are the chemicals measured across all the years:</i><br> | ||
+ | [[File:allyears.JPG|200px|]]<br><br> | ||
+ | |||
+ | * <i>The following are the chemicals that have been sampled better over the later years (2002 onwards). There is inconsistency in the data.</i><br><br> | ||
+ | [[File:recent.JPG|200px|]]<br><br> | ||
+ | |||
+ | * The following plot shows the number of recordings, taken across the years in the 10 locations:<br><br> | ||
+ | [[File:diya_numberrecs_1.JPG|600px|centre|]]<br><br> | ||
+ | |||
+ | |||
+ | <div style=" text-align:left"> | ||
+ | <font size = 3; color="#000000"><span style="font-family:Trebuchet MS; font-weight:bold;"><h2>The Horizon Plot</h2></span></font> | ||
+ | </div> | ||
+ | * The following horizon plot was used to identify chemicals that stood out in terms of intensity.Through the horizon plot across the regions, a seasonal pattern can be observed in the water temperature with higher values during the months of June, July and August, indicative of summer months.<br><br> | ||
+ | [[File:Watertemperature.jpg|700px|centre|]]<br><br> | ||
+ | |||
+ | * There are upward trends seen in the water at Kohsoom, Busarakhan and Chai. On further plotting, it was also found that as the average water temperature increases, there is a decrease in the value of dissolved oxygen.<br><br> | ||
+ | [[File:diya_disoxytemp.JPG|500px|centre|]]<br><br> | ||
+ | *<i> The horizon plot can be accessed at the following Link:</i> [https://public.tableau.com/profile/diya.naresh#!/vizhome/Workbook_MC2/TrendofMeasurebyLocation] | ||
+ | <div style=" text-align:left"> | ||
+ | <font size = 3; color="#000000"><span style="font-family:Trebuchet MS; font-weight:bold;"><h2>Analysis by Chemicals</h2></span></font> | ||
+ | </div> | ||
+ | * Based on the observations made from the Horizon Plot, the following chemicals were found to have significant trends, as represented in the Control Charts:<br> | ||
+ | <br> | ||
+ | <table border = 1> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p><strong>Measure</strong></p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | <p><strong>Inference</strong></p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Anionic active surfactants</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya anionicsurfactants.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There is significant activity seen in Kohsoom in later years. | ||
+ | * Clear instance of Boonsri and Kohsoom showing an upward trend as compared to rest of the locations, there’s a peak in February 2014 and then July 2015. | ||
+ | * Data has been measured in all years except 1998. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>AOX</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya AOX.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There is significant activity seen in Kohsoom in later years. | ||
+ | * Post 2010, measurements only in Boonsri and Kohsoom. | ||
+ | * There is an upward trend in Kohsoom in January 2010 and April 2013. | ||
+ | * Limited data in 2013 and 2016, hard to compare nearby regions. | ||
+ | * Pattern observed in Kohsoom, later observed in Boonsri. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Chlorodinine</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya chlorodine.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * General Downward trend observed across locations. | ||
+ | * There is a sudden spike Kohsoom around June 2016. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Fecal coliforms</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya fcolliform.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There are spikes in Kohsoom in primary years | ||
+ | * There is an upward trend. | ||
+ | * Peak at Kohsoom in April 2011. | ||
+ | * Data has only been measured in early years. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Fecal streptococci</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya fstrep.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There are spikes in Kohsoom during the primary years. | ||
+ | * The spikes are seen around the same time as Fecal Coliforms | ||
+ | * Upward trend, peak in Kohsoom during April 2011. | ||
+ | * Data has only been measured in early years. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Mercury</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya mercury.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * Activity seen in Kohsoom, however not in later years. | ||
+ | * Spikes are seen at Kohsoom from March 2010. | ||
+ | * There is also a peak at Boonsri in July 2011. | ||
+ | * Data has been recorded in 1998 and then from 2005. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Methylosmoline</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya methylos.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There are peaks at Kohsoom and Tansanee. | ||
+ | * Somchair and Kohsoom show spikes in Aug 2016. | ||
+ | * There is an upward trend in both places, with higher rate of change in Somchair. | ||
+ | * Data has been measured from 2014 to 2016. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Nickel</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya nickel.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There are uptrends seen in Kohsoom in recent years. | ||
+ | * Post these years, the trend is seen to be continued in Busarakhan and Chai. | ||
+ | * There are clear spikes in Kohsoom in Feb 2011, May 2012 and September 2014. | ||
+ | * Data is present in all years except 2010. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Orthophosphate-phosphorus</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya orthophosphatephosphorous.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * Significant uptrends seen in Kohsoom and Spikes in Tansanee | ||
+ | * Kohsoom has an upward trend, with peaks in December 2013 and June 2014. | ||
+ | * Data has been sampled across all years. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Oxygen saturation</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya oxygensaturation.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * Seen but lower in Kohsoom in recent years. | ||
+ | * There is a dip in value in March 2013 with a downward trend. | ||
+ | * Data has been recorded from 2005 onwards. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Total coliforms</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya totalcoliforms.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There are spikes in Kohsoom in September 2011, September 2012 and June 2013. | ||
+ | * Major irregularities in the Data measurement observed (No recordings at Decha post 2011. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Total dissolved phosphorus</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya disolvedphospo.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There are seasonal spikes in Kohsoom, higher than all other locations | ||
+ | * There is peak in Kohsoom in August 2015. | ||
+ | * Data has been recorded in the last two years. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Total organic carbon</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya totalorcarbon.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * Uptrends seen in Kohsoom in recent years. | ||
+ | * There are peaks in December 2014, February 2015 and April 2015. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td width="137"> | ||
+ | <p>Total phosphorus</p> | ||
+ | </td> | ||
+ | <td width="471"> | ||
+ | [[File:Diya totalphospo.jpg|700px|]] | ||
+ | <br> | ||
+ | <br> | ||
+ | * There is an upward trend in Kohsoom with a peak in December 2013 which decreases in August 2015. | ||
+ | * The data has been recorded across all years. | ||
+ | </td> | ||
+ | </tr> | ||
+ | |||
+ | </table> | ||
+ | <p> </p> |
Latest revision as of 23:03, 10 July 2018
VAST MINI CHALLENGE 2
|
|
|
|
|
The analysis was done with the joint dataset consisting of 106 chemicals sampled across 10 locations.
The dataset covers 19 years from 1998 to 2016. The analysis was done as follows,
Initial Analysis
On inspection it can be observed that the chemicals have not been sampled consistently.There are chemicals which have been sampled across all years and those which have been sampled across some years.Due to this the chemicals can be grouped as follows:
- The following are the chemicals measured across all the years:
- The following are the chemicals that have been sampled better over the later years (2002 onwards). There is inconsistency in the data.
- The following plot shows the number of recordings, taken across the years in the 10 locations:
The Horizon Plot
- The following horizon plot was used to identify chemicals that stood out in terms of intensity.Through the horizon plot across the regions, a seasonal pattern can be observed in the water temperature with higher values during the months of June, July and August, indicative of summer months.
- There are upward trends seen in the water at Kohsoom, Busarakhan and Chai. On further plotting, it was also found that as the average water temperature increases, there is a decrease in the value of dissolved oxygen.
- The horizon plot can be accessed at the following Link: [1]
Analysis by Chemicals
- Based on the observations made from the Horizon Plot, the following chemicals were found to have significant trends, as represented in the Control Charts:
Measure |
Inference |
Anionic active surfactants |
|
AOX |
|
Chlorodinine |
|
Fecal coliforms |
|
Fecal streptococci |
|
Mercury |
|
Methylosmoline |
|
Nickel |
|
Orthophosphate-phosphorus |
|
Oxygen saturation |
|
Total coliforms |
|
Total dissolved phosphorus |
|
Total organic carbon |
|
Total phosphorus |
|