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) %>%
drop_na(.) %>%
group_by(WEEK_END_DATE, CATEGORY) #The graph
ggplot(clean_new_transactions, aes(x = "Months" , y = mean_price )) +
geom_line()
but again it doesn't work..
unfortunately we don't have your data to run your code against.
To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one: