I would like plot my data in stacked bar chart. My data is like this
ID,A,B,C
D11,2,2,4
D170,2,0,6
D171,1,5,2
D1,5,0,2
D27,NA,NA,NA
D295,0,6,2
How should I start with.
I would like plot my data in stacked bar chart. My data is like this
ID,A,B,C
D11,2,2,4
D170,2,0,6
D171,1,5,2
D1,5,0,2
D27,NA,NA,NA
D295,0,6,2
How should I start with.
library('ggplot2')
library('reshape2')
df <- reshape2::melt(df, id.vars = 'ID') # melt data with ID column
df <- df[!is.na(df$value), ] # remove NA
ggplot( data = df, aes( x = ID, y = value )) +
geom_bar( aes( fill = variable ), stat = 'identity' )
Data:
df <- structure(list(ID = c("D11", "D170", "D171", "D1", "D27", "D295"),
A = c(2L, 2L, 1L, 5L, NA, 0L),
B = c(2L, 0L, 5L, 0L, NA, 6L),
C = c(4L, 6L, 2L, 2L, NA, 2L)),
.Names = c("ID", "A", "B", "C"),
row.names = c(NA, -6L), class = "data.frame")
In addition to @Sathish's answer.
Below is the answer using tidyr
and ggplot2
df <- read.table(text = c("
ID A B C
D11 2 2 4
D170 2 0 6
D171 1 5 2
D1 5 0 2
D27 NA NA NA
D295 0 6 2"), header = T)
library(tidyr)
library(ggplot2)
df %>% tidyr::gather("var", "value", 2:4) %>%
ggplot(., aes(x = ID, y = value))+geom_bar(aes(fill = var ), stat ="identity")