Assessing Data Quality
Data statistics
()
Computing mean, min, max
Computing percentiles
Null detection
()
Detecting missing numbers
Detecting missing strings
Data type verification
()
Parsing text into dates and numbers
Reading CSV files safely
Transforming Data
String normalization
()
Regular expressions
Cleaning strings
Categorical standardization
()
Building a category mapping
Grouping by standardized categories
Date standardization
()
Standardizing dates
Converting time zones
Extracting month and year from dates
Validating Data
Range validation
()
Validating numeric ranges
Validating date ranges
Pattern validation
()
Full pattern matching
Pattern finding
Character matching
Constraint enforcement
()
Annotations with video game sales
Displaying validation messages
Cleaning Tabular Data
Data quality assessment with Tablesaw
()
Analyzing missing and unique values
Analyzing numeric columns
Column cleaning and standardization
()
Transforming numeric data
Transforming text data
Column filtering and aggregation
()
Filtering columns
Aggregating columns
Congratulations!
()
Grocery_Inventory.csv
(38 KB)
coffee_sales.csv
(0 KB)