/Data-cleaning-with-spreadsheets

used advanced spreadsheets tools to clean a large dataset

Data-cleaning-with-spreadsheets

Business Task:

  • Know what factors affect student grades in core subjects and what changes can be made to improve student performance.
  • my role- clean the data

Data collection:

  • data was collected by means of academic reports and student surveys.

Changelog:

  • made copy of original data in spreadsheets.
  • removed irrelelvant age data by sorting ages in descending order and filtering ages 20-22.
  • removed duplicate data by using remove duplicates tool.
  • filled in missing data by applying a filter on the reason column. filtered for blank records and entered "none given" in blank records.
  • converted data to a format that was easier for analysis from text to numbers in the medu column using the find and replace tool.