ggplot : How to use column names as x-axis label and the values as y-axis

Question

Can't find a way to fix this!

I want to plot a data frame which contains 4 columns it looks like this :

Species	Mean for today	Mean RCP26	Mean RCP85
1	0.567	0.765	0.342
2	0.987	0.543	0.001
3	0.456	0.876	0.54

Now I want to plot the col names as the x-axis labels and the corresponding values above them. The species should have a color code in the legend. In the end I hope to get a line diagramm which shows the development from today to rcp85.

I'm trying for hours now using ggplot but I cant find a way to realize it. Would be really glad to get some help.

Please display your data in a way that can make it easier for respondents to use. stackoverflow.com/questions/5963269/… — Mouad_Seridi
– Mouad_Seridi, Commented May 5, 2021 at 9:35

Mouad_Seridi · Accepted Answer · 2021-05-05 09:29:43Z

1

you need to pivot your data first, this is achieved by gather, also you need the group aesthetic to get a line with a discrete x axis

require(dplyr)
require(ggplot2)
    
df %>% 
gather(var, val , -Species) %>% 
ggplot(aes(x = var, y = val, color = as.factor(Species), group = as.factor(Species)))+
geom_line()

answered May 5, 2021 at 9:29

Mouad_Seridi

2,71617 silver badges29 bronze badges

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

1 Comment

TarJae Over a year ago

Development on gather() is complete, and for new code we recommend switching to pivot_longer(). <tidyr.tidyverse.org/reference/gather.html>

Wai Ha Lee · Accepted Answer · 2021-05-05 17:19:55Z

0

I also used tidyr to pivot the table.

library(ggplot2)
library(dplyr)
library(tidyr)

df %>% 
  pivot_longer(cols = 2:4, names_to = "indicators", values_to = "values") %>% 
  ggplot(data = ., aes(x = indicators, y = values, color = as.factor(Species), group = Species)) +
    geom_point()

The output:

edited May 5, 2021 at 17:19

Wai Ha Lee

8,856102 gold badges61 silver badges100 bronze badges

answered May 5, 2021 at 9:39

Paul

2,9871 gold badge17 silver badges46 bronze badges

Collectives™ on Stack Overflow

ggplot : How to use column names as x-axis label and the values as y-axis

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related