Avaliação
library(dplyr)
library(ggplot2)
library(tidyr)
library(googlesheets)
library(plotly)
library(psych)
gs_auth()
link <- gs_title("Avaliaçoes 2019")
#read.csv2("dados.csv",sep = ",", stringsAsFactors = T, header = T)
data <- gs_read(ss=link, ws = "Página1")
Downloading: 1 kB
Downloading: 1 kB
Downloading: 1.3 kB
Downloading: 1.3 kB
Downloading: 1.3 kB
Downloading: 1.3 kB
Downloading: 1.3 kB
Downloading: 1.3 kB
Avaliação pro grupo
data_jovens <- filter(data, origem == "JCO" | origem == "JPO" | origem == "JSE" | origem == "JFL") %>%
mutate_if(is.integer, funs(replace(., is.na(.), 0))) %>%
select(2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32)
Jovens
d1 <- data_jovens %>% select(1:4)
multi.hist(d1 ,bcol="red")

d1 <- data_jovens %>% select(5:8)
multi.hist(d1 ,bcol="red")

d1 <- data_jovens %>% select(9:12)
multi.hist(d1 ,bcol="red")

d1 <- data_jovens %>% select(12:16)
multi.hist(d1 ,bcol="red")

d1 <- data_jovens %>% select(17:20)
multi.hist(d1 ,bcol="red")

d1 <- data_jovens %>% select(21:24)
multi.hist(d1 ,bcol="red")

d1 <- data_jovens %>% select(25:28)
multi.hist(d1 ,bcol="red")

d1 <- data_jovens %>% select(29:31)
multi.hist(d1 ,bcol="red")

Comissões
data_comissoes <- filter(data, origem != "JCO" & origem != "JPO" & origem != "JSE" & origem != "JFL") %>%
mutate_if(is.integer, funs(replace(., is.na(.), 0)))
d1 <- data_comissoes %>% select(2:5)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(6:9)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(10:13)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(14:17)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(18:21)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(22:25)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(26:29)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(30:33)
multi.hist(d1 ,bcol="red")

d1 <- data_comissoes %>% select(34:36)
multi.hist(d1 ,bcol="red")

LS0tDQp0aXRsZTogIkNPTUVFUkogMjAxOSINCm91dHB1dDoNCiAgaHRtbF9ub3RlYm9vazoNCiAgICBjb2RlX2ZvbGRpbmc6IGhpZGUNCiAgcGRmX2RvY3VtZW50OiBkZWZhdWx0DQotLS0NCg0KI0F2YWxpYcOnw6NvDQpgYGB7ciBtZXNzYWdlPUZBTFNFfQ0KbGlicmFyeShkcGx5cikNCmxpYnJhcnkoZ2dwbG90MikNCmxpYnJhcnkodGlkeXIpDQpsaWJyYXJ5KGdvb2dsZXNoZWV0cykNCmxpYnJhcnkocGxvdGx5KQ0KbGlicmFyeShwc3ljaCkNCg0KDQoNCmdzX2F1dGgoKQ0KDQoNCmxpbmsgPC0gZ3NfdGl0bGUoIkF2YWxpYcOnb2VzIDIwMTkiKQ0KICAjcmVhZC5jc3YyKCJkYWRvcy5jc3YiLHNlcCA9ICIsIiwgc3RyaW5nc0FzRmFjdG9ycyA9IFQsIGhlYWRlciA9IFQpDQpkYXRhIDwtIGdzX3JlYWQoc3M9bGluaywgd3MgPSAiUMOhZ2luYTEiKQ0KDQoNCmBgYA0KDQoNCiNBdmFsaWHDp8OjbyBwcm8gZ3J1cG8NCg0KYGBge3J9DQoNCg0KZGF0YV9qb3ZlbnMgPC0gIGZpbHRlcihkYXRhLCBvcmlnZW0gPT0gIkpDTyIgfCBvcmlnZW0gPT0gIkpQTyIgfCBvcmlnZW0gPT0gIkpTRSIgIHwgb3JpZ2VtID09ICJKRkwiKSAlPiUNCiAgbXV0YXRlX2lmKGlzLmludGVnZXIsIGZ1bnMocmVwbGFjZSguLCBpcy5uYSguKSwgMCkpKSAlPiUNCiAgc2VsZWN0KDIsMyw0LDUsNiw3LDgsOSwxMCwxMSwxMiwxMywxNCwxNSwxNiwxNywxOCwxOSwyMCwyMSwyMiwyMywyNCwyNSwyNiwyNywyOCwyOSwzMCwzMSwzMikNCg0KDQoNCmBgYA0KDQojSm92ZW5zDQoNCg0KYGBge3J9DQpkMSA8LSBkYXRhX2pvdmVucyAlPiUgc2VsZWN0KDE6NCkNCm11bHRpLmhpc3QoZDEgLGJjb2w9InJlZCIpDQoNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2pvdmVucyAlPiUgc2VsZWN0KDU6OCkNCm11bHRpLmhpc3QoZDEgLGJjb2w9InJlZCIpDQoNCmBgYA0KDQpgYGB7cn0NCmQxIDwtIGRhdGFfam92ZW5zICU+JSBzZWxlY3QoOToxMikNCm11bHRpLmhpc3QoZDEgLGJjb2w9InJlZCIpDQoNCmBgYA0KDQpgYGB7cn0NCmQxIDwtIGRhdGFfam92ZW5zICU+JSBzZWxlY3QoMTI6MTYpDQptdWx0aS5oaXN0KGQxICxiY29sPSJyZWQiKQ0KDQpgYGANCg0KYGBge3J9DQpkMSA8LSBkYXRhX2pvdmVucyAlPiUgc2VsZWN0KDE3OjIwKQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCg0KYGBgDQoNCmBgYHtyfQ0KZDEgPC0gZGF0YV9qb3ZlbnMgJT4lIHNlbGVjdCgyMToyNCkNCm11bHRpLmhpc3QoZDEgLGJjb2w9InJlZCIpDQoNCmBgYA0KDQpgYGB7cn0NCmQxIDwtIGRhdGFfam92ZW5zICU+JSBzZWxlY3QoMjU6MjgpDQptdWx0aS5oaXN0KGQxICxiY29sPSJyZWQiKQ0KDQpgYGANCg0KYGBge3J9DQpkMSA8LSBkYXRhX2pvdmVucyAlPiUgc2VsZWN0KDI5OjMxKQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCg0KYGBgDQoNCiNDb21pc3PDtWVzDQoNCmBgYHtyfQ0KZGF0YV9jb21pc3NvZXMgPC0gIGZpbHRlcihkYXRhLCBvcmlnZW0gIT0gIkpDTyIgJiBvcmlnZW0gIT0gIkpQTyIgJiBvcmlnZW0gIT0gIkpTRSIgICYgb3JpZ2VtICE9ICJKRkwiKSAlPiUNCiAgbXV0YXRlX2lmKGlzLmludGVnZXIsIGZ1bnMocmVwbGFjZSguLCBpcy5uYSguKSwgMCkpKSANCmBgYA0KDQpgYGB7cn0NCmQxIDwtIGRhdGFfY29taXNzb2VzICU+JSBzZWxlY3QoMjo1KQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KDQpgYGB7cn0NCmQxIDwtIGRhdGFfY29taXNzb2VzICU+JSBzZWxlY3QoNjo5KQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2NvbWlzc29lcyAlPiUgc2VsZWN0KDEwOjEzKQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2NvbWlzc29lcyAlPiUgc2VsZWN0KDE0OjE3KQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2NvbWlzc29lcyAlPiUgc2VsZWN0KDE4OjIxKQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2NvbWlzc29lcyAlPiUgc2VsZWN0KDIyOjI1KQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2NvbWlzc29lcyAlPiUgc2VsZWN0KDI2OjI5KQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2NvbWlzc29lcyAlPiUgc2VsZWN0KDMwOjMzKQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KYGBge3J9DQpkMSA8LSBkYXRhX2NvbWlzc29lcyAlPiUgc2VsZWN0KDM0OjM2KQ0KbXVsdGkuaGlzdChkMSAsYmNvbD0icmVkIikNCmBgYA0KDQoNCg==