Difference between revisions of "ISS608 2017-18 T3 G2 Assign ChenYanchong Data Prep"
Jump to navigation
Jump to search
Ycchen.2017 (talk | contribs) |
Ycchen.2017 (talk | contribs) |
||
Line 86: | Line 86: | ||
<br/> | <br/> | ||
[[Image:Cyc_data_desc_2.jpg]] | [[Image:Cyc_data_desc_2.jpg]] | ||
+ | <br/> | ||
+ | On the same day, a chemical could be examined multiple times, at most three times per day (as founded). One possible reason is that the sensor was triggered three times one day (since the ids are different) but at different date time, since timestamp information is not provided, this assumption can not be verified. However, to be fair, the when grouping data, the mean value is taken instead of the summation of the values. | ||
+ | [[Image:Cyc_data_desc_3.jpg]] |
Revision as of 16:24, 8 July 2018
Data overview
The following lists the data used for the analysis. The data is obtained from VAST Challenge 2018: Mini-Challenge 2.
Data description
Tools
R, Excel, Tableau
Data understanding
Integrated the two tables together, a record can be read as below format:
On the same day, a chemical could be examined multiple times, at most three times per day (as founded). One possible reason is that the sensor was triggered three times one day (since the ids are different) but at different date time, since timestamp information is not provided, this assumption can not be verified. However, to be fair, the when grouping data, the mean value is taken instead of the summation of the values.