Difference between revisions of "ISSS608 2017-18 T3 Assign Vaishnavi Praveen Agarwal DataPrep"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 47: Line 47:
 
||
 
||
 
<b>i. Read in Raster Layer (Lekagul Roadways Map)</b>  
 
<b>i. Read in Raster Layer (Lekagul Roadways Map)</b>  
* It is a single layer raster file. 200x200.
 
 
<b>ii. Find out structure of Raster Layer</b>
 
<br> Extent          : 40000
 
<br> CRS arguments  : NA
 
<br> File Size      : 41078
 
<br> Object Size    : 14376 bytes
 
<br> Layer          : 1
 
|-
 
 
|  
 
|  
  
Line 61: Line 52:
 
||
 
||
 
<b>i. Import two CSV Files (Birds)</b>  
 
<b>i. Import two CSV Files (Birds)</b>  
* 2081 Training Birds (Metadata)
 
* 15 Test Birds (Provided by Kasios)
 
 
 
<b>ii. Fix Data Quality Issues</b>
 
* Change File ID from numeric to character
 
* Change coordinates to numeric
 
* Change Date from Character to Date
 
* Omit the two NA values for the Y coordinate.
 
* Clean the Dates (All standardise to m/d/y. For missing month/year, I will replace with NA. For missing day, I will impute as 1st day of the month.)
 
* Clean the Timing (Standardise all to 24 hour formatting. Use “.” instead of ":")
 
* Clean the Vocalisation Type (Standardise all to lower case. For values consisting of both ‘song and call’, change to ‘call’, assumed as a sign of distress while ‘song’ is assumed as the default)
 
* Clean the Quality (Recode ‘no score’ as ‘NA’)
 
 
 
 
 
<b>iii. Data Manipulation</b>  
 
<b>iii. Data Manipulation</b>  
* Extract out the “Year” and “Month” from the date, as new columns
 
* Create a new column for Quarter (Q1,Q2,Q3,Q4) & Season (Spring, Summer, Fall, Winter)
 
 
 
 
|}
 
|}
 
</div>
 
</div>

Revision as of 15:07, 6 July 2018

Pic.jpg   VAST Challenge: Mini Challenge 2

The Challenge

Data Preparation

Visualizations

Insights and Conclusion

Feedback and Comments

All Assignments

 

Data Description

File Name

Variables

Boonsong Lekagul waterways readings

i. Read in Raster Layer (Lekagul Roadways Map)

chemical units of measure

i. Import two CSV Files (Birds) iii. Data Manipulation