Columns not grouping correctly when plotted in ggplot

Question

I was following the accepted SO answer to get a line graph with 2 lines over multiple years. Can someone explain what I am doing wrong?

temp<-structure(list(Years = c(1950, 1955, 1960, 1965, 1970, 1975, 
                               1980, 1985, 1990, 1995, 2000, 2002, 2005, 2007, 2009, 2011, 2013, 
                               2015, 2017), X1878_8TF = c(4, 5, 10, 20, 15, 22.5, 80, 70, 47.5, 
                                                          47.5, 65, 125, 125, 150, 150, 140, 140, 160, 170), X7_TF_rev_1878 = c(3, 
                                                                                                                                3, 3, 3.75, 6.5, 17, 65, 57.5, 30, 25, 35, 50, 60, 75, 85, 80, 
                                                                                                                                80, 85, 90)), .Names = c("Years", "X1878_8TF", "X7_TF_rev_1878"
                                                                                                                                ), class = "data.frame", row.names = c(NA, -19L))


df <- melt(temp ,  id.vars = 'Years', variable.name = 'coin_name')
ggplot(df, aes(Years,value)) + 
  geom_line(aes(colour = rainbow(nrow(df))))+
  ggtitle("blah")

This is what I get:

Lucy · Accepted Answer · 2017-10-26 23:18:04Z

2

If you just want two lines, I think you want something like:

ggplot(df, aes(Years,value)) +
 geom_line(aes(color = coin_name)) +
 ggtitle("blah")

As you have it, it's trying to make a separate line for every point in your dataset.

answered Oct 26, 2017 at 23:18

Lucy

9917 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Columns not grouping correctly when plotted in ggplot

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related