Multiple line plot in R from a data frame

Question

I am trying to plot a multiple line graph, with different colors and the legend in R, without much success... I have a data frame named DatProv <- (DatProv$Date, DatProv$Test1, DatProv$Test2, DatProv$Test3) as follows (simplified):

I would like to plot in x-axis the Date (which is in date format %Y-%m-%d, but if possible get the months (feb, mar, apr, may)) against Test1, Test 2 and Test 3 (they are integers).
I tried the ggplot but didn't get at all what I expected which is basically 3 time series showing the evolution of the three tests against the date.

Any help would be much appreciated! Thanks!

Please create a minimum reproducible example: https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example, to allow the community to more easily help — emilliman5, Oct 28 '22 at 13:16

score 1 · Answer 1 · answered Oct 28 '22 at 13:20

Please don't share images of data tables as part of the question. In the future you can use the dput() function to generate a sharable version of your data. For example: dput(DatProv)

Does this code below produce what you're looking for?

library(tidyverse)

DatProv %>%
  pivot_longer(cols = starts_with('Test'),
               names_to = 'Test',
               values_to = 'Value') %>%
  ggplot(aes(lubridate::date(date), Value, color = Test, group = Test)) +
  geom_line() +
  scale_x_date(date_breaks = '1 month',
               date_labels = '%b')

Multiple line plot in R from a data frame

1 Answers1