R - Plotting two variables as lines on ggplot 2

Question

I am trying to plot this data frame on one line graph (with points) using ggplot2, i have managed it on excel easy enough but i would like to generate it in R.

Wakatobi <- read.table("Wakatobi SST.txt", header=T)
Wakatobi

Link To Data Frame in R Studio

Link to excel graph

Welcome to stack overflow . please read the following https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example — Nico Coallier, May 24 '17 at 13:51

score 3 · Answer 1 · answered May 24 '17 at 13:55

3

You need to first melt your data using reshape.

df <- data.frame(Month = c("Jan", "Feb", "Mar", "Apr"),
                 Var1 = rnorm(4),
                 Var2 = rnorm(4) + 1)

df2 <- melt(df, id.vars="Month", measure.vars=c("Var1", "Var2"))

ggplot(df2, aes(x=Month, y=value, group=variable, color=variable)) + geom_point() + geom_line()

answered May 24 '17 at 13:55

klumbard

165
1
7

Thanks but i still don't really understand how i translate this to my data frame. – Matt G May 24 '17 at 14:19
Actually figured it out now great thanks. God my R skills are so rusty at the moment. Thanks again! – Matt G May 24 '17 at 14:22

R - Plotting two variables as lines on ggplot 2

1 Answers1