Plotting multiple columns against one column in ggplot2

Question

In my data I have 12 columns called X1 to X12 plus one additional column called x. Using ggplot2 package, I was wondering how to plot each of the columns X1 to X12 as the y-axis, against the same x column as the x-axis?

I suspect I need a facet_wrap() for each of X1 to X12 as the y-axis, and x as the x-axis. So we will have 12 plots each with one of X1 to X12 as the y-axis, and the same x column as the x-axis.

Note: I need a geom_line.

library(tidyverse)

data <- read.csv('https://raw.githubusercontent.com/rnorouzian/e/master/vp_cond.csv')

long <- pivot_longer(data, everything()) # do we need to do this before plotting?

What kind of graph you are looking for ggplot(long, aes(x = name, y = value)) + geom_boxplot() — akrun
– akrun, Commented Nov 4, 2020 at 23:16

neilfws · Accepted Answer · 2020-11-04 23:18:15Z

1

Yes, you can use pivot_longer (or gather) and facets to achieve this.

One issue is that by default the labels will not be in the order X1 - X12, so you will need to specify the factor levels.

Try this:

data %>% 
  pivot_longer(cols = 1:12) %>% 
  mutate(name = factor(name, levels = paste0("X", 1:12))) %>% 
  ggplot(aes(x, value)) + 
  geom_line() + 
  facet_wrap(~name) +
  theme_bw()

Result:

answered Nov 4, 2020 at 23:18

neilfws

34k5 gold badges58 silver badges72 bronze badges

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

Comments

akrun · Accepted Answer · 2020-11-04 23:32:08Z

1

We can use geom_line with facet_wrap

library(ggplot2)
data %>%
   pivot_longer(cols = -x) %>% 
   ggplot(aes(x, value)) + 
        geom_line() + 
        facet_wrap(~ name)

edited Nov 4, 2020 at 23:32

answered Nov 4, 2020 at 23:19

akrun

891k38 gold badges590 silver badges700 bronze badges

2 Comments

akrun Over a year ago

@rnorouzian you replied earlier to my comment that it is geom_point

rnorouzian Over a year ago

Thank you so much, I highly appreciate it, I have a couple of follow-ups about the data itself in a bit.

Collectives™ on Stack Overflow

Plotting multiple columns against one column in ggplot2

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related