supermarket_raw=read_csv("supermarket_sales.csv")
my_supermarket_subtotal=mutate(supermarket_raw,subtotal=unit_price*quantity)
tax_verify=filter(my_supermarket_subtotal,tax_5_percent=="subtotal*.005")
Food_Beverage=filter(my_supermarket_subtotal,product_line=="Food and beverages")
my_supermarket_limited=select(Food_Beverage,city,product_line,unit_price,quantity,total,rating)
my_supermarket_sorted=arrange(my_supermarket_limited,desc(quantity))
sink("Untitled3")
Extract
Text File
1 sheet
17
Dimension
String
Measure
Number (decimal)
They are all pretty similar sales based on the cities. They could increase sales by sending more to Naypyitaw since they currently have the highest total spending.
They are pretty similar across gender but in Naypyitaw the Female gender base spends more out of all of the cities.