R Notebook

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

library(readr)
data = read_csv("C:/Users/shiro/Downloads/archive/synthetic_beverage_sales_data.csv")

Rows: 8999910 Columns: 11
── Column specification ───────────────────────────────────────────────────────────────
Delimiter: ","
chr  (6): Order_ID, Customer_ID, Customer_Type, Product, Category, Region
dbl  (4): Unit_Price, Quantity, Discount, Total_Price
date (1): Order_Date

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

data

data$Discount <- as.numeric(data$Discount)
data$Total_Price <- as.numeric(data$Total_Price)

if (!require(dplyr)) install.packages("dplyr")
if (!require(ggplot2)) install.packages("ggplot2")


library(dplyr)
library(ggplot2)

library(readxl)
data = read_csv("C:/Users/shiro/Downloads/archive/synthetic_beverage_sales_data.csv")

Rows: 8999910 Columns: 11
── Column specification ───────────────────────────────────────────────────────────────
Delimiter: ","
chr  (6): Order_ID, Customer_ID, Customer_Type, Product, Category, Region
dbl  (4): Unit_Price, Quantity, Discount, Total_Price
date (1): Order_Date

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

data$Discount <- as.numeric(data$Discount)
data$Total_Price <- as.numeric(data$Total_Price)

product_discount_usage <- data %>%
  group_by(Product) %>%
  summarise(Average_Discount = mean(Discount, na.rm = TRUE)) %>%
  arrange(desc(Average_Discount))


category_discount_usage <- data %>%
  group_by(Category) %>%
  summarise(Average_Discount = mean(Discount, na.rm = TRUE)) %>%
  arrange(desc(Average_Discount))

discount_revenue <- data %>%
  group_by(Discount) %>%
  summarise(Average_Revenue = mean(Total_Price, na.rm = TRUE),
            Total_Revenue = sum(Total_Price, na.rm = TRUE))

ggplot(discount_revenue, aes(x = Discount, y = Average_Revenue)) +
  geom_line() +
  geom_point() +
  labs(title = "Effect of Discount on Average Revenue",
       x = "Discount Rate",
       y = "Average Revenue")

print("Products with highest discount usage:")

[1] "Products with highest discount usage:"

print(product_discount_usage)

print("Categories with highest discount usage:")

[1] "Categories with highest discount usage:"

print(category_discount_usage)

print("Discount impact on revenue:")

[1] "Discount impact on revenue:"

print(discount_revenue)

png("Products with highest discount usage:", width = 800, height = 400)

G2;H2;Warningh in png("Products with highest discount usage:", width = 800, height = 400) :
  unable to open file 'Products with highest discount usage:' for writingg
G2;H2;Warningh in png("Products with highest discount usage:", width = 800, height = 400) :
  opening device failedg
G1;H1;Errorh in png("Products with highest discount usage:", width = 800, height = 400) : 
  unable to start png() device
Error during wrapup: not that many frames on the stack
Error: no more error handlers available (recursive errors?); invoking 'abort' restart
g

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.