Difference between revisions of "Methodology"
Rupinis.2017 (talk | contribs) |
Rupinis.2017 (talk | contribs) (Undo revision 7618 by Yanzhang.lu.2017 (talk)) |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 12: | Line 12: | ||
; | ; | ||
| − | [[ | + | [[Methodology| <font color="#FFFFFF">'''Methodology'''</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
; | ; | ||
| − | [[ | + | |
| + | [[Observations| <font color="#FFFFFF">'''Observations'''</font>]] | ||
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
; | ; | ||
| − | [[ | + | [[Conclusion| <font color="#FFFFFF">'''Conclusion'''</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
| Line 33: | Line 34: | ||
<!--METHODOLOGY CONTENT --> | <!--METHODOLOGY CONTENT --> | ||
| − | ==<font size="5"><font color="#000000">''' | + | ==<font size="5"><font color="#000000">'''Overview'''</font></font>== |
| − | Two datasets are provided to answer the questions for this challenge; one is “Boonsong Lekagul waterways readings” and other is “Chemical units of measure”. The former file includes information related to 106 chemical indicators of water quality and their readings collected from 10 locations across the preserve. There are total of 136,824 records of readings collected from January 1998 to December 2016. | + | Two datasets are provided to answer the questions for this challenge; one is “Boonsong Lekagul waterways readings” and other is “Chemical units of measure”. The former file includes information related to 106 chemical indicators of water quality and their readings collected from 10 locations across the preserve. There are total of 136,824 records of readings collected from January 1998 to December 2016. Belos is the snippet of dataset. |
| + | |||
| + | [[Image:Rup Data.jpg|600px]] | ||
==<font size="5"><font color="#000000">'''Data Preparation'''</font></font>== | ==<font size="5"><font color="#000000">'''Data Preparation'''</font></font>== | ||
| − | The above mentioned two data files are combined into one by matching measure name in both the files. | + | The above mentioned two data files are combined into one by matching measure name in both the files. Description of variables from the combined files is shown below. |
| − | |||
| − | |||
| − | |||
| − | |||
[[Image:Variables.JPG|600px]] | [[Image:Variables.JPG|600px]] | ||
| Line 56: | Line 55: | ||
==<font size="5"><font color="#000000">'''Geo – Location Mapping'''</font></font>== | ==<font size="5"><font color="#000000">'''Geo – Location Mapping'''</font></font>== | ||
In addition to two data files, an image file “Waterways Final” with location of various water sensors across the preserve is also provided. This image file is added to tableau workspace as a background image to extract the coordinates of every location of sensors. New excel file is created as “Location.csv” with column names as location, X and Y. The point that represents each location of sensors in the map is annotated to get X and Y coordinates. The values of coordinates are then manually included into the excel file. | In addition to two data files, an image file “Waterways Final” with location of various water sensors across the preserve is also provided. This image file is added to tableau workspace as a background image to extract the coordinates of every location of sensors. New excel file is created as “Location.csv” with column names as location, X and Y. The point that represents each location of sensors in the map is annotated to get X and Y coordinates. The values of coordinates are then manually included into the excel file. | ||
| + | |||
| + | [[Image:Rup geo.jpg|600px]] | ||
| + | |||
| + | |||
| + | ==<font size="5"><font color="#000000">'''Tools Used'''</font></font>== | ||
| + | * Microsoft Excel | ||
| + | * JMP Pro | ||
| + | * Tableau | ||
Latest revision as of 19:07, 8 July 2018
Vast Mini Challenge 2: Like a Duck to Water
|
|
|
|
|
|
|
Overview
Two datasets are provided to answer the questions for this challenge; one is “Boonsong Lekagul waterways readings” and other is “Chemical units of measure”. The former file includes information related to 106 chemical indicators of water quality and their readings collected from 10 locations across the preserve. There are total of 136,824 records of readings collected from January 1998 to December 2016. Belos is the snippet of dataset.
Data Preparation
The above mentioned two data files are combined into one by matching measure name in both the files. Description of variables from the combined files is shown below.
Data Cleaning
Initial data exploration of combined data files is performed in JMP. It is found that 9700 records of various chemical indicators have value of 0. Reading value of 0 is equivalent to missing value for any chemical measure. This can be problem if 0 is not removed from records and taken into tableau for visualization. Tableau treats 0 as value and plot these points in the visualization. To avoid that, records with value 0 is removed from dataset before loading into Tableau.
Geo – Location Mapping
In addition to two data files, an image file “Waterways Final” with location of various water sensors across the preserve is also provided. This image file is added to tableau workspace as a background image to extract the coordinates of every location of sensors. New excel file is created as “Location.csv” with column names as location, X and Y. The point that represents each location of sensors in the map is annotated to get X and Y coordinates. The values of coordinates are then manually included into the excel file.
Tools Used
- Microsoft Excel
- JMP Pro
- Tableau
