Final_​Exam_​Cafe_​Sale

Cafe_sales

Removed duplicates in Transaction ID to ensure observation uniqueness.

Displaying descriptive statistics for numerical data exploration and catecorigal.

Emphasising the Rows with value and Counting occurrences of each unique value

The scatter plot illustrates the relationship between item and price per unit , highlighting the overall trend and the presence of outliers.

Convert the number to insure consistencies

replaces "UNKNOWN" AND "ERRO" values with missing values in columns and created new column with missing values to ease the imputation for each columns

relation between the payment method and the value sale

Filled missing financials with Median to avoid the effect of outliers, categorical missing values with the Mode, the Date with previous data.we are suppose to identify each item and associate each price to to refer item to feel the price per unit

relation between the payment method and the value salemost customer prefer to pay by digital wallet, the two other method are lest common

Convert the date to insure consistencies

Calculate the total revenue per item

used to modify the table structure by removing none transform old columns of the original table, and reordering the append columns.

revenue per item sale during 2023 yearthe most sale product is the juivce the company need to check the cookie sale is the less buy product

Generating a structured final table to a CSV file.

Aggregate the item per quantity sell and the mean price