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"
)