How to create multiple line chart in r

Question

I have a data frame in this structure

Date          x1      x2      x3    x4
1/2/2018  500000   10000     10     80000 
1/3/2018  600000   15000     13     70000
1/4/2018  300000   8000      7      40000

How can I create a ggplot line chart with with the 4 x variables in the same chart, also since x3 is so little in respect with the other values it might get lost in the graph is there a trick to deal with this?

Thanks.

Answer 1

First, the dataset.

df1 <- read.table(text = "
Date          x1      x2      x3    x4
1/2/2018  500000   10000     10     80000 
1/3/2018  600000   15000     13     70000
1/4/2018  300000   8000      7      40000                  
", header = TRUE)
df1$Date <- as.Date(df1$Date, "%m/%d/%Y")

The following will plot the three lines using a log10 scale.

library(ggplot2)

long <- reshape2::melt(df1, id.vars = "Date")
ggplot(long, aes(x = Date, y = value, 
                 group = variable, colour = variable)) +
  geom_line() +
  scale_y_log10()