Analyzing numeric columns
You have already identified missing values and unique entries in your grocery inventory dataset. Now you need to understand the pricing patterns in your inventory by analyzing the Unit_Price column. Calculate basic statistical measures like minimum, maximum, mean, and standard deviation of product prices.
This exercise is part of the course
Cleaning Data in Java
Exercise instructions
- Extract the
Unit_Pricecolumn. - Compute the min and max of
Unit_Price. - Compute the mean and standard deviation of
Unit_Price.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
import tech.tablesaw.api.DoubleColumn;
import tech.tablesaw.api.Table;
public class GroceryDataQuality {
public static void main(String[] args) {
Table inventory = Table.read().csv("grocery_inventory.csv");
// Extract the unit price column
DoubleColumn price = ____.____("Unit_Price");
System.out.println("Stock Quantity Statistics:");
// Compute the min and max of unit price
System.out.println("Min: " + price.____());
System.out.println("Max: " + price.____());
// Compute the mean and standard deviation of the unit price
System.out.println("Mean: " + price.____());
System.out.println("Standard deviation: " + price.____());
}
}