Data Wrangling Summary

2018-07-16  本文已影响0人  Vince_zzhang

Gather

Depending on the source of your data, and what format it's in, the steps in gathering data vary.

High-level gathering process: 

    obtaining data (downloading a file from the internet, scraping a web page, querying an API, etc.) 

    importing that data into your programming environment (e.g., Jupyter Notebook).

Assess

Assess data for:

Quality: issues with content. Low quality data is also known as dirty data.

Tidiness: issues with structure that prevent easy analysis. Untidy data is also known as messy data. Tidy data requirements:

    Each variable forms a column.

    Each observation forms a row.

    Each type of observational unit forms a table.

Types of assessment:

    Visual assessment: scrolling through the data in your preferred software application (Google Sheets, Excel, a text editor, etc.).

    Programmatic assessment: using code to view specific portions and summaries of the data (pandas' head, tail, and info methods, for example).

Clean

Types of cleaning:

    Manual (not recommended unless the issues are single occurrences)

    Programmatic

The programmatic data cleaning process:

    Define: convert our assessments into defined cleaning tasks. These definitions also serve as an instruction list so others (or yourself in the future) can look at your work and reproduce it.

    Code: convert those definitions to code and run that code.

    Test: test your dataset, visually or with code, to make sure your cleaning operations worked.

Always make copies of the original pieces of data before cleaning!

Reassess and Iterate

After cleaning, always reassess and iterate on any of the data wrangling steps if necessary.

Store (Optional)

Store data, in a file or database for example, if you need to use it in the future.

From Udaicty Advanced Data Analyst Nanodegree

上一篇下一篇

猜你喜欢

热点阅读