# beginners-guide-to-clean-data

## beginners-guide-to-clean-data

- [A Beginner's Guide to Clean Data](https://b-greve.gitbook.io/beginners-guide-to-clean-data/master.md): Practical advice to spot and avoid data quality problems. - Benjamin Greve
- [Foreword](https://b-greve.gitbook.io/beginners-guide-to-clean-data/introduction-1/foreword.md)
- [The value of data](https://b-greve.gitbook.io/beginners-guide-to-clean-data/introduction-1/the-value-of-data.md)
- [The intangible nature of data](https://b-greve.gitbook.io/beginners-guide-to-clean-data/introduction-1/the-intangible-nature-of-data.md)
- [Missing values](https://b-greve.gitbook.io/beginners-guide-to-clean-data/missing-data-1/missing-values.md)
- [Missing value patterns](https://b-greve.gitbook.io/beginners-guide-to-clean-data/missing-data-1/missing-value-patterns.md)
- [Missing value representations](https://b-greve.gitbook.io/beginners-guide-to-clean-data/missing-data-1/missing-value-representations.md)
- [Missing observations](https://b-greve.gitbook.io/beginners-guide-to-clean-data/missing-data-1/missing-observations.md)
- [Truncated exports](https://b-greve.gitbook.io/beginners-guide-to-clean-data/missing-data-1/truncated-exports.md)
- [Handling missing values](https://b-greve.gitbook.io/beginners-guide-to-clean-data/missing-data-1/handling-missing-values.md)
- [Unexpected values](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-range-problems/untitled.md)
- [Outliers](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-range-problems/outliers.md)
- [Freak cases](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-range-problems/freak-cases.md)
- [CSV basics](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/untitled.md)
- [Quotation characters](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/quotation-characters.md)
- [Line breaks in text fields](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/line-breaks-in-text-fields.md)
- [Missing or insufficient headers](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/missing-or-insufficient-headers.md)
- [Trailing line breaks](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/trailing-line-breaks.md)
- [Data export and import](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/data-export-and-import.md)
- [Column type violations](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/column-type-violations.md)
- [Guidelines for working with CSV files](https://b-greve.gitbook.io/beginners-guide-to-clean-data/common-csv-problems/guidelines-for-working-with-csv-files.md)
- [Text mining basics](https://b-greve.gitbook.io/beginners-guide-to-clean-data/text-mining-problems/untitled.md)
- [Encoding in your data and IDE](https://b-greve.gitbook.io/beginners-guide-to-clean-data/text-mining-problems/encoding-in-your-data-and-ide.md)
- [Special characters](https://b-greve.gitbook.io/beginners-guide-to-clean-data/text-mining-problems/special-characters.md)
- [Character entities](https://b-greve.gitbook.io/beginners-guide-to-clean-data/text-mining-problems/character-entities.md)
- [Lookalike characters](https://b-greve.gitbook.io/beginners-guide-to-clean-data/text-mining-problems/lookalike-characters.md)
- [Dummy words](https://b-greve.gitbook.io/beginners-guide-to-clean-data/text-mining-problems/dummy-words.md)
- [Inconsistent timestamp formats](https://b-greve.gitbook.io/beginners-guide-to-clean-data/type-and-format-related-problems/untitled.md)
- [Whitespace-padded strings](https://b-greve.gitbook.io/beginners-guide-to-clean-data/type-and-format-related-problems/whitespace-padded-strings.md)
- [Binary data](https://b-greve.gitbook.io/beginners-guide-to-clean-data/type-and-format-related-problems/binary-data.md)
- [Semi-structured log files](https://b-greve.gitbook.io/beginners-guide-to-clean-data/type-and-format-related-problems/semi-structured-log-files.md)
- [Proprietary data formats](https://b-greve.gitbook.io/beginners-guide-to-clean-data/type-and-format-related-problems/proprietary-data-formats.md)
- [Spreadsheets](https://b-greve.gitbook.io/beginners-guide-to-clean-data/type-and-format-related-problems/spreadsheets.md)
- [Numeric overflow](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/untitled.md)
- [Duplicate rows](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/duplicate-rows.md)
- [Table joins](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/table-joins.md)
- [Huge enterprise databases](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/huge-enterprise-databases.md)
- [Case sensitivity](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/case-sensitivity.md)
- [Separating DDL and DML statements](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/separating-ddl-and-dml-statements.md)
- [Database performance considerations](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/database-performance-considerations.md)
- [Naming tables and columns](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/naming-tables-and-columns.md)
- [Poorly written SQL](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/poorly-written-sql.md)
- [Large monolithic SQL scripts](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/large-monolithic-sql-scripts.md)
- [SQL orchestration](https://b-greve.gitbook.io/beginners-guide-to-clean-data/database-related-problems/sql-orchestration.md)
- [No single point of truth](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-inconsistency/untitled.md)
- [Non-matching aggregated data](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-inconsistency/non-matching-aggregated-data.md)
- [Internal inconsistency](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-inconsistency/internal-inconsistency.md)
- [Business concepts](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-modeling/untitled.md)
- [Handling complexity](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-modeling/handling-complexity.md)
- [Interfaces](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-modeling/interfaces.md)
- [Generalized data models](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-modeling/generalized-data-models.md)
- [Reproducibility](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-modeling/reproducibility.md)
- [Feature stores and feature engines](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-modeling/feature-stores-and-feature-engines.md)
- [Thinking pragmatic](https://b-greve.gitbook.io/beginners-guide-to-clean-data/data-modeling/thinking-pragmatic.md)
- [Automated testing](https://b-greve.gitbook.io/beginners-guide-to-clean-data/monitoring-and-testing/untitled.md)
- [Measuring database load](https://b-greve.gitbook.io/beginners-guide-to-clean-data/monitoring-and-testing/measuring-database-load.md)
- [Checklist for new data](https://b-greve.gitbook.io/beginners-guide-to-clean-data/bonus-content/untitled.md)