Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- boxplot(payments$total_rubies, main = "Kopējais nopirkto rubīnu skaits laika periodā Feb - Jūl 2017")
- summary(payments)
- library(psych)
- describe(payments)
- cor(payments)
- d<-density(payments$total_rubies)
- plot(d)
- qqnorm(payments$total_rubies, col = payCluster$cluster);qqline(payments$total_rubies, col=2)
- dens<-density(payments_ed$total_rubies)
- plot(dens)
- qqnorm(payments_ed$total_rubies, main = "Kopējo rubīnu QQplots", xlab = " ", ylab = "Kopējo rubīnu skaits spēlētājam", col = );qqline(payments_ed$total_rubies, col=2)
- set.seed(20)
- payCluster<-kmeans(payments_upd$total_rubies, 3, nstart = 20)
- payCluster
- payCluster$cluster <- as.factor(payCluster$cluster)
- library(ggplot2)
- ggplot(payments_upd, aes(seq_along(payments_upd$total_rubies), payments_upd$total_rubies, color = payCluster$cluster))+geom_point()
- payments_upd$cluster <- payCluster$cluster
- payments_upd$cluster[payments_upd$cluster=="3"]<-"vaļi"
- payments_upd$cluster <- as.character(payments_upd$cluster)
- payments_upd$cluster[payments_upd$cluster == "3"] <- "valis"
- payments_upd$cluster[payments_upd$cluster == "2"] <- "vidējais"
- payments_upd$cluster[payments_upd$cluster == "1"] <- "mazais"
- payments_upd$group <- NA
- index <- c("valis", "vidējais", "mazais")
- values <- c("3", "2", "1")
- payments_upd$group <- values[match(payments_upd$cluster, index)]
- payments_upd$group[is.na(payments_upd$group)] <- "3"
- qqnorm(payments_upd$total_rubies, main = "Kopējo rubīnu QQplots", xlab = " ", ylab = "Kopējo rubīnu skaits spēlētājam", col = payments_upd$group);qqline(payments_ed$total_rubies, col=2)
- #-------------------------------------#
- ggplot(payments_upd, aes(seq_along(payments_upd$total_rubies), payments_upd$total_rubies, color = payCluster$cluster)) + geom_point()
- write.csv(payments_upd, file = "payments_clustered.csv")
- payCluster$cluster <- as.character(payCluster$cluster)
- payCluster$cluster[payCluster$cluster == "3"] <- "valis"
- payCluster$cluster[payCluster$cluster == "2"] <- "vidējais"
- payCluster$cluster[payCluster$cluster == "1"] <- "mazais"
- ggplot(payments_upd, aes(payments_upd$seperate_purchases, payments_upd$total_rubies, color = payCluster$cluster)) + geom_point() + ggtitle("Kopumā nopirktie rubīni vs atsevišķu pirkumu skaits")
- payments_upd$level <- as.factor(payments_upd$level)
- payments_upd$level <- as.numeric(payments_upd$level)
- ggplot(payments_upd, aes(payments_upd$level,payments_upd$total_rubies, color = payCluster$cluster)) + geom_point() + ggtitle("Kopumā nopirktie rubīni vs līmenis")
- summary(payments_upd$level)
- whakes <- subset.data.frame(payments_upd, cluster == 'valis')
- library(ggplot2)
- ggplot(data = whales, aes(x = whales_pay$pay_time, y = whales_pay$rubies)) + geom_line(aes(colour = whales_pay$player_uid))
- typeof(whales_pay$player_uid)
- # trying ESD
- real.users <- unique(whales_pay$player_uid)
- n.users <- 30
- n.periods <- as.numeric(whales_pay$pay_time)
- window <- 1/5
- treshold <- 2
- observed <- matrix(rpois(n.users * n.periods, actual), nrow = n.users)
- whales_ed <- data.frame(whales_pay$player_uid, whales_pay$rubies, whales_pay$pay_time)
- library(dygraphs)
- dygraph(whales_ed)
- whales <- data.frame(whales_pay$player_uid, whales_pay$rubies, whales_pay$pay_time)
- whales$whales_pay.pay_time
- library(plyr)
- whales <- rename(whales, c("whales_pay.player_uid" = "player_id", "whales_pay.rubies" = "rubies", "whales_pay.pay_time" = "pay_time"))
- whales$player_id <- as.character(whales$player_id)
- whales$pay_time <- as.Date(whales$pay_time, "%Y-%M-%d %H:%M:%S")
- typeof(whales$rubies)
- smooth(whales$rubies)
- whales_list <- unique(whales$player_id)
- whales_list
- whale_31196 <- subset(whales, whales$player_id == "31196")
- whale_683239 <- subset(whales, whales$player_id == "683239")
- ggplot(data = whale_31196, aes(x = whale_31196$pay_time, y = whale_31196$rubies)) + geom_line(col = "springgreen")
- library(ggplot2)
- colors()
- plot(whale_329393$pay_time, whale_329393$rubies, main = "All inidividual payments by whales", xlab = "Pay date", ylab = "Rubies bought", pch = 16, col = adjustcolor("purple", alpha = 0.25), ylim = c(0, 1100))
- points(whale_5037681$pay_time, whale_5037681$rubies, pch = 16, col = adjustcolor("aquamarine", alpha = 0.25))
- points(whale_4944966$pay_time, whale_4944966$rubies, pch = 16, col = adjustcolor("chartreuse", alpha = 0.25))
- points(whale_4771846$pay_time, whale_4771846$rubies, pch = 16, col = adjustcolor("cyan", alpha = 0.25))
- points(whale_4343389$pay_time, whale_4343389$rubies, pch = 16, col = adjustcolor("darkolivegreen4", alpha = 0.25))
- points(whale_5249791$pay_time, whale_5249791$rubies, pch = 16, col = adjustcolor("darkorange", alpha = 0.25))
- points(whale_4241887$pay_time, whale_4241887$rubies, pch = 16, col = adjustcolor("darkslateblue", alpha = 0.25))
- points(whale_5418405$pay_time, whale_5418405$rubies, pch = 16, col = adjustcolor("firebrick1", alpha = 0.25))
- points(whale_4136237$pay_time, whale_4136237$rubies, pch = 16, col = adjustcolor("gold", alpha = 0.25))
- points(whale_3157768$pay_time, whale_3157768$rubies, pch = 16, col = adjustcolor("green", alpha = 0.25))
- points(whale_3398937$pay_time, whale_3398937$rubies, pch = 16, col = adjustcolor("greenyellow", alpha = 0.25))
- points(whale_2994428$pay_time, whale_2994428$rubies, pch = 16, col = adjustcolor("hotpink", alpha = 0.25))
- points(whale_3996220$pay_time, whale_3996220$rubies, pch = 16, col = adjustcolor("khaki1", alpha = 0.25))
- points(whale_1436318$pay_time, whale_1436318$rubies, pch = 16, col = adjustcolor("limegreen", alpha = 0.25))
- points(whale_1855426$pay_time, whale_1855426$rubies, pch = 16, col = adjustcolor("mediumpurple4", alpha = 0.25))
- points(whale_1435930$pay_time, whale_1435930$rubies, pch = 16, col = adjustcolor("navy", alpha = 0.25))
- points(whale_171348$pay_time, whale_171348$rubies, pch = 16, col = adjustcolor("orange", alpha = 0.25))
- points(whale_158796$pay_time, whale_158796$rubies, pch = 16, col = adjustcolor("orangered", alpha = 0.25))
- points(whale_1235259$pay_time, whale_1235259$rubies, pch = 16, col = adjustcolor("palevioletred", alpha = 0.25))
- points(whale_1348187$pay_time, whale_1348187$rubies, pch = 16, col = adjustcolor("plum", alpha = 0.25))
- points(whale_1395616$pay_time, whale_1395616$rubies, pch = 16, col = adjustcolor("powderblue", alpha = 0.25))
- points(whale_5202761$pay_time, whale_5202761$rubies, pch = 16, col = adjustcolor("blue", alpha = 0.25))
- points(whale_31196$pay_time, whale_31196$rubies, pch = 16, col = adjustcolor("red", alpha = 0.25))
- points(whale_361307$pay_time, whale_361307$rubies, pch = 16, col = adjustcolor("royalblue", alpha = 0.25))
- points(whale_459809$pay_time, whale_459809$rubies, pch = 16, col = adjustcolor("seagreen", alpha = 0.25))
- points(whale_818443$pay_time, whale_818443$rubies, pch = 16, col = adjustcolor("springgreen", alpha = 0.25))
- points(whale_1198380$pay_time, whale_1198380$rubies, pch = 16, col = adjustcolor("steelblue", alpha = 0.25))
- points(whale_743892$pay_time, whale_743892$rubies, pch = 16, col = adjustcolor("turquoise1", alpha = 0.25))
- points(whale_683239$pay_time, whale_683239$rubies, pch = 16, col = adjustcolor("violet", alpha = 0.25))
- points(whale_944480$pay_time, whale_944480$rubies, pch = 16, col = adjustcolor("yellow2", alpha = 0.25))
- axis(side = 2, at = c(500), col = "red")
- axis(side = 2, at = c(100), col = "red")
- axis(side = 2, at = c(50), col = "red")
- #smoothening
- whale_5418405$index <- 1:nrow(whale_5418405)
- loess50_whale_5418405 <- loess(whale_5418405$rubies ~ whale_5418405$index, data = whale_5418405, span = 0.50)
- smoothed50_whale_5418405 <- predict(loess50_whale_5418405)
- plot(whale_1198380$rubies, x = whale_1198380$pay_time, pch = 16, col = adjustcolor("black", alpha = 0.001), main = "Smoothed whales", xlab = "Pay date", ylab = "Rubies bought", bg = "blue")
- lines(smoothed50_whale_944480, x = whale_944480$pay_time, col = adjustcolor("yellow2", alpha = 0.5), lwd = 5)
- #whales in 2017
- whale_2017_944480 <- subset(whale_944480, whale_944480$pay_time >= "2017-01-01")
- whale_2017_944480$index <- 1:nrow(whale_2017_944480)
- loess50_whale_2017_944480 <- loess(whale_2017_944480$rubies ~ whale_2017_944480$index, data = whale_2017_944480, span = 0.50)
- smoothed50_whale_2017_944480 <- predict(loess50_whale_2017_944480)
- plot(whale_2017_31196$rubies, x = whale_2017_31196$pay_time, pch = 16, col = adjustcolor("black", alpha = 0.001), main = "Smoothed whales in 2017", xlab = "Pay date", ylab = "Rubies bought", bg = "blue")
- lines(smoothed50_whale_2017_944480, x = whale_2017_944480$pay_time, col = adjustcolor("yellow2", alpha = 0.5), lwd = 5)
- plot(whale_2017_4136237$pay_time, whale_2017_4136237$rubies, main = "Whale 2017 4136237", xlab = "Pay date", ylab = "Rubies bought", pch = 16, col = adjustcolor("gold", alpha = 0.5))
- #-----------------------------#
- #Additional plots
- ggplot(payments_upd, aes(payments_upd$level,payments_upd$total_rubies, color = payCluster$cluster)) + geom_point(aes(alpha = 0.25)) + ggtitle("Kopumā nopirktie rubīni vs līmenis") + geom_vline(xintercept = 50) + xlab("Līmenis") + ylab("Nopirktie rubīni") + guides(fill=FALSE)
- plot(whale_361307$pay_time, whale_361307$rubies, pch = 16, col = adjustcolor("royalblue", alpha = 0.25), main = "Valis 361307", xlab = "Maksājuma laiks", ylab = "Nopirktā paka")
- plot(whale_4136237$pay_time, whale_4136237$rubies, pch = 16, col = adjustcolor("gold", alpha = 0.5), main = "Valis 4136237", xlab = "Maksājuma laiks", ylab = "Nopirktā paka")
- plot(whale_4944966$pay_time, whale_4944966$rubies, pch = 16, col = adjustcolor("chartreuse", alpha = 0.5), main = "Valis 4944966", xlab = "Maksājuma laiks", ylab = "Nopirktā paka")
- plot(whale_3398937$pay_time, whale_3398937$rubies, pch = 16, col = adjustcolor("greenyellow", alpha = 0.5), main = "Valis 3398937", xlab = "Maksājuma laiks", ylab = "Nopirktā paka")
Advertisement
Add Comment
Please, Sign In to add comment