Difference between revisions of "ISSS608 2017-18 T3 Assign Song Xuejing Data Preparation"
Xjsong.2017 (talk | contribs) |
Xjsong.2017 (talk | contribs) |
||
| Line 42: | Line 42: | ||
[[Image:q1.1.png|500px|center]] | [[Image:q1.1.png|500px|center]] | ||
| + | [[Image:q1.2.png|500px|center]] | ||
| + | [[Image:q1.3.png|500px|center]] | ||
| − | [[Image:q1. | + | Secondly, the value of some chemicals tends to have more outliers than past few years, and these chemicals are as shown below. |
| + | [[Image:q1.4.png|500px|center]] | ||
| + | [[Image:q1.5.png|500px|center]] | ||
| + | [[Image:q1.6.png|500px|center]] | ||
| − | [[Image:q1. | + | Thirdly, there are even some value of chemicals decreased from past to recent years, because the samples are not just including chemical contamination, but also include some minerals. Therefore, these chemicals are as below. |
| + | [[Image:q1.7.png|500px|center]] | ||
| + | [[Image:q1.8.png|500px|center]] | ||
| + | [[Image:q1.9.png|500px|center]] | ||
| + | [[Image:q1.10.png|500px|center]] | ||
| + | [[Image:q1.11.png|500px|center]] | ||
| + | [[Image:q1.12.png|500px|center]] | ||
| + | [[Image:q1.13.png|500px|center]] | ||
| + | [[Image:q1.14.png|500px|center]] | ||
| + | [[Image:q1.15.png|500px|center]] | ||
</font></font> | </font></font> | ||
Revision as of 02:08, 8 July 2018
VAST Challenge 2018: Suspense at the Wildlife Preserve
Mini Challenge 2 - Like a duck to water
|
|
|
|
|
|
Data Preparation
We have two dataset which include the chemical units of measure and Boonsong Lekagul waterways readings. There are 106 different chemical measurements of the water, some of them are chemicals that will damage the water, which may possible output by the furniture factory, and some of the chemicals are just minerals such as iron and zinc. Also, these samples were randomly taken from 1998 to 2016. Therefore, firstly, we need to filter out all the chemicals that we need.
We should use chemicals have enough data points at least in recent years, because we need to identify that the water quality has been bad since the furniture factory has been build. If the chemical is no longer measured anymore, there is no point to identify the changes of the water quality. After first round of filtering, we have these chemicals remaining, only these chemicals have data till 2016.
Question 1
After filtering out all the unnecessary chemicals, we can take a look at the overview of all the chemicals in different places one by one. For question1, we need to characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways. Because we don’t know which year the factory was build, we define the recent as data point after 2013, and the past as data points before 2013, in order to see if there is any trend of some chemical measurements. After going through all the chemicals, we have found three apparent type of trends. First, the value of some chemicals increased from past to recent years. Including chemicals as below.
Secondly, the value of some chemicals tends to have more outliers than past few years, and these chemicals are as shown below.
Thirdly, there are even some value of chemicals decreased from past to recent years, because the samples are not just including chemical contamination, but also include some minerals. Therefore, these chemicals are as below.
