ChenNannan-Data preparation
Revision as of 20:44, 8 July 2018 by Nnchen.2017 (talk | contribs) (Created page with "<div style=background:#2B3856 border:#A3BFB1> 250px <font size = 5; color="#FFFFFF"> ISSS608 Assign ChenNannan-MC2</font> </div> <!--MAIN HEADER --> {|...")
|
|
|
|
Data Quality Issues
- No missing value.
- At least 2.5% of 0 value in value variables which is meaningless.
- Year 1998 and 1999 are imported wrong. The time series range is from 1998 to 2016.
- Same location, sample date and measure have different value record.
Data Preparation
- Recode the sample date.
- Use the summary function to avoid duplication record by mean.
- 'Dcast' the data
- Standardize the value by each kinds of measure because different units.
- 'Melt' the data