## Baixar os dados do TSE em MS ##

## Fonte: https://sig.tse.jus.br/ords/dwapr/seai/r/sig-eleicao/home?session=10101393156264

library(readr)
candidatos = read_csv("votacao_candidato.csv")
candidatos = candidatos[candidatos$ds_cargo == "Governador", ]
candidatos
## Cruzamento dos códigos municipais entre TSE e IBGE ##

## Fonte: https://basedosdados.org/dataset/codigos-nacionais-ddd?external_link=Baixar+%28dados.gov.br%29
library(dplyr)
data <- read_csv("C:/Users/User/Documents/data000000000000.csv")
data <- data %>% select(,1, 3,21)
colnames(data)[2] <- "cd_municipio"
data = data[data$sigla_uf == "MS", ]
data
## Organizando os Dados ##

candidatos <- full_join(candidatos, data, by='cd_municipio')
colnames(candidatos)[9] <- "code_muni"
result <- full_join(mun_ms, candidatos, by='code_muni')

## Rankeando os candidatos mais votados por município ##
  
result <- result %>%
dplyr::group_by(code_muni) %>%
dplyr::mutate(rank = dplyr::dense_rank(dplyr::desc(qt_votos_nominais)))
result = result[result$rank == 1, ]
result
## Fazendo o Mapa ##

library(ggplot2)
ggplot(result) +
  geom_sf(data=result, aes(fill=nm_candidato), color= "black", size=.15)+
  scale_fill_manual(values=c('darkgoldenrod1', 'cornflowerblue', 'darkolivegreen3', 'brown3'), name="Candidatos")+
  labs(caption='Fonte: TSE - Mapa feito por Rafael Yaguinuma') +
  theme(panel.grid = element_line(colour = "transparent"),
        panel.background = element_blank(),
        axis.text = element_blank(),
        axis.ticks = element_blank())

LS0tDQp0aXRsZTogIkVsZWnDp8O1ZXMgMjAyMiBubyBNUyINCmF1dGhvcjogIlJhZmFlbCBZdWtpbyBNYWNlbmEgWWFndWludW1hIg0KZGF0ZTogJzIwMjItMTAtMTknDQpsaW5rY29sb3I6IGJsdWUNCg0Kb3V0cHV0Og0KICBodG1sX2RvY3VtZW50Og0KICAgIGNvZGVfZG93bmxvYWQ6IHRydWUNCiAgICB0aGVtZTogZGVmYXVsdA0KICAgIHRvYzogeWVzDQogICAgdG9jX2Zsb2F0OiB5ZXMNCiAgICBkZl9wcmludDogcGFnZWQNCiAgICBmaWdfY2FwdGlvbjogdHJ1ZQ0KICBwZGZfZG9jdW1lbnQ6DQogICAgdG9jOiB5ZXMNCi0tLQ0KDQpgYGB7ciBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQ0KIyMgQmFpeGFyIG9zIGRhZG9zIGRvIFRTRSBlbSBNUyAjIw0KDQojIyBGb250ZTogaHR0cHM6Ly9zaWcudHNlLmp1cy5ici9vcmRzL2R3YXByL3NlYWkvci9zaWctZWxlaWNhby9ob21lP3Nlc3Npb249MTAxMDEzOTMxNTYyNjQNCg0KbGlicmFyeShyZWFkcikNCmNhbmRpZGF0b3MgPSByZWFkX2Nzdigidm90YWNhb19jYW5kaWRhdG8uY3N2IikNCmNhbmRpZGF0b3MgPSBjYW5kaWRhdG9zW2NhbmRpZGF0b3MkZHNfY2FyZ28gPT0gIkdvdmVybmFkb3IiLCBdDQpjYW5kaWRhdG9zDQpgYGANCg0KYGBge3IgaW5jbHVkZT1GQUxTRX0NCg0KIyMgQmFpeGFyIE1hcGEgZGUgTVMgIyMNCg0KbGlicmFyeShnZW9icikNCm11bl9tcyA8LSByZWFkX211bmljaXBhbGl0eShjb2RlX211bmk9NTAsIHllYXI9MjAyMCkNCg0KYGBgDQoNCmBgYHtyIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0V9DQoNCiMjIENydXphbWVudG8gZG9zIGPDs2RpZ29zIG11bmljaXBhaXMgZW50cmUgVFNFIGUgSUJHRSAjIw0KDQojIyBGb250ZTogaHR0cHM6Ly9iYXNlZG9zZGFkb3Mub3JnL2RhdGFzZXQvY29kaWdvcy1uYWNpb25haXMtZGRkP2V4dGVybmFsX2xpbms9QmFpeGFyKyUyOGRhZG9zLmdvdi5iciUyOQ0KbGlicmFyeShkcGx5cikNCmRhdGEgPC0gcmVhZF9jc3YoIkM6L1VzZXJzL1VzZXIvRG9jdW1lbnRzL2RhdGEwMDAwMDAwMDAwMDAuY3N2IikNCmRhdGEgPC0gZGF0YSAlPiUgc2VsZWN0KCwxLCAzLDIxKQ0KY29sbmFtZXMoZGF0YSlbMl0gPC0gImNkX211bmljaXBpbyINCmRhdGEgPSBkYXRhW2RhdGEkc2lnbGFfdWYgPT0gIk1TIiwgXQ0KZGF0YQ0KYGBgDQoNCmBgYHtyIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0V9DQoNCiMjIE9yZ2FuaXphbmRvIG9zIERhZG9zICMjDQoNCmNhbmRpZGF0b3MgPC0gZnVsbF9qb2luKGNhbmRpZGF0b3MsIGRhdGEsIGJ5PSdjZF9tdW5pY2lwaW8nKQ0KY29sbmFtZXMoY2FuZGlkYXRvcylbOV0gPC0gImNvZGVfbXVuaSINCnJlc3VsdCA8LSBmdWxsX2pvaW4obXVuX21zLCBjYW5kaWRhdG9zLCBieT0nY29kZV9tdW5pJykNCg0KIyMgUmFua2VhbmRvIG9zIGNhbmRpZGF0b3MgbWFpcyB2b3RhZG9zIHBvciBtdW5pY8OtcGlvICMjDQogIA0KcmVzdWx0IDwtIHJlc3VsdCAlPiUNCmRwbHlyOjpncm91cF9ieShjb2RlX211bmkpICU+JQ0KZHBseXI6Om11dGF0ZShyYW5rID0gZHBseXI6OmRlbnNlX3JhbmsoZHBseXI6OmRlc2MocXRfdm90b3Nfbm9taW5haXMpKSkNCnJlc3VsdCA9IHJlc3VsdFtyZXN1bHQkcmFuayA9PSAxLCBdDQpyZXN1bHQNCmBgYA0KDQpgYGB7ciBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQ0KDQojIyBGYXplbmRvIG8gTWFwYSAjIw0KDQpsaWJyYXJ5KGdncGxvdDIpDQpnZ3Bsb3QocmVzdWx0KSArDQogIGdlb21fc2YoZGF0YT1yZXN1bHQsIGFlcyhmaWxsPW5tX2NhbmRpZGF0byksIGNvbG9yPSAiYmxhY2siLCBzaXplPS4xNSkrDQogIHNjYWxlX2ZpbGxfbWFudWFsKHZhbHVlcz1jKCdkYXJrZ29sZGVucm9kMScsICdjb3JuZmxvd2VyYmx1ZScsICdkYXJrb2xpdmVncmVlbjMnLCAnYnJvd24zJyksIG5hbWU9IkNhbmRpZGF0b3MiKSsNCiAgbGFicyhjYXB0aW9uPSdGb250ZTogVFNFIC0gTWFwYSBmZWl0byBwb3IgUmFmYWVsIFlhZ3VpbnVtYScpICsNCiAgdGhlbWUocGFuZWwuZ3JpZCA9IGVsZW1lbnRfbGluZShjb2xvdXIgPSAidHJhbnNwYXJlbnQiKSwNCiAgICAgICAgcGFuZWwuYmFja2dyb3VuZCA9IGVsZW1lbnRfYmxhbmsoKSwNCiAgICAgICAgYXhpcy50ZXh0ID0gZWxlbWVudF9ibGFuaygpLA0KICAgICAgICBheGlzLnRpY2tzID0gZWxlbWVudF9ibGFuaygpKQ0KDQpgYGANCg==