I have this data set with info about different products such as prices, sales, etc. I want to graphically show hoe prices vary over time with each category being a different line on the same graph. I'm having trouble changing grouping the data by months.
I used this function:
new_transactions <- separate(transactions, WEEK_END_DATE, c("Day", "Month", "Year")
but I'm not sure if it is right and if so how do I plot it with ggplot?
Also, I can't seem to be able to use the mean price for each month, if you can also help me with that
I tried this:
clean_new_transactions <- new_transactions %>%
filter(PRICE != 0) %>%
ggplot(clean_new_transactions, aes(x = "Months" , y = mean_price )) +
but again it doesn't work..
Thank you for the help in advance!