Completing individual box plot with two rows of data, compairing positive against negative

Question

I am still fairly new to R. Please can someone help me with a query.

How do I complete individual box plots on my data? I need to compare the positive against the negative for each row. There are 195 columns.

The data look like this: (The positive is under the negative, so two row and up to 195 columns, and I need to boxplot each column)

                     1    2    3    4    5     6   7   etc 
Negative            1.1  2.1  2.2  3.1  5.66 8.99 5.11 etc
Positive            2.1  5.6  5.7  3.0  6.1  8.1  6.2  etc

Thanks in advance

boxplot for each column? There are only two numbers for each column. How can you plot a boxplot for just two numbers? I assume you want a boxplot for Positive as one group and Negative as the other group. Please see my answer. — www, Jun 28 '18 at 13:45
Hello. Thanks for your reply. Yes I want to boxplot for positive and negative. — Alyce Belle, Jun 28 '18 at 14:51

RLave · Answer 1 · 2018-06-28T13:52:55.800

1

require(tidyverse) # dplyr() and ggplot2()
# your data
data <- data.frame(negative = c( 1.1,  2.1,  2.2,  3.1,  5.66, 8.99, 5.11),
               positive = c(2.1,  5.6,  5.7,  3.0,  6.1,  8.1,  6.2))
# we gather to have one long column with values and one with the "class"
data <- data %>% gather(class) # you can name here the class column
# use ggplot to plot the data
ggplot(data, aes(y = value, x = class)) +
  geom_boxplot()

Please provide a reproducible example text time, see this: How to make a great R reproducible example?

edited Jun 28 '18 at 13:52

answered Jun 28 '18 at 13:31

RLave

8,144
3
21
37

It has 2 columns, "negative" and "positive", with `gather` I get the long format. – RLave Jun 28 '18 at 13:48
Hello. Many thanks for reply. There seems to be an error in the gather function. Error in gather(., class) : could not find function "gather" – Alyce Belle Jun 28 '18 at 15:12
You need to install some packages first, use: `install.packages("tidyverse")` – RLave Jun 28 '18 at 15:13
`gather()` and `ggplot()` are "extra" function, not provided with the base R packages. You need to install their respective libraries first to use them. – RLave Jun 28 '18 at 15:15
Thanks for your help. – Alyce Belle Jun 29 '18 at 07:54
1

@LieslCarr Please consider to accept the answer you think are relevant and useful. – www Jul 03 '18 at 13:55

www · Answer 2 · 2018-06-28T13:56:01.460

1

Your data frame is in wide format, which is difficult to work with. We can first convert it to long format.

library(tidyverse)

dat2 <- dat %>%
  rownames_to_column() %>%
  gather(Column, Value, -rowname)

After that, you can use the ggplot2 package to plot the data as Riccardo Lavelli suggested. Here I showed another option, which is the bwplot function from the lattice package.

library(lattice)

bwplot(Value ~ rowname, dat2)

You can also consider to use the base R boxplot function.

boxplot(Value ~ rowname, dat2)

You can also consider the ggboxplot from the ggpubr package.

library(ggpubr)

ggboxplot(dat2, x = "rowname", y = "Value")

DATA

dat <- read.table(text = "                     1    2    3    4    5     6   7 
Negative            1.1  2.1  2.2  3.1  5.66 8.99 5.11
Positive            2.1  5.6  5.7  3.0  6.1  8.1  6.2",
                  header = TRUE)

edited Jun 28 '18 at 13:56

answered Jun 28 '18 at 13:43

www

38,575
12
48
84

Thanks. The original data has 195 columns, is there a way I can enter it without typing it manually? – Alyce Belle Jun 28 '18 at 15:00
@LieslCarr My solution does not need any manual typing. So it should not be a problem. – www Jun 28 '18 at 15:15
Thanks for your help. – Alyce Belle Jun 29 '18 at 07:55
1

Glad to help. Please consider to accept the post as the answer if it solves your question. – www Jun 29 '18 at 11:04
@LieslCarr https://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work – www Jul 03 '18 at 14:43

Completing individual box plot with two rows of data, compairing positive against negative

2 Answers2