ISSS608 2016-17 T3 Anuthama Data Prep

From Visual Analytics and Applications
Revision as of 22:02, 16 July 2017 by Anuthamam.2016 (talk | contribs) (Created page with "<div style=background:#070002 border:#A3BFB1> 200px <font size = 5; color="#FFFFFF">The Missing Case of the Rose-Crested Blue Pipit</font> </div> {|st...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Bluebird.gif The Missing Case of the Rose-Crested Blue Pipit

Background

Data Prep

Q1

Q2

Q3

Conclusion

Feedback

 

Tools And Techniques Used

1. JMP
2. Tableau
3. Power BI
4. Microsoft Excel

Data Cleaning

Check for Missing Values:
I did a missing Value check using JMP and found that there were no missing values

100%

Check for Duplicates:
1) Sort the data according to the car ID. Now all the car IDs will be sorted in ascending.
2) Use the formula below to check for duplicates

100% 100%

If you see 1 there ae duplicates if u see 0 there are no duplicates.