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,ylab="Response Time(sec.)",xlab="Time between Things requestes(seconds)",)
lines(clock,MRT_3F,type="o",pch=11,col="yellow")
lines(clock,MRT_5F,type="o",pch=1,col="red")
lines(clock,MRT_10F,type="o",pch=2,col="blue")
lines(clock,MRT_15F,type="o",pch=5,col="purple")
lines(clock,MRT_sem_F,type="o",pch=4,col="green")
legend("topright",pch=c(4,11,1,2,5,4),col=c("black","yellow","red","blue","purple","green"),legend=c("1 Fog","3 Fog","5 Fog","10 Fog","15 Fog","w/o Fog"))

layout(matrix(c(1, 2,
               1, 2,
               3, 4,
               3, 4,
               5, 6,
               5, 6
               ), nrow=3, ncol=2, byrow=TRUE))

barplot(rbind(MRT_sem_F,MRT_1F),log="y",ylab="Response Time(s)",xlab="Time between Things requestes",names.arg=clock,col=c("#E6E6E6", "#666666"),beside = T)
legend("topright",pch=15,col=c("#E6E6E6", "#666666"),legend = c("w/o Fog","1 Fog"))
barplot(rbind(MRT_sem_F,MRT_3F),log="y",ylab="Response Time(s)",xlab="Time between Things requestes",names.arg=clock,col=c("#E6E6E6", "#666666"),beside = T)
legend("topright",pch=15,col=c("#E6E6E6", "#666666"),legend = c("w/o Fog","3 Fog"))
barplot(rbind(MRT_sem_F,MRT_5F),log="y",ylab="Response Time(s)",xlab="Time between Things requestes",names.arg=clock,col=c("#E6E6E6", "#666666"),beside = T)
legend("topright",pch=15,col=c("#E6E6E6", "#666666"),legend = c("w/o Fog","5 Fog"))
barplot(rbind(MRT_sem_F,MRT_10F),log="y",ylab="Response Time(s)",xlab="Time between Things requestes",names.arg=clock,col=c("#E6E6E6", "#666666"),beside = T)
legend("topright",pch=15,col=c("#E6E6E6", "#666666"),legend = c("w/o Fog","10 Fog"))

barplot(rbind(MRT_sem_F,MRT_5F),log="y",ylab="Response Time(s)",xlab="Time between Things requestes",names.arg=clock,col=c("#E6E6E6", "#666666"),beside = T)
legend("topright",pch=15,col=c("#E6E6E6", "#666666"),legend = c("w/o Fog","15 Fog"))

2

Meal_Price<-data.frame(QualityRanking= c("Good","Very Good","Excellent"),
                       S10a19= c(53.8,43.6,2.6),
                       S20a29= c(33.9,54.2,11.9),
                       S30a39= c(2.6,60.5,30.8),
                       S40a49= c(0,21.4,78.6))
MealPrice<-cbind(S10a19= c(53.8,43.6,2.6),S20a29= c(33.9,54.2,11.9), S30a39= c(2.6,60.5,30.8),S40a49= c(0,21.4,78.6))
colnames(MealPrice)<-c("$10-19","$20-29","$30-39","$40-49")
rownames(MealPrice)<-c("Good","Very Good","Excellent")

barplot(MealPrice,ylab="Preco",xlab="Qualidade",names.arg = colnames(MealPrice),legend.text = rownames(MealPrice))

3

AirQuality<- airquality
AirQuality$Temp <- (AirQuality$Temp-32)/1.8
hist(AirQuality$Temp[AirQuality$Month==5],main="Histograma Temperatura",col="Blue", xlab = "Temperatura",ylab = "Freaquencia",freq = F)
lines(density(AirQuality$Temp[AirQuality$Month==5]))

4

sales <- read.table("https://training-course-material.com/images/8/8f/Sales.txt",header=TRUE)
salesPercent<-round(sales[,2]/sum(sales[,2])*100)
salesPercent<-paste(sales[,1],salesPercent)
salesPercent<-paste(salesPercent,"%",sep="")
pie(sales[,2],salesPercent,main = "Total de Vendas por Pais",col=rainbow(length(sales[,1])))
legend("topright",pch = 15, col = rainbow(length(sales[,1])),legend = sales[,1])

5

insectcount<-InsectSprays
boxplot(insectcount$count~insectcount$spray,col = "yellow", outline = F,ylab="Unidades",xlab="Spray",main="Insect Sprays")

6

mcd0.1<-read.csv("C:/Users/Lucas Carneiro/Downloads/R_Scripts/Arquivos_exercicio12/monitoringCloudData_0.1.csv")
mcd0.5<-read.csv("C:/Users/Lucas Carneiro/Downloads/R_Scripts/Arquivos_exercicio12/monitoringCloudData_0.5.csv")
mcd1<-read.csv("C:/Users/Lucas Carneiro/Downloads/R_Scripts/Arquivos_exercicio12/monitoringCloudData_1.csv")
mcdNone<-read.csv("C:/Users/Lucas Carneiro/Downloads/R_Scripts/Arquivos_exercicio12/monitoringCloudData_NONE.csv")

mcd0.1$currentTime<-difftime(mcd0.1$currentTime,mcd0.1$currentTime[1],units="hours")
mcd0.5$currentTime<-difftime(mcd0.5$currentTime,min(mcd0.5$currentTime),units="hours")
mcd1$currentTime<-difftime(mcd1$currentTime,mcd1$currentTime[1],units="hours")
mcdNone$currentTime<-difftime(mcdNone$currentTime,mcdNone$currentTime[1],units="hours")

vetorAux<-grep(pattern = "GB$",mcd0.1$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "GB$",mcd0.1$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1024*as.numeric(sub(("GB"),"",vetorAux2)),"MB")
mcd0.1$usedMemory[vetorAux]<-vetorAux2
vetorAux<-grep(pattern = "TB$",mcd0.1$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "TB$",mcd0.1$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1000000*as.numeric(sub(("TB"),"",vetorAux2)),"MB")
mcd0.1$usedMemory[vetorAux]<-vetorAux2
mcd0.1Aux<-data.frame(currentTimeH=mcd0.1$currentTime,usedMemoryMB=mcd0.1$usedMemory)
mcd0.1Aux$currentTimeH<-as.numeric(sub((" hours"),"",mcd0.1Aux$currentTimeH))
mcd0.1Aux$usedMemoryMB<-as.numeric(sub(("MB"),"",mcd0.1Aux$usedMemoryMB))

vetorAux<-grep(pattern = "GB$",mcd0.5$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "GB$",mcd0.5$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1024*as.numeric(sub(("GB"),"",vetorAux2)),"MB")
mcd0.5$usedMemory[vetorAux]<-vetorAux2
vetorAux<-grep(pattern = "TB$",mcd0.5$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "TB$",mcd0.5$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1000000*as.numeric(sub(("TB"),"",vetorAux2)),"MB")
mcd0.5$usedMemory[vetorAux]<-vetorAux2
mcd0.5Aux<-data.frame(currentTimeH=mcd0.5$currentTime,usedMemoryMB=mcd0.5$usedMemory)
mcd0.5Aux$currentTimeH<-as.numeric(sub((" hours"),"",mcd0.5Aux$currentTimeH))
mcd0.5Aux$usedMemoryMB<-as.numeric(sub(("MB"),"",mcd0.5Aux$usedMemoryMB))

vetorAux<-grep(pattern = "GB$",mcd1$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "GB$",mcd1$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1024*as.numeric(sub(("GB"),"",vetorAux2)),"MB")
mcd1$usedMemory[vetorAux]<-vetorAux2
vetorAux<-grep(pattern = "TB$",mcd1$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "TB$",mcd1$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1000000*as.numeric(sub(("TB"),"",vetorAux2)),"MB")
mcd1$usedMemory[vetorAux]<-vetorAux2
mcd1Aux<-data.frame(currentTimeH=mcd1$currentTime,usedMemoryMB=mcd1$usedMemory)
mcd1Aux$currentTimeH<-as.numeric(sub((" hours"),"",mcd1Aux$currentTimeH))
mcd1Aux$usedMemoryMB<-as.numeric(sub(("MB"),"",mcd1Aux$usedMemoryMB))

vetorAux<-grep(pattern = "GB$",mcdNone$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "GB$",mcdNone$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1024*as.numeric(sub(("GB"),"",vetorAux2)),"MB")
mcdNone$usedMemory[vetorAux]<-vetorAux2
vetorAux<-grep(pattern = "TB$",mcdNone$usedMemory, value = F, invert = F)
vetorAux2<-grep(pattern = "TB$",mcdNone$usedMemory, value = T, invert = F)
vetorAux2<-paste0(1000000*as.numeric(sub(("TB"),"",vetorAux2)),"MB")
mcdNone$usedMemory[vetorAux]<-vetorAux2
mcdNoneAux<-data.frame(currentTimeH=mcdNone$currentTime,usedMemoryMB=mcdNone$usedMemory)
mcdNoneAux$currentTimeH<-as.numeric(sub((" hours"),"",mcdNoneAux$currentTimeH))
mcdNoneAux$usedMemoryMB<-as.numeric(sub(("MB"),"",mcdNoneAux$usedMemoryMB))


par(mfrow=c(2,2))

plot(mcdNoneAux$currentTimeH,mcdNoneAux$usedMemoryMB,type="l",pch=4,ylab="Used Memory (MB)",xlab="Time (hour)",main="Memory Analysis (None Workload)")
plot(mcd0.1Aux$currentTimeH,mcd0.1Aux$usedMemoryMB,type="l",pch=4,ylab="Used Memory (MB)",xlab="Time (hour)",main="Memory Analysis (Workload of 0.1)")
plot(mcd0.5Aux$currentTimeH,mcd0.5Aux$usedMemoryMB,type="l",pch=4,ylab="Used Memory (MB)",xlab="Time (hour)",main="Memory Analysis (Workload of 0.5)")
plot(mcd1Aux$currentTimeH,mcd1Aux$usedMemoryMB,type="l",pch=4,ylab="Used Memory (MB)",xlab="Time (hour)",main="Memory Analysis (Workload of 1.0)")

7

netflix_titles <- read.csv(file = "C:/Users/Lucas Carneiro/Downloads/R_Scripts/Arquivos_exercicio12/netflix_titles.csv",
                            header = TRUE,
                            strip.white = TRUE,
                            na.strings = "")
netflix_titles <- netflix_titles %>%
  filter(!is.na(country) & country != "" & !grepl(",", country)) %>%
  filter(!is.na(country) & country != "" & !grepl(",", country))
top_countries <- netflix_titles %>%
  group_by(country) %>%
  summarise(count = n()) %>%
  arrange(desc(count)) %>%
  head(10)
plot_ly(labels = top_countries$country, values = top_countries$count, type = "pie",
        textinfo = "label+percent", insidetextfont = list(color = "#FFFFFF"),
        hoverinfo = "label+percent", hole = 0.6) %>%
  layout(title = "10 Paises com Mais Conteudo na Netflix",
         xaxis = list(showgrid = FALSE, zeroline = FALSE, showticklabels = FALSE),
         yaxis = list(showgrid = FALSE, zeroline = FALSE, showticklabels = FALSE),
         width = 900,  
         height = 800) 

8

top_countries <- netflix_titles %>%
  group_by(country) %>%
  summarise(count = n()) %>%
  arrange(desc(count)) %>%
  head(10)

table <- plot_ly(
  type = "table",
  header = list(values = c("Pais", "Total de Conteudos"),
                fill = list(color = "#a9a9a9"),
                align = c("center"),
                font = list(color = "white", size = 15)),
  cells = list(values = list(top_countries$country, top_countries$count),
               align = c("center"),
               font = list(color = c("black", "black"), size = 12))
)

table

9

netflix <- read.csv(file = "C:/Users/Lucas Carneiro/Downloads/R_Scripts/Arquivos_exercicio12/netflix_titles.csv")
netflix <- netflix %>%
  mutate(decade = 10 * (release_year %/% 10))

filmesPorDecada <- netflix %>%
  filter(type == "Movie") %>%
  group_by(decade) %>%
  summarise(qtd_conteudo = n())


seriesPorDecada <- netflix %>%
  filter(type == "TV Show") %>%
  group_by(decade) %>%
  summarise(num_series = n())


seriesFilmes <- left_join(filmesPorDecada, seriesPorDecada, by = "decade")

seriesFilmes$num_series[2] <- 1



fig <- plot_ly(
  seriesFilmes, 
  x = ~decade
) %>%
  add_trace(
    y = ~num_series,
    name = 'TV Series',
    mode = 'lines+markers',
    line = list(color = 'blue'),  
    marker = list(color = 'blue') 
  ) %>%
  add_trace(
    y = ~qtd_conteudo,
    name = 'Movies',
    mode = 'lines+markers',
    line = list(color = 'orange'),  
    marker = list(color = 'orange') 
  ) %>%
  layout(
    xaxis = list(title = 'Decada'),  
    yaxis = list(title = 'Qtd. Conteúdo') 
  )

fig
## No trace type specified:
##   Based on info supplied, a 'scatter' trace seems appropriate.
##   Read more about this trace type -> https://plotly.com/r/reference/#scatter
## No trace type specified:
##   Based on info supplied, a 'scatter' trace seems appropriate.
##   Read more about this trace type -> https://plotly.com/r/reference/#scatter

10

netflix <- read.csv("C:/Users/Lucas Carneiro/Downloads/R_Scripts/Arquivos_exercicio12/netflix_titles.csv")

df_filtrado <- netflix %>%
  filter(between(release_year, 2000, 2010) & type == "Movie") %>%
  select(release_year, listed_in)


contagem_categorias_por_ano <- df_filtrado %>%
  mutate(primeira_categoria = ifelse(str_detect(listed_in, ","), word(listed_in, 1, sep = ", "), listed_in)) %>%
  group_by(release_year, primeira_categoria) %>%
  summarise(num_filmes = n())
## `summarise()` has grouped output by 'release_year'. You can override using the
## `.groups` argument.
categorias <- c("Action & Adventure", "Comedies", "Dramas")
df_final <- contagem_categorias_por_ano %>%
  filter(primeira_categoria %in% categorias)


df_grafico <- data.frame(release_year = 2000:2010)


df_grafico <- df_grafico %>%
  left_join(
    df_final %>%
      filter(str_detect(primeira_categoria, "Comedies")) %>%
      select(release_year, num_filmes) %>%
      rename(Comedies = num_filmes),
    by = "release_year"
  ) %>%
  left_join(
    df_final %>%
      filter(str_detect(primeira_categoria, "Dramas")) %>%
      select(release_year, num_filmes) %>%
      rename(Dramas = num_filmes),
    by = "release_year"
  ) %>%
  left_join(
    df_final %>%
      filter(str_detect(primeira_categoria, "Action & Adventure")) %>%
      select(release_year, num_filmes) %>%
      rename(`ActionAdventure` = num_filmes),
    by = "release_year"
  )


fig <- plot_ly(
  df_grafico,
  x = ~release_year,
  type = 'bar',
  y = ~Dramas,
    name = 'Drama',
    line = list(color = 'blue'),  
    marker = list(color = 'blue')
   
) %>%
  add_trace(
    y = ~ActionAdventure,
    name = 'Acao e Aventura',
    line = list(color = 'orange'),  
    marker = list(color = 'orange') 
  ) %>%
  add_trace(
     y = ~Comedies,
    name = 'Comédia',
    line = list(color = 'green'),  
    marker = list(color = 'green')
  ) %>%
  layout(
    yaxis = list(title = 'Qnt. de Lancamentos'),
    xaxis = list(title = 'Ano de Lancamento')
)

fig