课程

Cleaning Data in Java

中级技能水平

更新时间 2025年12月

用统计方法、转换和验证掌握 Java 数据清洗，打造可靠应用。

免费开始课程

JavaImporting & Cleaning Data

4小时

13 视频

39 道练习

3,250 XP

成就证明

深受数千家公司学习者的喜爱

需要团队培训？

企业版试用

课程描述

Cleaning data is crucial for business problems. When data quality suffers, analytics become unreliable, machine learning models make poor predictions, and business decisions go awry.This course equips you with Java tools to tackle data quality head-on. You'll learn statistical methods to spot outliers and handle missing values, master data transformations from standardizing text to managing dates across time zones, and implement range checks using regular expressions and validation annotations.Working with Tablesaw, you'll clean real-world tabular data and perform transformations that prepare data for analysis. You'll finish ready to ensure data quality at every step of your applications.

先决条件

Data Types and Exceptions in Java

1

Assessing Data Quality

Learn essential techniques for assessing data quality in Java applications. Discover how to use descriptive statistics to identify outliers, detect and handle missing values appropriately, and validate data types to prevent errors. Master key tools like DescriptiveStatistics for numerical analysis, Optional for null handling, and DateTimeFormatter for date validation.

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

2

Transforming Data

Master data transformation techniques for reliable Java applications. Learn to normalize strings using regular expressions for consistent text matching, standardize categories with EnumMap and HashMap for robust lookup tables, and handle date formats using Java's time API with LocalDate and ZoneId for consistent date handling across time zones.

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

3

Validating Data

Ensure data quality through validation techniques. Learn to implement range validation for numeric values and dates, master pattern validation using regular expressions to verify data formats, and apply constraint validation to enforce business rules.

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

4

Cleaning Tabular Data

Transform messy tabular data into clean, usable datasets with Tablesaw, a powerful Java library. You'll assess data quality, standardize column contents, and apply filtering operations to prepare your data. By the end, you'll confidently turn raw datasets into analysis-ready tables.

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!

Cleaning Data in Java

课程完成

获得成就证明

将此证书添加到您的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Cleaning Data in Java！

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。