Wiki Sumber Informasi iSIKHNAS

Cleaning Messy Data

Learning objectives

After completing this activity, you will be able to:

• determine whether an existing dataset has a structure that is suitable for basic analyses
• recommend a suitable structure for an existing (currently unsuitable) dataset
• identify the problems in a dataset that prevent its use for analysis
• manipulate such a dataset into a form suitable for analysis, applying existing skills, and using the following new skills:
  • view multiple worksheets at the same time
    • within a single instance of Excel
    • using multiple instances of Excel (Excel 2010)
  • copy a worksheet to the same, or another, workbook
  • unmerging of cells
  • text to columns
  • find and replace.