Graphics with dataframe

Question

I have a table with export of every EU country:

country 2001  2002  2003  .....
france  12023 54554 251515 ....
.....

I would like to do a plot with the value of every years for 4 country (e.g. Germany, Italy, France, Netherlands). It's a dataframe I have tried with those commands:

y<-ts(EXEU)
y
plot(y[5,],type="o")

But when I use ts I lose all the name of the countries and I have on the x-axis frequency not every years. It's possible to do the same without use ts().

Andre Silva · Accepted Answer · 2014-12-22 22:28:44Z

1

Try this:

library(reshape2)
library(ggplot2)

#EXEU is your dataframe
EXEU<-melt(EXEU,id='country',variable.name='YEAR',value.name='VALUE')
ggplot(EXEU,aes(YEAR,VALUE,group=country, color=country))+geom_line()

Picture example

edited Dec 22, 2014 at 22:28

Andre Silva

5,0169 gold badges58 silver badges69 bronze badges

answered Dec 18, 2014 at 11:20

Nikos

3,2951 gold badge27 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Graphics with dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related