Učitavanje paketa

library(tidyverse)

Učitavanje podataka

podaci <- read.csv("kol1.csv")
podaci2 <- podaci %>% transmute(student = paste(Prezime, Ime), 
           Vrijeme = as.numeric(difftime(as.POSIXct(Završeno, format="%d. %B %Y. %H:%M"),
                                         as.POSIXct(Započeto, format="%d. %B %Y. %H:%M"),
                                         units='mins')), Bodovi = round(Bodovi)) %>% 
           filter(student != "Ukupni prosjek ")

Studenti s brojem bodova između 16 i 20

bodovi16 <- podaci2 %>% filter(Bodovi >= 16)
length(bodovi16$student)
## [1] 19
ggplot(bodovi16) + geom_point(aes(x=Vrijeme, y=student),size=6, color="#2266ee") +
  geom_segment(aes(x=Vrijeme, y=student, xend = Bodovi, yend = student), size = 2, color="#2266ee") +
  geom_point(aes(x=Bodovi, y=student),size=6, color="#ff5589") +
  geom_segment(aes(x=Bodovi, y=student, xend = 0, yend = student), size = 2, color="#ff5589") +
  geom_text(aes(x=Vrijeme, y=student, label = Vrijeme), color = "white", size = 3) +
  geom_text(aes(x=Bodovi, y=student, label = Bodovi), color = "white", size = 3) +
  labs(x="Bodovi / Vrijeme (min)")

Studenti s brojem bodova 14 ili 15

bodovi14do15 <- podaci2 %>% filter(Bodovi %in% 14:15)
length(bodovi14do15$student)
## [1] 31
ggplot(bodovi14do15) + geom_point(aes(x=Vrijeme, y=student),size=6, color="#2266ee") +
  geom_segment(aes(x=Vrijeme, y=student, xend = Bodovi, yend = student), size = 2, color="#2266ee") +
  geom_point(aes(x=Bodovi, y=student),size=6, color="#ff5589") +
  geom_segment(aes(x=Bodovi, y=student, xend = 0, yend = student), size = 2, color="#ff5589") +
  geom_text(aes(x=Vrijeme, y=student, label = Vrijeme), color = "white", size = 3) +
  geom_text(aes(x=Bodovi, y=student, label = Bodovi), color = "white", size = 3) +
  labs(x="Bodovi / Vrijeme (min)")

Studenti s brojem bodova 12 ili 13

bodovi12do13 <- podaci2 %>% filter(Bodovi %in% 12:13)
length(bodovi12do13$student)
## [1] 32
ggplot(bodovi12do13) + geom_point(aes(x=Vrijeme, y=student),size=6, color="#2266ee") +
  geom_segment(aes(x=Vrijeme, y=student, xend = Bodovi, yend = student), size = 2, color="#2266ee") +
  geom_point(aes(x=Bodovi, y=student),size=6, color="#ff5589") +
  geom_segment(aes(x=Bodovi, y=student, xend = 0, yend = student), size = 2, color="#ff5589") +
  geom_text(aes(x=Vrijeme, y=student, label = Vrijeme), color = "white", size = 3) +
  geom_text(aes(x=Bodovi, y=student, label = Bodovi), color = "white", size = 3) +
  labs(x="Bodovi / Vrijeme (min)")

Studenti s brojem bodova 10 ili 11

bodovi10do11 <- podaci2 %>% filter(Bodovi %in% 10:11)
length(bodovi10do11$student)
## [1] 37
ggplot(bodovi10do11) + geom_point(aes(x=Vrijeme, y=student),size=6, color="#2266ee") +
  geom_segment(aes(x=Vrijeme, y=student, xend = Bodovi, yend = student), size = 2, color="#2266ee") +
  geom_point(aes(x=Bodovi, y=student),size=6, color="#ff5589") +
  geom_segment(aes(x=Bodovi, y=student, xend = 0, yend = student), size = 2, color="#ff5589") +
  geom_text(aes(x=Vrijeme, y=student, label = Vrijeme), color = "white", size = 3) +
  geom_text(aes(x=Bodovi, y=student, label = Bodovi), color = "white", size = 3) +
  labs(x="Bodovi / Vrijeme (min)")

Studenti s brojem bodova između 7 i 9

bodovi7do9 <- podaci2 %>% filter(Bodovi %in% 7:9)
length(bodovi7do9$student)
## [1] 64
ggplot(bodovi7do9) + geom_point(aes(x=Vrijeme, y=student),size=6, color="#2266ee") +
  geom_segment(aes(x=Vrijeme, y=student, xend = Bodovi, yend = student), size = 2, color="#2266ee") +
  geom_point(aes(x=Bodovi, y=student),size=6, color="#ff5589") +
  geom_segment(aes(x=Bodovi, y=student, xend = 0, yend = student), size = 2, color="#ff5589") +
  geom_text(aes(x=Vrijeme, y=student, label = Vrijeme), color = "white", size = 3) +
  geom_text(aes(x=Bodovi, y=student, label = Bodovi), color = "white", size = 3) +
  labs(x="Bodovi / Vrijeme (min)")

Studenti s brojem bodova između 0 i 6

bodovi6 <- podaci2 %>% filter(Bodovi %in% 0:6)
length(bodovi6$student)
## [1] 54
ggplot(bodovi6) + geom_point(aes(x=Vrijeme, y=student),size=6, color="#2266ee") +
  geom_segment(aes(x=Vrijeme, y=student, xend = Bodovi, yend = student), size = 2, color="#2266ee") +
  geom_point(aes(x=Bodovi, y=student),size=6, color="#ff5589") +
  geom_segment(aes(x=Bodovi, y=student, xend = 0, yend = student), size = 2, color="#ff5589") +
  geom_text(aes(x=Vrijeme, y=student, label = Vrijeme), color = "white", size = 3) +
  geom_text(aes(x=Bodovi, y=student, label = Bodovi), color = "white", size = 3) +
  labs(x="Bodovi / Vrijeme (min)")