Return to Text editor, Editing, Edit-compile-debug, Data Science, Python Data Science, DataOps, Data Cleaning, Python ML - Python DL - Python NLP - Python MLOps, Data Science bibliography, Data Science glossary, Awesome Data Science, Data Science topics

For Big data editing, besides Python data cleaning, I recommend:

Snippet from Wikipedia: Data cleansing

Data cleansing or data cleaning is the process of identifying and correcting (or removing) corrupt, inaccurate, or irrelevant records from a dataset, table, or database. It involves detecting incomplete, incorrect, or inaccurate parts of the data and then replacing, modifying, or deleting the affected data. Data cleansing can be performed interactively using data wrangling tools, or through batch processing often via scripts or a data quality firewall.

After cleansing, a data set should be consistent with other similar data sets in the system. The inconsistencies detected or removed may have been originally caused by user entry errors, by corruption in transmission or storage, or by different data dictionary definitions of similar entities in different stores. Data cleaning differs from data validation in that validation almost invariably means data is rejected from the system at entry and is performed at the time of entry, rather than on batches of data.

The actual process of data cleansing may involve removing typographical errors or validating and correcting values against a known list of entities. The validation may be strict (such as rejecting any address that does not have a valid postal code), or with fuzzy or approximate string matching (such as correcting records that partially match existing, known records). Some data cleansing solutions will clean data by cross-checking with a validated data set. A common data cleansing practice is data enhancement, where data is made more complete by adding related information. For example, appending addresses with any phone numbers related to that address. Data cleansing may also involve harmonization (or normalization) of data, which is the process of bringing together data of "varying file formats, naming conventions, and columns", and transforming it into one cohesive data set; a simple example is the expansion of abbreviations ("st, rd, etc." to "street, road, etcetera").

Creative Commons Attribution-Share Alike 4.0

Research:

• editor on DuckDuckGo
• editor on Python.org
• editor on pypi.org
• editor on PyMOTW.com
• editor on YouTube
• editor on O'Reilly
• editor on GitHub
• editor on Reddit
• editor on scholar.google.com
• editor on StackOverflow

Fair Use Sources:

• editor on DuckDuckGo