Difference between revisions of "Maximum Project Findings"
Jump to navigation
Jump to search
| Line 39: | Line 39: | ||
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #4AB6A6 solid 32px;"><font color="#4AB6A6">Data Cleaning</font></div> | <div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #4AB6A6 solid 32px;"><font color="#4AB6A6">Data Cleaning</font></div> | ||
<br/> | <br/> | ||
| + | The pre-survey dataset had 1,455 records, and the post-survey dataset had 414 records. On merging, we only had 292 records where the pre- and post- surveys were both done by the respondents. | ||
| + | |||
| + | We also conducted the following cleaning procedures: | ||
| + | |||
| + | * Irrelevant and Duplicate Fields | ||
| + | * Missing Data | ||
| + | * Duplications | ||
| + | * Rectifying Discrepancies | ||
| + | * Data Transformation | ||
| + | * Standardisation | ||
| + | |||
<br/><div align="left"> | <br/><div align="left"> | ||
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #4AB6A6 solid 32px;"><font color="#4AB6A6">Data Exploration</font></div> | <div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #4AB6A6 solid 32px;"><font color="#4AB6A6">Data Exploration</font></div> | ||
Revision as of 13:03, 25 February 2018
Data Cleaning
The pre-survey dataset had 1,455 records, and the post-survey dataset had 414 records. On merging, we only had 292 records where the pre- and post- surveys were both done by the respondents.
We also conducted the following cleaning procedures:
- Irrelevant and Duplicate Fields
- Missing Data
- Duplications
- Rectifying Discrepancies
- Data Transformation
- Standardisation
Data Exploration
