Creating plots [ggplot2] using loop: error `data` must be a data frame
up vote
-2
down vote
favorite
I've tried to create a loop in order to create plots for several countries.
My dataframe: EUETS_UN
Here an excerpt of the data:
year country iso2 sector emissions
1990 Belgium BE ETS 0
1990 Belgium BE Total 120484398
1990 Belgium BE Regulated 78614107
1990 Belgium BE Unregulated 41870292
1991 Belgium BE ETS 0
1991 Belgium BE Total 123544711
1991 Belgium BE Regulated 79811521
1991 Belgium BE Unregulated 43733190
1992 Belgium BE ETS 0
1992 Belgium BE Total 122657813
1992 Belgium BE Regulated 78283962
1992 Belgium BE Unregulated 44373851
1993 Belgium BE ETS 0
1993 Belgium BE Total 121557281
1993 Belgium BE Regulated 76752290
1993 Belgium BE Unregulated 44804991
1994 Belgium BE ETS 0
1994 Belgium BE Total 124938188
1994 Belgium BE Regulated 80647991
1994 Belgium BE Unregulated 44290197
1995 Belgium BE ETS 0
1995 Belgium BE Total 126082961
1995 Belgium BE Regulated 80518704
1995 Belgium BE Unregulated 45564257
1996 Belgium BE ETS 0
1996 Belgium BE Total 129583625
1996 Belgium BE Regulated 79513349
1996 Belgium BE Unregulated 50070276
1997 Belgium BE ETS 0
1997 Belgium BE Total 124046828
1997 Belgium BE Regulated 77308936
1997 Belgium BE Unregulated 46737892
1998 Belgium BE ETS 0
1998 Belgium BE Total 130285109
1998 Belgium BE Regulated 82610050
1998 Belgium BE Unregulated 47675059
1999 Belgium BE ETS 0
1999 Belgium BE Total 124745703
1999 Belgium BE Regulated 77595053
1999 Belgium BE Unregulated 47150650
2000 Belgium BE ETS 0
2000 Belgium BE Total 126794789
2000 Belgium BE Regulated 80435088
2000 Belgium BE Unregulated 46359701
2001 Belgium BE ETS 0
2001 Belgium BE Total 126129008
2001 Belgium BE Regulated 77255899
2001 Belgium BE Unregulated 48873109
2002 Belgium BE ETS 0
2002 Belgium BE Total 126444625
2002 Belgium BE Regulated 77914653
2002 Belgium BE Unregulated 48529972
2003 Belgium BE ETS 0
2003 Belgium BE Total 127953188
2003 Belgium BE Regulated 78464806
2003 Belgium BE Unregulated 49488382
2004 Belgium BE ETS 0
2004 Belgium BE Total 129040883
2004 Belgium BE Regulated 79430967
2004 Belgium BE Unregulated 49609916
2005 Belgium BE ETS 55363232
2005 Belgium BE Total 125638203
2005 Belgium BE Regulated 77343444
2005 Belgium BE Unregulated 48294759
2006 Belgium BE ETS 54775328
2006 Belgium BE Total 124030891
2006 Belgium BE Regulated 75869846
2006 Belgium BE Unregulated 48161044
2007 Belgium BE ETS 52795332
2007 Belgium BE Total 120611398
2007 Belgium BE Regulated 73189198
2007 Belgium BE Unregulated 47422201
2008 Belgium BE ETS 55462028
2008 Belgium BE Total 120659008
2008 Belgium BE Regulated 71854823
2008 Belgium BE Unregulated 48804185
2009 Belgium BE ETS 46206936
2009 Belgium BE Total 107642367
2009 Belgium BE Regulated 61048912
2009 Belgium BE Unregulated 46593455
2010 Belgium BE ETS 50103980
2010 Belgium BE Total 113582031
2010 Belgium BE Regulated 66648934
2010 Belgium BE Unregulated 46933097
2011 Belgium BE ETS 46203056
2011 Belgium BE Total 104158641
2011 Belgium BE Regulated 61319344
2011 Belgium BE Unregulated 42839297
2012 Belgium BE ETS 43006980
2012 Belgium BE Total 101394977
2012 Belgium BE Regulated 58934979
2012 Belgium BE Unregulated 42459997
2013 Belgium BE ETS 45231176
2013 Belgium BE Total 101970445
2013 Belgium BE Regulated 58383554
2013 Belgium BE Unregulated 43586891
2014 Belgium BE ETS 43853144
2014 Belgium BE Total 96391039
2014 Belgium BE Regulated 56010346
2014 Belgium BE Unregulated 40380694
2015 Belgium BE ETS 44713916
2015 Belgium BE Total 100229492
2015 Belgium BE Regulated 57375031
2015 Belgium BE Unregulated 42854461
2016 Belgium BE ETS 43655728
2016 Belgium BE Total 100243711
2016 Belgium BE Regulated 56702848
2016 Belgium BE Unregulated 43540863
I have only shown the whole data for one country, since every country looks the same (apart from different figures EUETS_UN$emissions)
What I want to do is (most you will see from my code below):
- create loop, so plots will be created for all countries
- x axis = year; y=emissions (of a country as in
EUETS_UN$iso2
- 3 groups (curves) should be from
EUETS_UN$sector: Regulated, Unregulated, ETS - Regulated and unregulated should be between 1990:2016; ETS between 2005:2017. This years are the years with data availability
This is what I tried:
# Sets up the loop to run from i=1 through a list of countries from vector
'iso2'
for(i in (1:length(EUETS_UN$iso2))){
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot() +
geom_line(EUETS_UN$emissions,aes(x=year,y=emissions,group=sector),
color=cols[1]) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",iso2[i])) +
xlim(1990,max(year.aux)) +
ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm"))
p
# Save plot, where the file name automatically gets a country name suffix
ggsave(p,filename=paste("./FILENAME",iso2[i],".png",sep=""),width=6.5,
height=6)
}
However, I'm getting this "Error: data must be a data frame, or other object coercible by fortify(), not an S3 object with class uneval
Did you accidentally pass aes() to the data argument?"
Any idea how I could run the loop to create the plots?
Thanks in any case!
Nordsee
r loops ggplot2
asked Nov 10 at 8:52
Nordsee
465
|
show 4 more comments
up vote
-2
down vote
favorite
I've tried to create a loop in order to create plots for several countries.
My dataframe: EUETS_UN
Here an excerpt of the data:
year country iso2 sector emissions
1990 Belgium BE ETS 0
1990 Belgium BE Total 120484398
1990 Belgium BE Regulated 78614107
1990 Belgium BE Unregulated 41870292
1991 Belgium BE ETS 0
1991 Belgium BE Total 123544711
1991 Belgium BE Regulated 79811521
1991 Belgium BE Unregulated 43733190
1992 Belgium BE ETS 0
1992 Belgium BE Total 122657813
1992 Belgium BE Regulated 78283962
1992 Belgium BE Unregulated 44373851
1993 Belgium BE ETS 0
1993 Belgium BE Total 121557281
1993 Belgium BE Regulated 76752290
1993 Belgium BE Unregulated 44804991
1994 Belgium BE ETS 0
1994 Belgium BE Total 124938188
1994 Belgium BE Regulated 80647991
1994 Belgium BE Unregulated 44290197
1995 Belgium BE ETS 0
1995 Belgium BE Total 126082961
1995 Belgium BE Regulated 80518704
1995 Belgium BE Unregulated 45564257
1996 Belgium BE ETS 0
1996 Belgium BE Total 129583625
1996 Belgium BE Regulated 79513349
1996 Belgium BE Unregulated 50070276
1997 Belgium BE ETS 0
1997 Belgium BE Total 124046828
1997 Belgium BE Regulated 77308936
1997 Belgium BE Unregulated 46737892
1998 Belgium BE ETS 0
1998 Belgium BE Total 130285109
1998 Belgium BE Regulated 82610050
1998 Belgium BE Unregulated 47675059
1999 Belgium BE ETS 0
1999 Belgium BE Total 124745703
1999 Belgium BE Regulated 77595053
1999 Belgium BE Unregulated 47150650
2000 Belgium BE ETS 0
2000 Belgium BE Total 126794789
2000 Belgium BE Regulated 80435088
2000 Belgium BE Unregulated 46359701
2001 Belgium BE ETS 0
2001 Belgium BE Total 126129008
2001 Belgium BE Regulated 77255899
2001 Belgium BE Unregulated 48873109
2002 Belgium BE ETS 0
2002 Belgium BE Total 126444625
2002 Belgium BE Regulated 77914653
2002 Belgium BE Unregulated 48529972
2003 Belgium BE ETS 0
2003 Belgium BE Total 127953188
2003 Belgium BE Regulated 78464806
2003 Belgium BE Unregulated 49488382
2004 Belgium BE ETS 0
2004 Belgium BE Total 129040883
2004 Belgium BE Regulated 79430967
2004 Belgium BE Unregulated 49609916
2005 Belgium BE ETS 55363232
2005 Belgium BE Total 125638203
2005 Belgium BE Regulated 77343444
2005 Belgium BE Unregulated 48294759
2006 Belgium BE ETS 54775328
2006 Belgium BE Total 124030891
2006 Belgium BE Regulated 75869846
2006 Belgium BE Unregulated 48161044
2007 Belgium BE ETS 52795332
2007 Belgium BE Total 120611398
2007 Belgium BE Regulated 73189198
2007 Belgium BE Unregulated 47422201
2008 Belgium BE ETS 55462028
2008 Belgium BE Total 120659008
2008 Belgium BE Regulated 71854823
2008 Belgium BE Unregulated 48804185
2009 Belgium BE ETS 46206936
2009 Belgium BE Total 107642367
2009 Belgium BE Regulated 61048912
2009 Belgium BE Unregulated 46593455
2010 Belgium BE ETS 50103980
2010 Belgium BE Total 113582031
2010 Belgium BE Regulated 66648934
2010 Belgium BE Unregulated 46933097
2011 Belgium BE ETS 46203056
2011 Belgium BE Total 104158641
2011 Belgium BE Regulated 61319344
2011 Belgium BE Unregulated 42839297
2012 Belgium BE ETS 43006980
2012 Belgium BE Total 101394977
2012 Belgium BE Regulated 58934979
2012 Belgium BE Unregulated 42459997
2013 Belgium BE ETS 45231176
2013 Belgium BE Total 101970445
2013 Belgium BE Regulated 58383554
2013 Belgium BE Unregulated 43586891
2014 Belgium BE ETS 43853144
2014 Belgium BE Total 96391039
2014 Belgium BE Regulated 56010346
2014 Belgium BE Unregulated 40380694
2015 Belgium BE ETS 44713916
2015 Belgium BE Total 100229492
2015 Belgium BE Regulated 57375031
2015 Belgium BE Unregulated 42854461
2016 Belgium BE ETS 43655728
2016 Belgium BE Total 100243711
2016 Belgium BE Regulated 56702848
2016 Belgium BE Unregulated 43540863
I have only shown the whole data for one country, since every country looks the same (apart from different figures EUETS_UN$emissions)
What I want to do is (most you will see from my code below):
- create loop, so plots will be created for all countries
- x axis = year; y=emissions (of a country as in
EUETS_UN$iso2
- 3 groups (curves) should be from
EUETS_UN$sector: Regulated, Unregulated, ETS - Regulated and unregulated should be between 1990:2016; ETS between 2005:2017. This years are the years with data availability
This is what I tried:
# Sets up the loop to run from i=1 through a list of countries from vector
'iso2'
for(i in (1:length(EUETS_UN$iso2))){
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot() +
geom_line(EUETS_UN$emissions,aes(x=year,y=emissions,group=sector),
color=cols[1]) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",iso2[i])) +
xlim(1990,max(year.aux)) +
ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm"))
p
# Save plot, where the file name automatically gets a country name suffix
ggsave(p,filename=paste("./FILENAME",iso2[i],".png",sep=""),width=6.5,
height=6)
}
However, I'm getting this "Error: data must be a data frame, or other object coercible by fortify(), not an S3 object with class uneval
Did you accidentally pass aes() to the data argument?"
Any idea how I could run the loop to create the plots?
Thanks in any case!
Nordsee
r loops ggplot2
asked Nov 10 at 8:52
Nordsee
465
1
Seems you've referenced just a column, try...+ geom_line(EUETS_UN, aes(x=year,y=emissions,group=sector) +....
– jay.sf
Nov 10 at 8:56
Thank you for this, but unfortunately I'm still getting the same error
– Nordsee
Nov 10 at 9:01
Thecolor=cols[1]should also be included into theaes(), And specify thedataargument explicitly:ggplot() + geom_line(data=EUETS_UN, aes(x=year, y=emissions, group=sector, color=cols[1]))
– jay.sf
Nov 10 at 9:16
same error, this also still includes the sector "total"
– Nordsee
Nov 10 at 9:19
2
Then have a good look at those links here: stackoverflow.com/help/mcve stackoverflow.com/questions/5963269/…
– Tjebo
Nov 10 at 13:45
|
show 4 more comments
up vote
-2
down vote
favorite
up vote
-2
down vote
favorite
I've tried to create a loop in order to create plots for several countries.
My dataframe: EUETS_UN
Here an excerpt of the data:
year country iso2 sector emissions
1990 Belgium BE ETS 0
1990 Belgium BE Total 120484398
1990 Belgium BE Regulated 78614107
1990 Belgium BE Unregulated 41870292
1991 Belgium BE ETS 0
1991 Belgium BE Total 123544711
1991 Belgium BE Regulated 79811521
1991 Belgium BE Unregulated 43733190
1992 Belgium BE ETS 0
1992 Belgium BE Total 122657813
1992 Belgium BE Regulated 78283962
1992 Belgium BE Unregulated 44373851
1993 Belgium BE ETS 0
1993 Belgium BE Total 121557281
1993 Belgium BE Regulated 76752290
1993 Belgium BE Unregulated 44804991
1994 Belgium BE ETS 0
1994 Belgium BE Total 124938188
1994 Belgium BE Regulated 80647991
1994 Belgium BE Unregulated 44290197
1995 Belgium BE ETS 0
1995 Belgium BE Total 126082961
1995 Belgium BE Regulated 80518704
1995 Belgium BE Unregulated 45564257
1996 Belgium BE ETS 0
1996 Belgium BE Total 129583625
1996 Belgium BE Regulated 79513349
1996 Belgium BE Unregulated 50070276
1997 Belgium BE ETS 0
1997 Belgium BE Total 124046828
1997 Belgium BE Regulated 77308936
1997 Belgium BE Unregulated 46737892
1998 Belgium BE ETS 0
1998 Belgium BE Total 130285109
1998 Belgium BE Regulated 82610050
1998 Belgium BE Unregulated 47675059
1999 Belgium BE ETS 0
1999 Belgium BE Total 124745703
1999 Belgium BE Regulated 77595053
1999 Belgium BE Unregulated 47150650
2000 Belgium BE ETS 0
2000 Belgium BE Total 126794789
2000 Belgium BE Regulated 80435088
2000 Belgium BE Unregulated 46359701
2001 Belgium BE ETS 0
2001 Belgium BE Total 126129008
2001 Belgium BE Regulated 77255899
2001 Belgium BE Unregulated 48873109
2002 Belgium BE ETS 0
2002 Belgium BE Total 126444625
2002 Belgium BE Regulated 77914653
2002 Belgium BE Unregulated 48529972
2003 Belgium BE ETS 0
2003 Belgium BE Total 127953188
2003 Belgium BE Regulated 78464806
2003 Belgium BE Unregulated 49488382
2004 Belgium BE ETS 0
2004 Belgium BE Total 129040883
2004 Belgium BE Regulated 79430967
2004 Belgium BE Unregulated 49609916
2005 Belgium BE ETS 55363232
2005 Belgium BE Total 125638203
2005 Belgium BE Regulated 77343444
2005 Belgium BE Unregulated 48294759
2006 Belgium BE ETS 54775328
2006 Belgium BE Total 124030891
2006 Belgium BE Regulated 75869846
2006 Belgium BE Unregulated 48161044
2007 Belgium BE ETS 52795332
2007 Belgium BE Total 120611398
2007 Belgium BE Regulated 73189198
2007 Belgium BE Unregulated 47422201
2008 Belgium BE ETS 55462028
2008 Belgium BE Total 120659008
2008 Belgium BE Regulated 71854823
2008 Belgium BE Unregulated 48804185
2009 Belgium BE ETS 46206936
2009 Belgium BE Total 107642367
2009 Belgium BE Regulated 61048912
2009 Belgium BE Unregulated 46593455
2010 Belgium BE ETS 50103980
2010 Belgium BE Total 113582031
2010 Belgium BE Regulated 66648934
2010 Belgium BE Unregulated 46933097
2011 Belgium BE ETS 46203056
2011 Belgium BE Total 104158641
2011 Belgium BE Regulated 61319344
2011 Belgium BE Unregulated 42839297
2012 Belgium BE ETS 43006980
2012 Belgium BE Total 101394977
2012 Belgium BE Regulated 58934979
2012 Belgium BE Unregulated 42459997
2013 Belgium BE ETS 45231176
2013 Belgium BE Total 101970445
2013 Belgium BE Regulated 58383554
2013 Belgium BE Unregulated 43586891
2014 Belgium BE ETS 43853144
2014 Belgium BE Total 96391039
2014 Belgium BE Regulated 56010346
2014 Belgium BE Unregulated 40380694
2015 Belgium BE ETS 44713916
2015 Belgium BE Total 100229492
2015 Belgium BE Regulated 57375031
2015 Belgium BE Unregulated 42854461
2016 Belgium BE ETS 43655728
2016 Belgium BE Total 100243711
2016 Belgium BE Regulated 56702848
2016 Belgium BE Unregulated 43540863
I have only shown the whole data for one country, since every country looks the same (apart from different figures EUETS_UN$emissions)
What I want to do is (most you will see from my code below):
- create loop, so plots will be created for all countries
- x axis = year; y=emissions (of a country as in
EUETS_UN$iso2
- 3 groups (curves) should be from
EUETS_UN$sector: Regulated, Unregulated, ETS - Regulated and unregulated should be between 1990:2016; ETS between 2005:2017. This years are the years with data availability
This is what I tried:
# Sets up the loop to run from i=1 through a list of countries from vector
'iso2'
for(i in (1:length(EUETS_UN$iso2))){
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot() +
geom_line(EUETS_UN$emissions,aes(x=year,y=emissions,group=sector),
color=cols[1]) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",iso2[i])) +
xlim(1990,max(year.aux)) +
ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm"))
p
# Save plot, where the file name automatically gets a country name suffix
ggsave(p,filename=paste("./FILENAME",iso2[i],".png",sep=""),width=6.5,
height=6)
}
However, I'm getting this "Error: data must be a data frame, or other object coercible by fortify(), not an S3 object with class uneval
Did you accidentally pass aes() to the data argument?"
Any idea how I could run the loop to create the plots?
Thanks in any case!
Nordsee
r loops ggplot2
asked Nov 10 at 8:52
Nordsee
465
I've tried to create a loop in order to create plots for several countries.
My dataframe: EUETS_UN
Here an excerpt of the data:
year country iso2 sector emissions
1990 Belgium BE ETS 0
1990 Belgium BE Total 120484398
1990 Belgium BE Regulated 78614107
1990 Belgium BE Unregulated 41870292
1991 Belgium BE ETS 0
1991 Belgium BE Total 123544711
1991 Belgium BE Regulated 79811521
1991 Belgium BE Unregulated 43733190
1992 Belgium BE ETS 0
1992 Belgium BE Total 122657813
1992 Belgium BE Regulated 78283962
1992 Belgium BE Unregulated 44373851
1993 Belgium BE ETS 0
1993 Belgium BE Total 121557281
1993 Belgium BE Regulated 76752290
1993 Belgium BE Unregulated 44804991
1994 Belgium BE ETS 0
1994 Belgium BE Total 124938188
1994 Belgium BE Regulated 80647991
1994 Belgium BE Unregulated 44290197
1995 Belgium BE ETS 0
1995 Belgium BE Total 126082961
1995 Belgium BE Regulated 80518704
1995 Belgium BE Unregulated 45564257
1996 Belgium BE ETS 0
1996 Belgium BE Total 129583625
1996 Belgium BE Regulated 79513349
1996 Belgium BE Unregulated 50070276
1997 Belgium BE ETS 0
1997 Belgium BE Total 124046828
1997 Belgium BE Regulated 77308936
1997 Belgium BE Unregulated 46737892
1998 Belgium BE ETS 0
1998 Belgium BE Total 130285109
1998 Belgium BE Regulated 82610050
1998 Belgium BE Unregulated 47675059
1999 Belgium BE ETS 0
1999 Belgium BE Total 124745703
1999 Belgium BE Regulated 77595053
1999 Belgium BE Unregulated 47150650
2000 Belgium BE ETS 0
2000 Belgium BE Total 126794789
2000 Belgium BE Regulated 80435088
2000 Belgium BE Unregulated 46359701
2001 Belgium BE ETS 0
2001 Belgium BE Total 126129008
2001 Belgium BE Regulated 77255899
2001 Belgium BE Unregulated 48873109
2002 Belgium BE ETS 0
2002 Belgium BE Total 126444625
2002 Belgium BE Regulated 77914653
2002 Belgium BE Unregulated 48529972
2003 Belgium BE ETS 0
2003 Belgium BE Total 127953188
2003 Belgium BE Regulated 78464806
2003 Belgium BE Unregulated 49488382
2004 Belgium BE ETS 0
2004 Belgium BE Total 129040883
2004 Belgium BE Regulated 79430967
2004 Belgium BE Unregulated 49609916
2005 Belgium BE ETS 55363232
2005 Belgium BE Total 125638203
2005 Belgium BE Regulated 77343444
2005 Belgium BE Unregulated 48294759
2006 Belgium BE ETS 54775328
2006 Belgium BE Total 124030891
2006 Belgium BE Regulated 75869846
2006 Belgium BE Unregulated 48161044
2007 Belgium BE ETS 52795332
2007 Belgium BE Total 120611398
2007 Belgium BE Regulated 73189198
2007 Belgium BE Unregulated 47422201
2008 Belgium BE ETS 55462028
2008 Belgium BE Total 120659008
2008 Belgium BE Regulated 71854823
2008 Belgium BE Unregulated 48804185
2009 Belgium BE ETS 46206936
2009 Belgium BE Total 107642367
2009 Belgium BE Regulated 61048912
2009 Belgium BE Unregulated 46593455
2010 Belgium BE ETS 50103980
2010 Belgium BE Total 113582031
2010 Belgium BE Regulated 66648934
2010 Belgium BE Unregulated 46933097
2011 Belgium BE ETS 46203056
2011 Belgium BE Total 104158641
2011 Belgium BE Regulated 61319344
2011 Belgium BE Unregulated 42839297
2012 Belgium BE ETS 43006980
2012 Belgium BE Total 101394977
2012 Belgium BE Regulated 58934979
2012 Belgium BE Unregulated 42459997
2013 Belgium BE ETS 45231176
2013 Belgium BE Total 101970445
2013 Belgium BE Regulated 58383554
2013 Belgium BE Unregulated 43586891
2014 Belgium BE ETS 43853144
2014 Belgium BE Total 96391039
2014 Belgium BE Regulated 56010346
2014 Belgium BE Unregulated 40380694
2015 Belgium BE ETS 44713916
2015 Belgium BE Total 100229492
2015 Belgium BE Regulated 57375031
2015 Belgium BE Unregulated 42854461
2016 Belgium BE ETS 43655728
2016 Belgium BE Total 100243711
2016 Belgium BE Regulated 56702848
2016 Belgium BE Unregulated 43540863
I have only shown the whole data for one country, since every country looks the same (apart from different figures EUETS_UN$emissions)
What I want to do is (most you will see from my code below):
- create loop, so plots will be created for all countries
- x axis = year; y=emissions (of a country as in
EUETS_UN$iso2
- 3 groups (curves) should be from
EUETS_UN$sector: Regulated, Unregulated, ETS - Regulated and unregulated should be between 1990:2016; ETS between 2005:2017. This years are the years with data availability
This is what I tried:
# Sets up the loop to run from i=1 through a list of countries from vector
'iso2'
for(i in (1:length(EUETS_UN$iso2))){
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot() +
geom_line(EUETS_UN$emissions,aes(x=year,y=emissions,group=sector),
color=cols[1]) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",iso2[i])) +
xlim(1990,max(year.aux)) +
ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm"))
p
# Save plot, where the file name automatically gets a country name suffix
ggsave(p,filename=paste("./FILENAME",iso2[i],".png",sep=""),width=6.5,
height=6)
}
However, I'm getting this "Error: data must be a data frame, or other object coercible by fortify(), not an S3 object with class uneval
Did you accidentally pass aes() to the data argument?"
Any idea how I could run the loop to create the plots?
Thanks in any case!
Nordsee
r loops ggplot2
r loops ggplot2
asked Nov 10 at 8:52
Nordsee
465
asked Nov 10 at 8:52
Nordsee
465
edited Nov 10 at 12:18
asked Nov 10 at 8:52
Nordsee
465
asked Nov 10 at 8:52
Nordsee
465
asked Nov 10 at 8:52
Nordsee
465
465
1
Seems you've referenced just a column, try...+ geom_line(EUETS_UN, aes(x=year,y=emissions,group=sector) +....
– jay.sf
Nov 10 at 8:56
Thank you for this, but unfortunately I'm still getting the same error
– Nordsee
Nov 10 at 9:01
Thecolor=cols[1]should also be included into theaes(), And specify thedataargument explicitly:ggplot() + geom_line(data=EUETS_UN, aes(x=year, y=emissions, group=sector, color=cols[1]))
– jay.sf
Nov 10 at 9:16
same error, this also still includes the sector "total"
– Nordsee
Nov 10 at 9:19
2
Then have a good look at those links here: stackoverflow.com/help/mcve stackoverflow.com/questions/5963269/…
– Tjebo
Nov 10 at 13:45
|
show 4 more comments
1
Seems you've referenced just a column, try...+ geom_line(EUETS_UN, aes(x=year,y=emissions,group=sector) +....
– jay.sf
Nov 10 at 8:56
Thank you for this, but unfortunately I'm still getting the same error
– Nordsee
Nov 10 at 9:01
Thecolor=cols[1]should also be included into theaes(), And specify thedataargument explicitly:ggplot() + geom_line(data=EUETS_UN, aes(x=year, y=emissions, group=sector, color=cols[1]))
– jay.sf
Nov 10 at 9:16
same error, this also still includes the sector "total"
– Nordsee
Nov 10 at 9:19
2
Then have a good look at those links here: stackoverflow.com/help/mcve stackoverflow.com/questions/5963269/…
– Tjebo
Nov 10 at 13:45
1
1
Seems you've referenced just a column, try
...+ geom_line(EUETS_UN, aes(x=year,y=emissions,group=sector) +....– jay.sf
Nov 10 at 8:56
Seems you've referenced just a column, try
...+ geom_line(EUETS_UN, aes(x=year,y=emissions,group=sector) +....– jay.sf
Nov 10 at 8:56
Thank you for this, but unfortunately I'm still getting the same error
– Nordsee
Nov 10 at 9:01
Thank you for this, but unfortunately I'm still getting the same error
– Nordsee
Nov 10 at 9:01
The
color=cols[1] should also be included into the aes(), And specify the data argument explicitly: ggplot() + geom_line(data=EUETS_UN, aes(x=year, y=emissions, group=sector, color=cols[1]))– jay.sf
Nov 10 at 9:16
The
color=cols[1] should also be included into the aes(), And specify the data argument explicitly: ggplot() + geom_line(data=EUETS_UN, aes(x=year, y=emissions, group=sector, color=cols[1]))– jay.sf
Nov 10 at 9:16
same error, this also still includes the sector "total"
– Nordsee
Nov 10 at 9:19
same error, this also still includes the sector "total"
– Nordsee
Nov 10 at 9:19
2
2
Then have a good look at those links here: stackoverflow.com/help/mcve stackoverflow.com/questions/5963269/…
– Tjebo
Nov 10 at 13:45
Then have a good look at those links here: stackoverflow.com/help/mcve stackoverflow.com/questions/5963269/…
– Tjebo
Nov 10 at 13:45
|
show 4 more comments
1 Answer
1
active
oldest
votes
up vote
3
down vote
accepted
Try this:
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
iso_2s <- unique(EUETS_UN$iso2)
for(i in iso_2s) {
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
df_to_plot <- subset(EUETS_UN, iso2 == i)
df_to_plot <- df_to_plot[df_to_plot$sector != "Total"]
df_to_plot$sector <- as.character(df_to_plot$sector)
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot(df_to_plot) +
geom_line(aes(x= year,y= emissions,group = sector, color = sector)) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",i)) +
xlim(1990,max(df_to_plot$year)) +
#ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm")) +
scale_color_manual(values = cols)
print(p)
ggsave(p,filename=paste("./FILENAME",i,".png",sep=""),width=6.5,
height=6)
}
This is what I get from your test example:
You may also want to disable scientific notation on y axis. In this case, just add + scale_y_continuous(labels = scales::comma) after the last ggplot statement, i.e. after scale_color_manual(values = cols) in this case. You'd then get:
I've also checked with adding artificially another country, and the loop produces 2 charts as desired.
answered Nov 10 at 9:06
arg0naut
1,712312
Thank you, but in your solution a wide range of rows has been removed, as not all rows contain data (data availability for Regulated & Unregulated is different than for ETS). The legend of the graph also contains a curve for "total" which was supposed to be excluded
– Nordsee
Nov 10 at 9:11
"Error in paste("./FILENAME", iso2[i], ".png", sep = "") : object 'iso2' not found In addition: Warning message: Removed 94 rows containing missing values (geom_path). "
– Nordsee
Nov 10 at 9:12
The solution now excludes Total as well as corrects the error in ggsave. For the removal of rows, unfortunately I cannot really know what is causing it & how it should be corrected. It would helpful if you provide a more comprehensive test data and also indicate which rows should not be removed.
– arg0naut
Nov 10 at 9:23
Thank you, I've just ran your code. However, there are no curves on the plots and total is still included, but the loop works. Row are still removed, which may be a result due to varying data availability for the years (Regulated and unregulated 1990:2016; ETS 2005:2017). The curves should just go as the data is available (start/end). How can I provide you with more test data?
– Nordsee
Nov 10 at 9:28
I've modified the code; I think total was still included because your sector variable is a factor - I've changed that to character and it should work. For the test data, I think it would be helpful if the data is more representative of what you have (more data points [years and sectors] essentially, perhaps for just 2 countries would be enough). Perhaps setting the x and y limits is the problem, or you don't have enough variability in the data, or something else.
– arg0naut
Nov 10 at 9:34
|
show 6 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53237410%2fcreating-plots-ggplot2-using-loop-error-data-must-be-a-data-frame%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
3
down vote
accepted
Try this:
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
iso_2s <- unique(EUETS_UN$iso2)
for(i in iso_2s) {
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
df_to_plot <- subset(EUETS_UN, iso2 == i)
df_to_plot <- df_to_plot[df_to_plot$sector != "Total"]
df_to_plot$sector <- as.character(df_to_plot$sector)
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot(df_to_plot) +
geom_line(aes(x= year,y= emissions,group = sector, color = sector)) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",i)) +
xlim(1990,max(df_to_plot$year)) +
#ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm")) +
scale_color_manual(values = cols)
print(p)
ggsave(p,filename=paste("./FILENAME",i,".png",sep=""),width=6.5,
height=6)
}
This is what I get from your test example:
You may also want to disable scientific notation on y axis. In this case, just add + scale_y_continuous(labels = scales::comma) after the last ggplot statement, i.e. after scale_color_manual(values = cols) in this case. You'd then get:
I've also checked with adding artificially another country, and the loop produces 2 charts as desired.
answered Nov 10 at 9:06
arg0naut
1,712312
Thank you, but in your solution a wide range of rows has been removed, as not all rows contain data (data availability for Regulated & Unregulated is different than for ETS). The legend of the graph also contains a curve for "total" which was supposed to be excluded
– Nordsee
Nov 10 at 9:11
"Error in paste("./FILENAME", iso2[i], ".png", sep = "") : object 'iso2' not found In addition: Warning message: Removed 94 rows containing missing values (geom_path). "
– Nordsee
Nov 10 at 9:12
The solution now excludes Total as well as corrects the error in ggsave. For the removal of rows, unfortunately I cannot really know what is causing it & how it should be corrected. It would helpful if you provide a more comprehensive test data and also indicate which rows should not be removed.
– arg0naut
Nov 10 at 9:23
Thank you, I've just ran your code. However, there are no curves on the plots and total is still included, but the loop works. Row are still removed, which may be a result due to varying data availability for the years (Regulated and unregulated 1990:2016; ETS 2005:2017). The curves should just go as the data is available (start/end). How can I provide you with more test data?
– Nordsee
Nov 10 at 9:28
I've modified the code; I think total was still included because your sector variable is a factor - I've changed that to character and it should work. For the test data, I think it would be helpful if the data is more representative of what you have (more data points [years and sectors] essentially, perhaps for just 2 countries would be enough). Perhaps setting the x and y limits is the problem, or you don't have enough variability in the data, or something else.
– arg0naut
Nov 10 at 9:34
|
show 6 more comments
up vote
3
down vote
accepted
Try this:
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
iso_2s <- unique(EUETS_UN$iso2)
for(i in iso_2s) {
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
df_to_plot <- subset(EUETS_UN, iso2 == i)
df_to_plot <- df_to_plot[df_to_plot$sector != "Total"]
df_to_plot$sector <- as.character(df_to_plot$sector)
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot(df_to_plot) +
geom_line(aes(x= year,y= emissions,group = sector, color = sector)) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",i)) +
xlim(1990,max(df_to_plot$year)) +
#ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm")) +
scale_color_manual(values = cols)
print(p)
ggsave(p,filename=paste("./FILENAME",i,".png",sep=""),width=6.5,
height=6)
}
This is what I get from your test example:
You may also want to disable scientific notation on y axis. In this case, just add + scale_y_continuous(labels = scales::comma) after the last ggplot statement, i.e. after scale_color_manual(values = cols) in this case. You'd then get:
I've also checked with adding artificially another country, and the loop produces 2 charts as desired.
answered Nov 10 at 9:06
arg0naut
1,712312
Thank you, but in your solution a wide range of rows has been removed, as not all rows contain data (data availability for Regulated & Unregulated is different than for ETS). The legend of the graph also contains a curve for "total" which was supposed to be excluded
– Nordsee
Nov 10 at 9:11
"Error in paste("./FILENAME", iso2[i], ".png", sep = "") : object 'iso2' not found In addition: Warning message: Removed 94 rows containing missing values (geom_path). "
– Nordsee
Nov 10 at 9:12
The solution now excludes Total as well as corrects the error in ggsave. For the removal of rows, unfortunately I cannot really know what is causing it & how it should be corrected. It would helpful if you provide a more comprehensive test data and also indicate which rows should not be removed.
– arg0naut
Nov 10 at 9:23
Thank you, I've just ran your code. However, there are no curves on the plots and total is still included, but the loop works. Row are still removed, which may be a result due to varying data availability for the years (Regulated and unregulated 1990:2016; ETS 2005:2017). The curves should just go as the data is available (start/end). How can I provide you with more test data?
– Nordsee
Nov 10 at 9:28
I've modified the code; I think total was still included because your sector variable is a factor - I've changed that to character and it should work. For the test data, I think it would be helpful if the data is more representative of what you have (more data points [years and sectors] essentially, perhaps for just 2 countries would be enough). Perhaps setting the x and y limits is the problem, or you don't have enough variability in the data, or something else.
– arg0naut
Nov 10 at 9:34
|
show 6 more comments
up vote
3
down vote
accepted
up vote
3
down vote
accepted
Try this:
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
iso_2s <- unique(EUETS_UN$iso2)
for(i in iso_2s) {
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
df_to_plot <- subset(EUETS_UN, iso2 == i)
df_to_plot <- df_to_plot[df_to_plot$sector != "Total"]
df_to_plot$sector <- as.character(df_to_plot$sector)
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot(df_to_plot) +
geom_line(aes(x= year,y= emissions,group = sector, color = sector)) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",i)) +
xlim(1990,max(df_to_plot$year)) +
#ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm")) +
scale_color_manual(values = cols)
print(p)
ggsave(p,filename=paste("./FILENAME",i,".png",sep=""),width=6.5,
height=6)
}
This is what I get from your test example:
You may also want to disable scientific notation on y axis. In this case, just add + scale_y_continuous(labels = scales::comma) after the last ggplot statement, i.e. after scale_color_manual(values = cols) in this case. You'd then get:
I've also checked with adding artificially another country, and the loop produces 2 charts as desired.
answered Nov 10 at 9:06
arg0naut
1,712312
Try this:
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
iso_2s <- unique(EUETS_UN$iso2)
for(i in iso_2s) {
# Color settings: colorblind-friendly palette
cols <- c("#999999", "#E69F00", "#56B4E9", "#009E73", "#F0E442", "#0072B2",
"#D55E00", "#CC79A7")
df_to_plot <- subset(EUETS_UN, iso2 == i)
df_to_plot <- df_to_plot[df_to_plot$sector != "Total"]
df_to_plot$sector <- as.character(df_to_plot$sector)
# Plotting code where DATA, YEAR, etc need to be handed the right vectors
p <- ggplot(df_to_plot) +
geom_line(aes(x= year,y= emissions,group = sector, color = sector)) +
labs(x="Year",y="CO2 emissions",z="",title=paste("TITLE for",i)) +
xlim(1990,max(df_to_plot$year)) +
#ylim(-50,50) +
theme(plot.margin=unit(c(.5,.5,.5,.5),"cm")) +
scale_color_manual(values = cols)
print(p)
ggsave(p,filename=paste("./FILENAME",i,".png",sep=""),width=6.5,
height=6)
}
This is what I get from your test example:
You may also want to disable scientific notation on y axis. In this case, just add + scale_y_continuous(labels = scales::comma) after the last ggplot statement, i.e. after scale_color_manual(values = cols) in this case. You'd then get:
I've also checked with adding artificially another country, and the loop produces 2 charts as desired.
answered Nov 10 at 9:06
arg0naut
1,712312
edited Nov 10 at 14:32
answered Nov 10 at 9:06
arg0naut
1,712312
answered Nov 10 at 9:06
arg0naut
1,712312
answered Nov 10 at 9:06
arg0naut
1,712312
1,712312
Thank you, but in your solution a wide range of rows has been removed, as not all rows contain data (data availability for Regulated & Unregulated is different than for ETS). The legend of the graph also contains a curve for "total" which was supposed to be excluded
– Nordsee
Nov 10 at 9:11
"Error in paste("./FILENAME", iso2[i], ".png", sep = "") : object 'iso2' not found In addition: Warning message: Removed 94 rows containing missing values (geom_path). "
– Nordsee
Nov 10 at 9:12
The solution now excludes Total as well as corrects the error in ggsave. For the removal of rows, unfortunately I cannot really know what is causing it & how it should be corrected. It would helpful if you provide a more comprehensive test data and also indicate which rows should not be removed.
– arg0naut
Nov 10 at 9:23
Thank you, I've just ran your code. However, there are no curves on the plots and total is still included, but the loop works. Row are still removed, which may be a result due to varying data availability for the years (Regulated and unregulated 1990:2016; ETS 2005:2017). The curves should just go as the data is available (start/end). How can I provide you with more test data?
– Nordsee
Nov 10 at 9:28
I've modified the code; I think total was still included because your sector variable is a factor - I've changed that to character and it should work. For the test data, I think it would be helpful if the data is more representative of what you have (more data points [years and sectors] essentially, perhaps for just 2 countries would be enough). Perhaps setting the x and y limits is the problem, or you don't have enough variability in the data, or something else.
– arg0naut
Nov 10 at 9:34
|
show 6 more comments
Thank you, but in your solution a wide range of rows has been removed, as not all rows contain data (data availability for Regulated & Unregulated is different than for ETS). The legend of the graph also contains a curve for "total" which was supposed to be excluded
– Nordsee
Nov 10 at 9:11
"Error in paste("./FILENAME", iso2[i], ".png", sep = "") : object 'iso2' not found In addition: Warning message: Removed 94 rows containing missing values (geom_path). "
– Nordsee
Nov 10 at 9:12
The solution now excludes Total as well as corrects the error in ggsave. For the removal of rows, unfortunately I cannot really know what is causing it & how it should be corrected. It would helpful if you provide a more comprehensive test data and also indicate which rows should not be removed.
– arg0naut
Nov 10 at 9:23
Thank you, I've just ran your code. However, there are no curves on the plots and total is still included, but the loop works. Row are still removed, which may be a result due to varying data availability for the years (Regulated and unregulated 1990:2016; ETS 2005:2017). The curves should just go as the data is available (start/end). How can I provide you with more test data?
– Nordsee
Nov 10 at 9:28
I've modified the code; I think total was still included because your sector variable is a factor - I've changed that to character and it should work. For the test data, I think it would be helpful if the data is more representative of what you have (more data points [years and sectors] essentially, perhaps for just 2 countries would be enough). Perhaps setting the x and y limits is the problem, or you don't have enough variability in the data, or something else.
– arg0naut
Nov 10 at 9:34
Thank you, but in your solution a wide range of rows has been removed, as not all rows contain data (data availability for Regulated & Unregulated is different than for ETS). The legend of the graph also contains a curve for "total" which was supposed to be excluded
– Nordsee
Nov 10 at 9:11
Thank you, but in your solution a wide range of rows has been removed, as not all rows contain data (data availability for Regulated & Unregulated is different than for ETS). The legend of the graph also contains a curve for "total" which was supposed to be excluded
– Nordsee
Nov 10 at 9:11
"Error in paste("./FILENAME", iso2[i], ".png", sep = "") : object 'iso2' not found In addition: Warning message: Removed 94 rows containing missing values (geom_path). "
– Nordsee
Nov 10 at 9:12
"Error in paste("./FILENAME", iso2[i], ".png", sep = "") : object 'iso2' not found In addition: Warning message: Removed 94 rows containing missing values (geom_path). "
– Nordsee
Nov 10 at 9:12
The solution now excludes Total as well as corrects the error in ggsave. For the removal of rows, unfortunately I cannot really know what is causing it & how it should be corrected. It would helpful if you provide a more comprehensive test data and also indicate which rows should not be removed.
– arg0naut
Nov 10 at 9:23
The solution now excludes Total as well as corrects the error in ggsave. For the removal of rows, unfortunately I cannot really know what is causing it & how it should be corrected. It would helpful if you provide a more comprehensive test data and also indicate which rows should not be removed.
– arg0naut
Nov 10 at 9:23
Thank you, I've just ran your code. However, there are no curves on the plots and total is still included, but the loop works. Row are still removed, which may be a result due to varying data availability for the years (Regulated and unregulated 1990:2016; ETS 2005:2017). The curves should just go as the data is available (start/end). How can I provide you with more test data?
– Nordsee
Nov 10 at 9:28
Thank you, I've just ran your code. However, there are no curves on the plots and total is still included, but the loop works. Row are still removed, which may be a result due to varying data availability for the years (Regulated and unregulated 1990:2016; ETS 2005:2017). The curves should just go as the data is available (start/end). How can I provide you with more test data?
– Nordsee
Nov 10 at 9:28
I've modified the code; I think total was still included because your sector variable is a factor - I've changed that to character and it should work. For the test data, I think it would be helpful if the data is more representative of what you have (more data points [years and sectors] essentially, perhaps for just 2 countries would be enough). Perhaps setting the x and y limits is the problem, or you don't have enough variability in the data, or something else.
– arg0naut
Nov 10 at 9:34
I've modified the code; I think total was still included because your sector variable is a factor - I've changed that to character and it should work. For the test data, I think it would be helpful if the data is more representative of what you have (more data points [years and sectors] essentially, perhaps for just 2 countries would be enough). Perhaps setting the x and y limits is the problem, or you don't have enough variability in the data, or something else.
– arg0naut
Nov 10 at 9:34
|
show 6 more comments
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53237410%2fcreating-plots-ggplot2-using-loop-error-data-must-be-a-data-frame%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Seems you've referenced just a column, try
...+ geom_line(EUETS_UN, aes(x=year,y=emissions,group=sector) +....– jay.sf
Nov 10 at 8:56
Thank you for this, but unfortunately I'm still getting the same error
– Nordsee
Nov 10 at 9:01
The
color=cols[1]should also be included into theaes(), And specify thedataargument explicitly:ggplot() + geom_line(data=EUETS_UN, aes(x=year, y=emissions, group=sector, color=cols[1]))– jay.sf
Nov 10 at 9:16
same error, this also still includes the sector "total"
– Nordsee
Nov 10 at 9:19
2
Then have a good look at those links here: stackoverflow.com/help/mcve stackoverflow.com/questions/5963269/…
– Tjebo
Nov 10 at 13:45