color in ggplot based on the sign of the variable using the Reshape library

Asked Apr 01 '15 at 18:22

Active Apr 01 '15 at 18:50

Viewed 109 times

Hey everyone I am using the inbuilt-dataset economics in Rstudio. I want to create a ggplot and display the personal savings rate (psavert) with different colors of positive and negative values in a time series. I tried the following code, however its not really helping :

new2 <-melt(economics, id=c("date"))
new2[["sign"]] = ifelse(new2[["value"]] >= 0, "positive", "negative")
ggplot(mydata2, aes(x = date, y = value, fill = sign)) + geom_area() + 
scale_fill_manual(values = c("positive" = "blue", "negative" = "red"))

I am unable to plot just the variable psavert. Thank you :)

edited Apr 01 '15 at 18:50

asked Apr 01 '15 at 18:22

chandini v

How exactly do we get that `economics` data ...? – Eike P. Apr 01 '15 at 18:31
just use economics. R will read it itself. – chandini v Apr 01 '15 at 18:37
1

@jhin It's inlucded in `ggplot2`. – Gregor Thomas Apr 01 '15 at 18:41
Duplicates of [this](http://stackoverflow.com/q/17959817/903061) and [this](http://stackoverflow.com/q/7883154/903061). – Gregor Thomas Apr 01 '15 at 18:45
@Gregor im learning more about reshape and melt functions, and none of these solutions uses these. – chandini v Apr 01 '15 at 18:49
Your `melt`ing is unnecessary with this data, the data is already tidy. It's also completely unrelated to the coloring of the ggplot. – Gregor Thomas Apr 01 '15 at 19:05
@Gregor could please look into the code ad see what i am doing wrong. – chandini v Apr 01 '15 at 19:18
I'll have time to answer later tonight if no one else has yet. I think it would help you a lot on to understand melt and when you need it to read through the [Tidy Data paper](http://vita.had.co.nz/papers/tidy-data.pdf). – Gregor Thomas Apr 02 '15 at 00:14

color in ggplot based on the sign of the variable using the Reshape library

0 Answers0