eigenbasis

whales_v1

Aug 18th, 2017
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.62 KB | None | 0 0
  1. boxplot(payments$total_rubies, main = "Kopējais nopirkto rubīnu skaits laika periodā Feb - Jūl 2017")
  2. summary(payments)
  3. library(psych)
  4. describe(payments)
  5. cor(payments)
  6. d<-density(payments$total_rubies)
  7. plot(d)
  8. qqnorm(payments$total_rubies, col = payCluster$cluster);qqline(payments$total_rubies, col=2)
  9. dens<-density(payments_ed$total_rubies)
  10. plot(dens)
  11. 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)
  12. set.seed(20)
  13. payCluster<-kmeans(payments_upd$total_rubies, 3, nstart = 20)
  14. payCluster
  15. payCluster$cluster <- as.factor(payCluster$cluster)
  16. library(ggplot2)
  17. ggplot(payments_upd, aes(seq_along(payments_upd$total_rubies), payments_upd$total_rubies, color = payCluster$cluster))+geom_point()
  18. payments_upd$cluster <- payCluster$cluster
  19. payments_upd$cluster[payments_upd$cluster=="3"]<-"vaļi"
  20. payments_upd$cluster <- as.character(payments_upd$cluster)
  21. payments_upd$cluster[payments_upd$cluster == "3"] <- "valis"
  22. payments_upd$cluster[payments_upd$cluster == "2"] <- "vidējais"
  23. payments_upd$cluster[payments_upd$cluster == "1"] <- "mazais"
  24. payments_upd$group <- NA
  25. index <- c("valis", "vidējais", "mazais")
  26. values <- c("3", "2", "1")
  27. payments_upd$group <- values[match(payments_upd$cluster, index)]
  28. payments_upd$group[is.na(payments_upd$group)] <- "3"
  29. 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)
  30. #-------------------------------------#
  31. ggplot(payments_upd, aes(seq_along(payments_upd$total_rubies), payments_upd$total_rubies, color = payCluster$cluster)) + geom_point()
  32. write.csv(payments_upd, file = "payments_clustered.csv")
  33. payCluster$cluster <- as.character(payCluster$cluster)
  34. payCluster$cluster[payCluster$cluster == "3"] <- "valis"
  35. payCluster$cluster[payCluster$cluster == "2"] <- "vidējais"
  36. payCluster$cluster[payCluster$cluster == "1"] <- "mazais"
  37. 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")
  38. payments_upd$level <- as.factor(payments_upd$level)
  39. payments_upd$level <- as.numeric(payments_upd$level)
  40. ggplot(payments_upd, aes(payments_upd$level,payments_upd$total_rubies, color = payCluster$cluster)) + geom_point() + ggtitle("Kopumā nopirktie rubīni vs līmenis")
  41. summary(payments_upd$level)
  42. whakes <- subset.data.frame(payments_upd, cluster == 'valis')
  43. library(ggplot2)
  44. ggplot(data = whales, aes(x = whales_pay$pay_time, y = whales_pay$rubies)) + geom_line(aes(colour = whales_pay$player_uid))
  45. typeof(whales_pay$player_uid)
  46.  
  47. # trying ESD
  48. real.users <- unique(whales_pay$player_uid)
  49. n.users <- 30
  50. n.periods <- as.numeric(whales_pay$pay_time)
  51. window <- 1/5
  52. treshold <- 2
  53. observed <- matrix(rpois(n.users * n.periods, actual), nrow = n.users)
  54. whales_ed <- data.frame(whales_pay$player_uid, whales_pay$rubies, whales_pay$pay_time)
  55. library(dygraphs)
  56. dygraph(whales_ed)
  57.  
  58.  
  59. whales <- data.frame(whales_pay$player_uid, whales_pay$rubies, whales_pay$pay_time)
  60. whales$whales_pay.pay_time
  61. library(plyr)
  62. whales <- rename(whales, c("whales_pay.player_uid" = "player_id", "whales_pay.rubies" = "rubies", "whales_pay.pay_time" = "pay_time"))
  63. whales$player_id <- as.character(whales$player_id)
  64. whales$pay_time <- as.Date(whales$pay_time, "%Y-%M-%d %H:%M:%S")
  65. typeof(whales$rubies)
  66. smooth(whales$rubies)
  67. whales_list <- unique(whales$player_id)
  68. whales_list
  69. whale_31196 <- subset(whales, whales$player_id == "31196")
  70. whale_683239 <- subset(whales, whales$player_id == "683239")
  71. ggplot(data = whale_31196, aes(x = whale_31196$pay_time, y = whale_31196$rubies)) + geom_line(col = "springgreen")
  72. library(ggplot2)
  73. colors()
  74. 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))
  75. points(whale_5037681$pay_time, whale_5037681$rubies, pch = 16, col = adjustcolor("aquamarine", alpha = 0.25))
  76. points(whale_4944966$pay_time, whale_4944966$rubies, pch = 16, col = adjustcolor("chartreuse", alpha = 0.25))
  77. points(whale_4771846$pay_time, whale_4771846$rubies, pch = 16, col = adjustcolor("cyan", alpha = 0.25))
  78. points(whale_4343389$pay_time, whale_4343389$rubies, pch = 16, col = adjustcolor("darkolivegreen4", alpha = 0.25))
  79. points(whale_5249791$pay_time, whale_5249791$rubies, pch = 16, col = adjustcolor("darkorange", alpha = 0.25))
  80. points(whale_4241887$pay_time, whale_4241887$rubies, pch = 16, col = adjustcolor("darkslateblue", alpha = 0.25))
  81. points(whale_5418405$pay_time, whale_5418405$rubies, pch = 16, col = adjustcolor("firebrick1", alpha = 0.25))
  82. points(whale_4136237$pay_time, whale_4136237$rubies, pch = 16, col = adjustcolor("gold", alpha = 0.25))
  83. points(whale_3157768$pay_time, whale_3157768$rubies, pch = 16, col = adjustcolor("green", alpha = 0.25))
  84. points(whale_3398937$pay_time, whale_3398937$rubies, pch = 16, col = adjustcolor("greenyellow", alpha = 0.25))
  85. points(whale_2994428$pay_time, whale_2994428$rubies, pch = 16, col = adjustcolor("hotpink", alpha = 0.25))
  86. points(whale_3996220$pay_time, whale_3996220$rubies, pch = 16, col = adjustcolor("khaki1", alpha = 0.25))
  87. points(whale_1436318$pay_time, whale_1436318$rubies, pch = 16, col = adjustcolor("limegreen", alpha = 0.25))
  88. points(whale_1855426$pay_time, whale_1855426$rubies, pch = 16, col = adjustcolor("mediumpurple4", alpha = 0.25))
  89. points(whale_1435930$pay_time, whale_1435930$rubies, pch = 16, col = adjustcolor("navy", alpha = 0.25))
  90. points(whale_171348$pay_time, whale_171348$rubies, pch = 16, col = adjustcolor("orange", alpha = 0.25))
  91. points(whale_158796$pay_time, whale_158796$rubies, pch = 16, col = adjustcolor("orangered", alpha = 0.25))
  92. points(whale_1235259$pay_time, whale_1235259$rubies, pch = 16, col = adjustcolor("palevioletred", alpha = 0.25))
  93. points(whale_1348187$pay_time, whale_1348187$rubies, pch = 16, col = adjustcolor("plum", alpha = 0.25))
  94. points(whale_1395616$pay_time, whale_1395616$rubies, pch = 16, col = adjustcolor("powderblue", alpha = 0.25))
  95. points(whale_5202761$pay_time, whale_5202761$rubies, pch = 16, col = adjustcolor("blue", alpha = 0.25))
  96. points(whale_31196$pay_time, whale_31196$rubies, pch = 16, col = adjustcolor("red", alpha = 0.25))
  97. points(whale_361307$pay_time, whale_361307$rubies, pch = 16, col = adjustcolor("royalblue", alpha = 0.25))
  98. points(whale_459809$pay_time, whale_459809$rubies, pch = 16, col = adjustcolor("seagreen", alpha = 0.25))
  99. points(whale_818443$pay_time, whale_818443$rubies, pch = 16, col = adjustcolor("springgreen", alpha = 0.25))
  100. points(whale_1198380$pay_time, whale_1198380$rubies, pch = 16, col = adjustcolor("steelblue", alpha = 0.25))
  101. points(whale_743892$pay_time, whale_743892$rubies, pch = 16, col = adjustcolor("turquoise1", alpha = 0.25))
  102. points(whale_683239$pay_time, whale_683239$rubies, pch = 16, col = adjustcolor("violet", alpha = 0.25))
  103. points(whale_944480$pay_time, whale_944480$rubies, pch = 16, col = adjustcolor("yellow2", alpha = 0.25))
  104. axis(side = 2, at = c(500), col = "red")
  105. axis(side = 2, at = c(100), col = "red")
  106. axis(side = 2, at = c(50), col = "red")
  107.  
  108. #smoothening
  109. whale_5418405$index <- 1:nrow(whale_5418405)
  110. loess50_whale_5418405 <- loess(whale_5418405$rubies ~ whale_5418405$index, data = whale_5418405, span = 0.50)
  111. smoothed50_whale_5418405 <- predict(loess50_whale_5418405)
  112. 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")
  113. lines(smoothed50_whale_944480, x = whale_944480$pay_time, col = adjustcolor("yellow2", alpha = 0.5), lwd = 5)
  114.  
  115. #whales in 2017
  116. whale_2017_944480 <- subset(whale_944480, whale_944480$pay_time >= "2017-01-01")
  117. whale_2017_944480$index <- 1:nrow(whale_2017_944480)
  118. loess50_whale_2017_944480 <- loess(whale_2017_944480$rubies ~ whale_2017_944480$index, data = whale_2017_944480, span = 0.50)
  119. smoothed50_whale_2017_944480 <- predict(loess50_whale_2017_944480)
  120. 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")
  121. lines(smoothed50_whale_2017_944480, x = whale_2017_944480$pay_time, col = adjustcolor("yellow2", alpha = 0.5), lwd = 5)
  122. 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))
  123.  
  124. #-----------------------------#
  125. #Additional plots
  126. 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)
  127. 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")
  128. 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")
  129. 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")
  130. 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