Difference between revisions of "ISSS608 2016-17 T3 Anuthama Data Prep"

From Visual Analytics and Applications
Jump to navigation Jump to search
(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...")
(No difference)

Revision as of 22:02, 16 July 2017

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.