Difference between revisions of "ISSS608 2016-17 T3 Assign APARAJITA SHUKLA DataPrep"
(Methodology) |
(Methodoogy changes) |
||
| Line 1: | Line 1: | ||
<!--MAIN HEADER--> | <!--MAIN HEADER--> | ||
| − | <div style=background:# | + | <div style=background:#438787 border:#A3BFB1> |
<font size = 3; color="#FFFFFF">Methodology</font> | <font size = 3; color="#FFFFFF">Methodology</font> | ||
</div> | </div> | ||
| Line 17: | Line 17: | ||
The last .jpg file contains the map of Boonsong Lekagul waterways. | The last .jpg file contains the map of Boonsong Lekagul waterways. | ||
| − | <div style=background:# | + | <div style=background:#438787 border:#A3BFB1> |
<font size = 3; color="#FFFFFF">Checking Missing Values</font> | <font size = 3; color="#FFFFFF">Checking Missing Values</font> | ||
</div> | </div> | ||
| Line 27: | Line 27: | ||
As can be seen from the image above, there were no missing value present in given dataset. | As can be seen from the image above, there were no missing value present in given dataset. | ||
| − | <div style=background:# | + | <div style=background:#438787 border:#A3BFB1> |
<font size = 3; color="#FFFFFF">Getting the Map</font> | <font size = 3; color="#FFFFFF">Getting the Map</font> | ||
</div> | </div> | ||
| Line 38: | Line 38: | ||
And then create map by dragging and dropping the coordinates on the worksheet. | And then create map by dragging and dropping the coordinates on the worksheet. | ||
| − | <div style=background:# | + | <div style=background:#438787 border:#A3BFB1> |
<font size = 3; color="#FFFFFF">Joining the Tables</font> | <font size = 3; color="#FFFFFF">Joining the Tables</font> | ||
</div> | </div> | ||
| Line 46: | Line 46: | ||
| − | <div style=background:# | + | <div style=background:#438787 border:#A3BFB1> |
<font size = 3; color="#FFFFFF">Final Table</font> | <font size = 3; color="#FFFFFF">Final Table</font> | ||
</div> | </div> | ||
Revision as of 02:24, 2 July 2018
Methodology
We have been provided with three files along with a map of the Boonsong Lekagul preserve area. Where two files are .csv and one is .txt.
The first file, Boonsong Lekagul waterways readings.csv contains 5 columns namely Id, value, location, sample date, measure and have 136924 rows.
The second file, chemical units of measure.csv has two columns namely, measure, unit.
The third .txt file basically contains all the information about the data present in the other files.
The last .jpg file contains the map of Boonsong Lekagul waterways.
Checking Missing Values
To check the missing values, I have used JMP.
As can be seen from the image above, there were no missing value present in given dataset.
Getting the Map
After importing data file into tableau, we first import the image of the map and using annotate using points, I marked all the locations in the map and manually created a separate .xslx file:
And then create map by dragging and dropping the coordinates on the worksheet.
Joining the Tables
As we needed to join Location table, measure.csv and Boonsong Lekagul waterways readings.csv tables together, the tool used for this is Tableau:
Final Table
