Aggregating columns
You need to clean and analyze your stock data to understand high-value inventory patterns. Raw inventory data often includes irrelevant items and needs organization by category. Clean the data by filtering for expensive items (over $5), then calculate accurate totals, and organize by category. This cleaned and summarized view helps identify which departments have the most investment in premium products.
tablesaw packages have been imported for you.
이 연습은 강의의 일부입니다
Cleaning Data in Java
연습 안내
- Find expensive items (
Unit_Price> $5.00). - Calculate the total
Stock_Quantityfor each category. - Group results by
Category.
실습형 인터랙티브 연습
이 예제를 이 샘플 코드를 완성하여 풀어보세요.
public class GroceryDataAggregation {
public static void main(String[] args) {
Table inventory = Table.read().csv("grocery_inventory.csv");
Table quantityByCategory = inventory
// Find expensive items (price > $5.00)
.where(inventory.doubleColumn("Unit_Price").____(5.0))
// Calculate total stock for each category
.____("Stock_Quantity", ____)
// Group results by product category
.____("Category");
System.out.println("Total quantity by category:");
System.out.println(quantityByCategory.first(5));
}
}