ISSS608 2016-17 T3 Assign DEBASISH BEHERA DataPrep

From Visual Analytics and Applications
Jump to navigation Jump to search

Vacomm logo.jpg VAST Challenge: Mini Challenge 2

Introduction

Data Preparation

Insight & Conclusion

Submission and Comments

 


Meteorological Data


The meteorological data was checked for any missing values.


Meteor deb.png

Figure 1


We found here that there are two missing values for the wind direction. These missing values were removed for our subsequent analysis.


Winddirection.png

Figure 2

The meteorological table was added with two columns that described the wind direction and the wind speed using formulas in excel.

Sensor Data


Sensor deb.png

Figure 3


There are no missing values that can be observed for the sensor data.


Sensor Coordinate Table


Senscordeb.png

Figure 4

The Sensor Coordinate table was made by inputting the coordinates in excel and creating one excel file know as sensor coordinates


Preparing the Data for Wind Fan


Windfan deb.png

Figure 5

For preparing the data for constructing the wind fan, the data set known as Meteorological_Data_windrose.csv was created by using the table meteorological data, sensor data and the sensor coordinates.


Windfancode.png

Figure 6

After we have prepared the data then we use R to replicate each row 3 times and give a path ID. The table created was known as wind_rose_data_prep.csv