Difference between revisions of "ISSS608 2017-18 T3 Assign ISSS608 2017-18 T3 Assign DiyaNR data"
Jump to navigation
Jump to search
(Created page with "<div style="background:#F5B041; border:#002060; padding-left:15px; text-align:center;"> <font size = 5; color="#000000"><span style="font-family:Trebuchet MS;">VAST MINI CHAL...") |
|||
| (6 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>]] | ||
| − | | 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_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>]] | ||
| Line 14: | Line 14: | ||
| 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_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 31: | Line 31: | ||
The following are the datasets and their corresponding data fields present<br><br> | The following are the datasets and their corresponding data fields present<br><br> | ||
1. Boonsong Kekagul waterways readings<br> | 1. Boonsong Kekagul waterways readings<br> | ||
| − | [[File:table1_readings.JPG|400px|]] | + | [[File:table1_readings.JPG|400px|border="4"]] |
<br> | <br> | ||
<br> | <br> | ||
| Line 58: | Line 58: | ||
<br> | <br> | ||
<i>The Measure or Chemical "Macrozoobenthos" did not have a unit present.</i> | <i>The Measure or Chemical "Macrozoobenthos" did not have a unit present.</i> | ||
| + | <br> | ||
| + | <div style=" text-align:left"> | ||
| + | <font size = 3; color="#000000"><span style="font-family:Trebuchet MS; font-weight:bold;"><h2>Locating the co-ordinates</h2></span></font> | ||
| + | </div> | ||
| + | The co-ordinates of the various places were located using Tableau. The waterways image provided was loaded into tableau. The x and y co-ordinates were assigned to each of the 10 places present on the map.<br> | ||
| + | [[File:diya_locationannotations.JPG|400px|Centre|]]<br> | ||
| + | <br> | ||
| + | <br> | ||
| + | * There are 106 chemicals present in the dataset. These chemicals are measured across the following 10 locations:<br> | ||
| + | [[File:diya_locationstab.JPG|400px|Left|]]<br> | ||
Latest revision as of 04:47, 10 July 2018
VAST MINI CHALLENGE 2
|
|
|
|
|
|
The Datasets
The following are the datasets and their corresponding data fields present
1. Boonsong Kekagul waterways readings
2. Chemical units of measure
Data Preparation
SAS JMP was used for preparing the data.
- The two datasets 'Boonsong Kekagul waterways readings' and 'Chemical units of measure' were joined using JMP based on the common 'Measure' Column present in both.
- The units were all converted to a common scale i.e. microgram.
- Sample Date was converted into "Date and Time' type. The dates under the 'Sample Date' Column were recoded from '2098' and '2099' to '1998' and '1999'. This was done using the recode feature in JMP by clicking 'Cols -> Recode'.
- An additional column called 'Scaled value' was calculated where the values were scaled based on the 'Measure' name, according to the following formula:
where,
Value = Record Value
Min = Minimum value for that chemical.
Max = Maximum Value for that chemical.
- The final table is as follows:
The Measure or Chemical "Macrozoobenthos" did not have a unit present.
Locating the co-ordinates
The co-ordinates of the various places were located using Tableau. The waterways image provided was loaded into tableau. The x and y co-ordinates were assigned to each of the 10 places present on the map.
- There are 106 chemicals present in the dataset. These chemicals are measured across the following 10 locations:
