ISSS608 2017-18 T3 Assign Lim Wee Kiong Data Preparation

From Visual Analytics and Applications
Revision as of 16:04, 6 July 2018 by Wklim.2017 (talk | contribs)
Jump to navigation Jump to search

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