library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.1 ✔ stringr 1.5.2
## ✔ ggplot2 4.0.0 ✔ tibble 3.3.0
## ✔ lubridate 1.9.4 ✔ tidyr 1.3.1
## ✔ purrr 1.1.0
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(lubridate)
bike_data <- read_csv("/Users/zaari/Downloads/bike_orderlines.csv")
## Rows: 15644 Columns: 13
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (7): model, category_1, category_2, frame_material, bikeshop_name, city...
## dbl (5): order_id, order_line, quantity, price, total_price
## dttm (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.
bike_monthly <- bike_data %>%
mutate(order_month = floor_date(order_date, "month")) %>%
group_by(category_2, order_month) %>%
summarize(total_sales = sum(total_price), .groups = "drop")
ggplot(bike_monthly, aes(order_month, total_sales, color = category_2)) +
geom_line(size = 1) +
geom_point(size = 2) +
scale_y_continuous(labels = scales::dollar_format()) +
facet_wrap(~ category_2, scales = "free_y") +
labs(
title = "Monthly Sales by Bike Category",
x = "Month",
y = "Sales"
) +
theme_minimal(base_size = 14) +
theme(legend.position = "none",
strip.text = element_text(face = "bold", size = 10))
## Warning: Using `size` aesthetic for lines was deprecated in ggplot2 3.4.0.
## ℹ Please use `linewidth` instead.
## This warning is displayed once every 8 hours.
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
