Questão 1

MRT_1F <-c(517.1468515630205, 85.13094142168089, 30.333207896694553, 12.694776264558937, 3.3041601673945418, 1.1823111717498882, 1.1892293502386786)

MRT_3F <-c(156.68929936163462, 11.540837783562276, 0.4512835621696538, 0.4509797929766453, 0.4502068233039181, 0.4496185276300172, 0.4543157082191288)

MRT_5F <-c(83.90319666471157, 0.3068151086494968, 0.30522314133037304, 0.3072588968084928, 0.30655265997285697, 0.3055812715727718, 0.3053297166713006)

MRT_10F <-c(29.55430642951759, 0.19832832665772515, 0.1971923924717474, 0.19796648905716516, 0.19615594370806338, 0.2034569237883263, 0.19617420889447737)

MRT_15F <-c(11.317736530583566, 0.167364215666193, 0.16172168266811013, 0.16701085329580515, 0.1598052657153692, 0.1645934043532696, 0.16216563797118075)

MRT_sem_F <-c(11.93430909937736, 0.6095414637034009, 0.6060645101029295, 0.612167181646899, 0.6146761002685637, 0.6096747087200697, 0.6125810476877268)

clock <- c(0.1, 0.5, 1, 1.5, 2, 2.5, 3)

plot(clock, MRT_1F, type="o", pch=4,
     xlab="Time between Things requests (seconds)", ylab="EixoY",
     main="")
lines(clock, MRT_3F, type="o", col="yellow", pch=11)
lines(clock, MRT_5F, type="o", col="red")
lines(clock, MRT_10F, type="o", col="blue", pch=2)
lines(clock, MRT_15F, type="o", col="purple", pch=5)
lines(clock, MRT_sem_F, type="o", col="green", pch=4)
legend("topright", pch=c(4, 11, 1, 2, 5, 4),
       col=c("black", "yellow", "red", "blue", "purple", "green"),
       legend=c("1 Fog", "3 Fogs", "5 Fogs", "10 Fogs", "15 Fogs", "w/o Fogs"))

barplot(matrix(c(MRT_sem_F, MRT_1F), nrow=2, ncol=7, byrow=T), col=c("#E6E6E6", "#666666"),
        xlab="Time between Things requests", ylab = "Response time(s)" , beside=T)
legend("topright", col=c("#E6E6E6", "#666666"), pch=c(15,15), legend=c("w/o Fogs", "1 Fog"))

barplot(matrix(c(MRT_sem_F, MRT_3F), nrow=2, ncol=7, byrow=T), col=c("#E6E6E6", "#666666"),
        xlab="Time between Things requests", ylab = "Response time(s)" , beside=T)
legend("topright", col=c("#E6E6E6", "#666666"), pch=c(15,15), legend=c("w/o Fogs", "3 Fogs"))

barplot(matrix(c(MRT_sem_F, MRT_5F), nrow=2, ncol=7, byrow=T), col=c("#E6E6E6", "#666666"),
        xlab="Time between Things requests", ylab = "Response time(s)" , beside=T)
legend("topright", col=c("#E6E6E6", "#666666"), pch=c(15,15), legend=c("w/o Fogs", "5 Fogs"))

barplot(matrix(c(MRT_sem_F, MRT_10F), nrow=2, ncol=7, byrow=T), col=c("#E6E6E6", "#666666"),
        xlab="Time between Things requests", ylab = "Response time(s)" , beside=T)
legend("topright", col=c("#E6E6E6", "#666666"), pch=c(15,15), legend=c("w/o Fogs", "10 Fogs"))

barplot(matrix(c(MRT_sem_F, MRT_15F), nrow=2, ncol=7, byrow=T), col=c("#E6E6E6", "#666666"),
        xlab="Time between Things requests", ylab = "Response time(s)" , beside=T)
legend("topright", col=c("#E6E6E6", "#666666"), pch=c(15,15), legend=c("w/o Fogs", "15 Fogs"))

Questão 2

data <- matrix(
  c(53.8, 33.9, 2.6, 0, 43.6, 54.2, 60.5, 21.4, 2.6, 11.9, 36.8, 78.6),
  nrow = 3,
  byrow = TRUE
)

barplot(
  data,
  col = c("#E6E6E6", "#666666", "#B3B3B3"),
  legend.text = rownames(data),
  args.legend = list(x = "topleft", bty = "n"),
  xlab = "Meal Price",
  ylab = "Quality Rating",
)

legend("topright", col=c("#E6E6E6", "#666666", "#B3B3B3"), pch=c(15,15,15),
       legend=c("Good", "Very Good", "Excellent"))

Questão 3

data(airquality)

temperatura_maio <- airquality[airquality$Month == 5, "Temp"]

temperatura_maio_C <- (temperatura_maio - 32) / 1.8


hist(
  temperatura_maio_C,
  col = "black",
  probability = T,
  main = "Histogram of Temperature",
  xlab = "Temperature (°C)",
  ylab = "Density"
)

lines(density(temperatura_maio_C), col = "green")

Questão 4

sales <- read.table("https://training-course-material.com/images/8/8f/Sales.txt", header = TRUE)

pct <- round(sales$SALES/sum(sales$SALES)*100)
lbls <- paste(sales$COUNTRY, pct)
lbls <- paste(lbls, "%", sep="")

pie(sales$SALES, labels = lbls,
    main = "Sales by Country",
    col=rainbow(nrow(sales)))

legend("topright", legend = sales$COUNTRY,
       fill = rainbow(nrow(sales)), bty = "n")

Questão 5

data(InsectSprays)

boxplot(count ~ spray, data = InsectSprays,
        col = "brown", outline = FALSE,
        xlab = "Spray", ylab = "Count")

Questão 6

options(repos = c(CRAN = "https://cloud.r-project.org"))

library(ggplot2)

converte_para_megabytes <- function(memory) {
  numeros <- as.numeric(gsub("[^0-9.]", "", memory))
  
  if (length(numeros) == 0 || any(is.na(numeros))) {
    return(NA) 
  }
  
  unidade <- gsub("[0-9.]", "", memory)
  fator_conversao <- switch(tolower(unidade),
    "tb" = 1000000,
    "gb" = 1024,
    "mb" = 1,
    "kb" = 0.001,
    "b" = 0.000001,
    1
  )
  
  return(sum(numeros) * fator_conversao)
}

# None Workload
data_NONE <- read.csv("~/monitoringCloudData_NONE.csv")

# Aplicar a função à coluna usedMemory
data_NONE$usedMemory <- sapply(data_NONE$usedMemory, converte_para_megabytes)

data_NONE$currentTime <- as.POSIXct(data_NONE$currentTime, format="%Y-%m-%d %H:%M:%OS")
min_date <- min(data_NONE$currentTime)

data_NONE$continuousTime <- as.numeric(difftime(data_NONE$currentTime, min_date, units = "hours"))

# Remover linhas com valores ausentes em usedMemory e continuousTime
data_NONE <- data_NONE[!is.na(data_NONE$usedMemory) & !is.na(data_NONE$continuousTime), ]

# Criar gráfico
ggplot(data_NONE, aes(x = continuousTime, y = usedMemory)) +
  geom_line(color = "black") +  
  theme_minimal() + 
  theme(
    panel.background = element_rect(fill = "white"),
    panel.grid = element_blank(), 
    axis.line = element_line(color = "black"),
    plot.title = element_text(hjust = 0.5, face = "bold")
  ) +
  scale_x_continuous(breaks = seq(0, max(data_NONE$continuousTime), by = 10)) + 
  scale_y_continuous(breaks = seq(0, max(data_NONE$usedMemory), by = 2)) +  
  labs(x = "Time (hour)", y = "Used Memory (MB)", title = "Memory Analysis (None Workload)")

#Workload 0.1
data_0.1 <- read.csv("~/monitoringCloudData_0.1.csv")

data_0.1$usedMemory <- sapply(data_0.1$usedMemory, converte_para_megabytes)

data_0.1$currentTime <- as.POSIXct(data_0.1$currentTime, format="%Y-%m-%d %H:%M:%OS")
min_date <- min(data_0.1$currentTime)

data_0.1$continuousTime <- as.numeric(difftime(data_0.1$currentTime, min_date, units = "hours"))

data_0.1 <- data_0.1[!is.na(data_0.1$usedMemory) & !is.na(data_0.1$continuousTime), ]

ggplot(data_0.1, aes(x = continuousTime, y = usedMemory)) +
  geom_line(color = "black") +  
  theme_minimal() + 
  theme(
    panel.background = element_rect(fill = "white"),
    panel.grid = element_blank(), 
    axis.line = element_line(color = "black"),
    plot.title = element_text(hjust = 0.5, face = "bold")
  ) +
  scale_x_continuous(breaks = seq(0, max(data_0.1$continuousTime), by = 10)) + 
  scale_y_continuous(breaks = c(500, 1500, 2500, 3500)) +  
  labs(x = "Time (hour)", y = "Used Memory (MB)", title = "Memory Analysis (Workload of 0.1)")

#Workload 0.5
data_0.5 <- read.csv("~/monitoringCloudData_0.5.csv")

data_0.5$usedMemory <- sapply(data_0.5$usedMemory, converte_para_megabytes)


data_0.5$currentTime <- as.POSIXct(data_0.5$currentTime, format="%Y-%m-%d %H:%M:%OS")

data_0.5 <- data_0.5[!is.na(data_0.5$currentTime), ]

min_date <- min(data_0.5$currentTime)

data_0.5$continuousTime <- as.numeric(difftime(data_0.5$currentTime, min_date, units = "hours"))

data_0.5_filtered <- data_0.5[!is.na(data_0.5$usedMemory) & !is.na(data_0.5$continuousTime),
                              ]
sum(is.na(data_0.5$currentTime))
## [1] 0
min_date
## [1] "2020-01-28 15:14:55 -03"
dim(data_0.5)
## [1] 4109   17
dim(data_0.5_filtered)
## [1] 4109   17
sum(is.na(data_0.5$usedMemory))
## [1] 0
sum(is.na(data_0.5$continuousTime))
## [1] 0
ggplot(data_0.5_filtered, aes(x = continuousTime, y = usedMemory)) +
  geom_line(color = "black") +  
  theme_minimal() + 
  theme(
    panel.background = element_rect(fill = "white"),
    panel.grid = element_blank(), 
    axis.line = element_line(color = "black"),
    plot.title = element_text(hjust = 0.5, face = "bold")
  ) +
  scale_x_continuous(breaks = seq(0, ifelse(any(is.finite(data_0.5$continuousTime)), max(data_0.5$continuousTime, na.rm = TRUE), 0), by = 10)) + 
  scale_y_continuous(
    breaks = seq(400, 1200, by = 400),
    limits = c(200, 1200)
  ) +  
  labs(x = "Time (hour)", y = "Used Memory (MB)", title = "Memory Analysis (Workload of 0.5)")

#Workload 1.0
data_1 <- read.csv("~/monitoringCloudData_1.csv")

data_1$usedMemory <- sapply(data_1$usedMemory, converte_para_megabytes)

data_1$currentTime <- as.POSIXct(data_1$currentTime, format="%Y-%m-%d %H:%M:%OS")
min_date <- min(data_1$currentTime)

data_1$continuousTime <- as.numeric(difftime(data_1$currentTime, min_date, units = "hours"))

data_1 <- data_1[!is.na(data_1$usedMemory) & !is.na(data_1$continuousTime), ]

ggplot(data_1, aes(x = continuousTime, y = usedMemory)) +
  geom_line(color = "black") +  
  theme_minimal() + 
  theme(
    panel.background = element_rect(fill = "white"),
    panel.grid = element_blank(), 
    axis.line = element_line(color = "black"),
    plot.title = element_text(hjust = 0.5, face = "bold")
  ) +
  scale_x_continuous(breaks = seq(0, max(data_1$continuousTime), by = 10)) + 
  scale_y_continuous(
    breaks = c(242, 246, 250, 254),
    limits = c(241, 255)
  ) +  
  labs(x = "Time (hour)", y = "Used Memory (MB)", title = "Memory Analysis (Workload of 1.0)")

Dados para as questões seguintes

library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.4     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.1
## ✔ lubridate 1.9.3     ✔ tibble    3.2.1
## ✔ purrr     1.0.2     ✔ tidyr     1.3.0
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(plotly)
## 
## Attaching package: 'plotly'
## 
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## 
## The following object is masked from 'package:stats':
## 
##     filter
## 
## The following object is masked from 'package:graphics':
## 
##     layout
conteudo <- read.csv("https://www.dropbox.com/s/bso7ierg8oyjjun/netflix_titles.csv?dl=1")

Questão 7

conteudo_unico_pais <- conteudo %>%
  filter(country != "") %>%
  filter(!str_detect(country, ","))

conteudo_por_pais <- conteudo_unico_pais %>%
  group_by(country) %>%
  summarize(count = n()) %>%
  arrange(desc(count))

top_10_paises <- conteudo_por_pais %>%
  head(10)

plot_ly(
  data = top_10_paises,
  labels = ~country,
  values = ~count,
  type = "pie"
)

Questão 8

conteudo_unico_pais <- conteudo %>%
  filter(country != "") %>%
  filter(!str_detect(country, ","))

conteudo_por_pais <- conteudo_unico_pais %>%
  group_by(country) %>%
  summarize(count = n()) %>%
  arrange(desc(count))

top_10_paises <- conteudo_por_pais %>%
  head(10)

plot_ly(
  type = "table",
  header = list(
    values = c("País", "Total de conteúdos"),
    align = c("center", "center"),
    line = list(width = 1.5, color = "black"),
    fill = list(color = "grey"),
    font = list(family = "Arial", size = 12, color = c("white"))
  ),
  cells = list(
    values = rbind(top_10_paises$country, top_10_paises$count),
    align = c("center", "center"),
    line = list(width = 1.5, color = "black"),
    font = list(family = "Arial", size = 12, color=c("black"))
  )
)

Questão 9

conteudo$decada <- floor(conteudo$release_year / 10) * 10

conteudo_por_decada <- conteudo %>%
  group_by(type, decada) %>%
  summarize(count = n()) %>%
  spread(type, count)
## `summarise()` has grouped output by 'type'. You can override using the
## `.groups` argument.
plot_ly(
  data = conteudo_por_decada,
  x = ~decada,
  y = ~Movie,
  name = "Movie",
  type = "scatter",
  mode = "lines+markers",
  line = list(color = "orange")
  ) %>%
  add_trace(
    x = conteudo_por_decada[["decada"]],
    y = conteudo_por_decada[["TV Show"]],
    name = "TV Show",
    type = 'scatter',
    mode = 'line+markers',
    line = list(color = "blue")
  )
## Warning: Ignoring 1 observations
## A line object has been specified, but lines is not in the mode
## Adding lines to the mode...

Questão 10

filmes_filtrado <- conteudo %>%
  filter(type == "Movie" & release_year >= 2000 & release_year <= 2010)

filmes_filtrado$genre <- sapply(strsplit(filmes_filtrado$listed_in, ", "), `[`, 1)

filme_genero_ano <- filmes_filtrado %>%
  group_by(genre, release_year) %>%
  summarize(count = n()) %>%
  spread(genre, count)
## `summarise()` has grouped output by 'genre'. You can override using the
## `.groups` argument.
filme_genero_ano <- filme_genero_ano %>%
  select(release_year, `Action & Adventure`, Comedies, Dramas)

plot_ly(
  data = filme_genero_ano,
  x = ~release_year,
  y = ~Dramas,
  name = "Drama",
  type = "bar"
) %>%
  add_trace(
    y = ~`Action & Adventure`,
    name = "Acão e Aventura"
  ) %>%
  add_trace(
    y = ~Comedies,
    name = "Comédia"
  )