Difference between revisions of "Maximum Project Findings"
Jump to navigation
Jump to search
Line 43: | Line 43: | ||
We also conducted the following cleaning procedures: | We also conducted the following cleaning procedures: | ||
− | * Irrelevant and Duplicate Fields | + | * Irrelevant and Duplicate Fields: Removed from our dataset. |
− | * Missing Data | + | * Missing Data: Removed from our data set, null values were replaced with 0s to facilitate our analysis. |
− | + | * Rectifying Discrepancies: Ensured data from pre- and post- survey were in comparable formats. | |
− | * Rectifying Discrepancies | + | * Data Transformation: Transformed categorical data into numerical data for the Likert data analysis. |
− | * Data Transformation | + | * Standardisation: Standardised name conventions for the variables in the merged data. |
− | * Standardisation | ||
<br/><div align="left"> | <br/><div align="left"> |
Revision as of 13:12, 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: Removed from our dataset.
- Missing Data: Removed from our data set, null values were replaced with 0s to facilitate our analysis.
- Rectifying Discrepancies: Ensured data from pre- and post- survey were in comparable formats.
- Data Transformation: Transformed categorical data into numerical data for the Likert data analysis.
- Standardisation: Standardised name conventions for the variables in the merged data.
Data Exploration