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?!?
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
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"
-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.