Difference between revisions of "ISSS608 2017-18 T3 Assign Lim Wee Kiong Data Preparation"

From Visual Analytics and Applications
Jump to navigation Jump to search
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

DuckFam.jpg    VAST 2018 Mini-Challenge 2: Like a Duck to Water

Introduction

Data Preparation

Dashboard Methodology

Insights & Findings

Conclusion & Comments


 


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

Go back.png