UPDATE: I figured out subset will extract the unique product codes and make a new dataset of the unique product code that will later be turned into a scatter boxplot:
AA22 <- subset(product.sales_tibble,product.sales_tibble$Product.Code=="AA22")
But will I have to make a dataset manually like this for every one of the 15,000 unique product codes I have?!?
Dataset sample:
Product.Code Product.Name Price
AA22 blah1 $2.12
AA22 blah1 $2.42
AA22 blah1 $4.00
BB33 blah2 $5.54
BB33 blah2 $3.42
BB33 blah2 $4.34
CC23 blah3 $100.23
CC23 blah3 $25.23
CC23 blah3 $105.25
Dataset (Tibble): product.sales_tibble
Variable: Product.Code
Variable: Product.Name
Variable: Price
Request for help (anything helps, websites, tutorials, code):
I would like to create individual horizontal scatter boxplots with whiskers for each Product.Code and corresponding prices: (ex. scatter boxplot for AA22's prices)
- average value marked
- prices on the x axis
- Product.Code on the Y axis
- Title "Product. Name"
Model graphs:
http://www.r-graph-gallery.com/89-box-and-scatter-plot-with-ggplot2/
https://www.r-graph-gallery.com/269-ggplot2-boxplot-with-average-value/
BONUS:
-How to create legend for the average dot on the box plot
-How to include descriptive statistics around the box plot (mean, min, high)
-How to include a vertical red line(s) depicting a price(s) derived from API connection and/or regular dataframe/tibble.