Difference between revisions of "ISSS608 2017-18 T3 Assign Lim Wee Kiong Data Preparation"
Jump to navigation
Jump to search
Wklim.2017 (talk | contribs) |
Wklim.2017 (talk | contribs) |
||
Line 41: | Line 41: | ||
Descriptions of the data fields for Boonsong Lekagul waterways readings are as follow: | Descriptions of the data fields for Boonsong Lekagul waterways readings are as follow: | ||
+ | |||
+ | {| class="wikitable centered" width="70%" | ||
+ | !Field | ||
+ | !Description | ||
+ | |- | ||
+ | |width="1%"|<!-- Field--> ID | ||
+ | |width="10%"|<!-- Description--> Identification number for the record (only for bookkeeping) | ||
+ | |- | ||
+ | |width="1%"|<!-- Field--> Value | ||
+ | |width="10%"|<!-- Description--> Measured value for the chemical or property in this record | ||
+ | |- | ||
+ | |width="1%"|<!-- Field--> Location | ||
+ | |width="10%"|<!-- Description--> Name of the location sample was taken from. See the map for geo-location of the sampling site. | ||
+ | |- | ||
+ | |width="1%"|<!-- Field--> Sample Date | ||
+ | |width="10%"|<!-- Description--> Date sample was taken from the location | ||
+ | |- | ||
+ | |width="1%"|<!-- Field--> Measure | ||
+ | |width="10%"|<!-- Description--> Chemicals (e.g., Sodium) or water properties (e.g., Water temperature) measured in the record | ||
+ | |- | ||
+ | |} | ||
Revision as of 16:04, 6 July 2018
|
|
|
|
|
|
Data Preparation
Understanding the Raw Data – Samples Readings and Measures
The data given to us comes in 2 main files: Boonsong Lekagul waterways readings.csv and chemical units of measure.csv.
Data cleaning is done in Excel and data visualization in Tableau.
Descriptions of the data fields for Boonsong Lekagul waterways readings are as follow:
Field | Description |
---|---|
ID | Identification number for the record (only for bookkeeping) |
Value | Measured value for the chemical or property in this record |
Location | Name of the location sample was taken from. See the map for geo-location of the sampling site. |
Sample Date | Date sample was taken from the location |
Measure | Chemicals (e.g., Sodium) or water properties (e.g., Water temperature) measured in the record |
Back to Dropbox Page