KNIME_​project_​coffee_​final

Import Dataset

General check for the data type

Distribution of Quantity, quite equally but not normal distribution

Export as coffee_clean.csv file for the future use.

Check the correlation between Item and payment method, most them highly related

Check the outliers for Price Per Unit, No finds

The relationship between Transaction date and Item

Distribution of Price Per Unit, quite equally but not normal distribution

Because with all string we can't apply EDA so I have to change some rows from string to number first

Format: Change the string to Date type

Missing value: Delete the rows with missing values in item and Transaction data because it's very less; Replace missing value with 0 in Quantity and Price Per Unit;

Duplicate: No duplications

Format: Leave only Data and put it in a new column

Format: Leave only Year and put it in a new column

Check the outliers for Quantity, No finds