Plotting more than 2 factor variables in ggplot

Question

My dataset looks like below,

dat <- data.frame(ID = c(150,151,155,155,155,155,150), year = c(1995,2011,2012,2012,2013,2012,2013), Acceptance = c(no,yes,yes,yes,yes,no,no));

I wanted to plot a bar chart, for ID 155, with X-axis over the Year, and var 3 Which shows only Yes.

I have tried the below code

cl_d <- dat %>%
  filter(ID==155)%>%
  filter(year(Date)>2000)%>%
  group_by(ID, year)%>%
  summarise(count=n())

ggplot(cl_d, aes(year, count))+
  geom_bar(stat='identity')

The bar plot should show the count of Acceptance for "Yes" over the Date greater than 2000 for the particular ID 155

Boetzka · Accepted Answer · 2018-04-16 09:02:41Z

1

Hey this code should work I alway try to avoid plugins if you have any questions left just ask!

dat <- data.frame(c(150,151,155,155,155,155,150), 
c(1995,2011,2012,2012,2013,2012,2013), 
c("no","yes","yes","yes","yes","no","no"))
colnames(dat)[1] <- "ID"
colnames(dat)[2] <- "Date"
colnames(dat)[3] <- "claim_count1"
NewData <- dat[dat$ID==155 & dat$Date > 2000 & dat$claim_count1== "yes",]
ggplot(data=NewData, aes(x=Date)) + geom_bar(stat ="count")

answered Apr 16, 2018 at 9:02

Boetzka

133 bronze badges

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

Comments

Roman · Accepted Answer · 2018-04-16 09:04:41Z

1

This?

dat %>%
  filter(ID==155)%>%
  filter(Acceptance == "yes") %>% 
  filter(year>2000) %>% 
  group_by(year) %>% 
  count() %>% 
 ggplot(aes(year, n))+
   geom_col()

answered Apr 16, 2018 at 9:04

Roman

17.7k3 gold badges39 silver badges52 bronze badges

2 Comments

umar Over a year ago

I am getting an error that Acceptance is not found :(

Roman Over a year ago

check colnames(dat) and change the names accordingly.

Ammar · Accepted Answer · 2018-04-16 09:15:54Z

1

It appears you want year to be in date format and the graph to also be in the date format. If this is the case see the code below:

dat <- data.frame(ID = c(150,151,155,155,155,155,150), 
 year =  c(1995,2011,2012,2012,2013,2012,2013), 
 Acceptance = c("no","yes","yes","yes","yes","no","no"))

dat$year <- as.Date(ISOdate(dat$year, 1, 1))

cl_d <- dat %>% filter(ID==155) %>%
  subset(year > as.Date("2000-01-01")) %>%
         group_by(ID, year) %>%
         summarise(count=n())

ggplot(cl_d, aes(year, count)) + 
  geom_bar(stat='identity') + 
  scale_x_date(date_labels ="%Y", date_breaks = "1 year")

answered Apr 16, 2018 at 9:15

Ammar

1,3721 gold badge8 silver badges20 bronze badges

Comments

Maurits Evers · Accepted Answer · 2018-04-16 09:19:09Z

1

Is this what you're after?

library(tidyverse);
dat %>%
    filter(ID == 155 & year >= 2000 & Acceptance == "yes") %>%
    count(ID, year) %>%
    ggplot(aes(as.factor(year), n)) +
    geom_bar(stat = "identity") +
    labs(x = "Year", y = "Count")

Sample data

dat <- data.frame(
    ID = c(150,151,155,155,155,155,150),
    year = c(1995,2011,2012,2012,2013,2012,2013),
    Acceptance = c("no","yes","yes","yes","yes","no","no"));

edited Apr 16, 2018 at 9:19

answered Apr 16, 2018 at 9:08

Maurits Evers

51k4 gold badges53 silver badges75 bronze badges

5 Comments

umar Over a year ago

@Mauritis, yes.

umar Over a year ago

I am not able to see the plot in my graph for some reason.

Maurits Evers Over a year ago

@umar Have you included the necessary libraries? library(tidyverse) will do the job. Then copy & paste above code. I've also added your sample data to make the code fully reproducible.

umar Over a year ago

@Mauritis I have included the package; yet no plot

Maurits Evers Over a year ago

@umar I just edited my comment & post to include the sample data. This is fully reproducible when I run it. Can you double-check? Perhaps restart your R session. I cannot reproduce your situation.

Collectives™ on Stack Overflow

Plotting more than 2 factor variables in ggplot

4 Answers 4

Comments

2 Comments

Comments

Sample data

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Sample data

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related