stackoverflow.com questions #44988384, R

stackoverflow.com questions #44988384

Language: Layout:

#https://stackoverflow.com/questions/44988384/plot-one-histogramseparate-for-each-variable-in-the-column/44991497#44991497

dataIn = read.table(text="
ip_addr_player_id,  event_name, level, points_earned, stars_earned, moves
118.93.180.241, Puzzle Complete, Botany Lab Puzzle 1, 1000, 2,   2 
118.93.180.241, Puzzle Complete, Botany Lab Puzzle 2, 800, 2,   2 
118.93.180.241, Puzzle Complete, Botany Lab Puzzle 1, 1000, 2,   2 
203.166.252.219, Puzzle Complete, Botany Lab Puzzle 1, 1000, 2,  2     
54.166.252.324, Puzzle Complete, Botany Lab Puzzle 5, 1000, 2,  2
",header=T, sep=",")
dataIn

# get uniqe players
players=unique(dataIn$ip_addr_player_id)
players
print(players)

#library(data.table)
#loop over players
for (i in players) {
  print (sprintf("------ ip_addr_player_id=%s  ------------",i))
  #select rows for uniq ip_addr_player_id
  index=which(dataIn$ip_addr_player_id ==i)
  print(sprintf("index=%s",index))
  
  #get dataframe of the coresponding index
  p1=dataIn[index,]
  print (p1)  
  
    #data.table not supported here
 
}

[ + ] Show input
Absolute running time: 0.34 sec, cpu time: 0.45 sec, memory peak: 31 Mb, absolute service time: 0,53 sec

ip_addr_player_id event_name level points_earned 1 118.93.180.241 Puzzle Complete Botany Lab Puzzle 1 1000 2 118.93.180.241 Puzzle Complete Botany Lab Puzzle 2 800 3 118.93.180.241 Puzzle Complete Botany Lab Puzzle 1 1000 4 203.166.252.219 Puzzle Complete Botany Lab Puzzle 1 1000 5 54.166.252.324 Puzzle Complete Botany Lab Puzzle 5 1000 stars_earned moves 1 2 2 2 2 2 3 2 2 4 2 2 5 2 2 [1] 118.93.180.241 203.166.252.219 54.166.252.324 Levels: 118.93.180.241 203.166.252.219 54.166.252.324 [1] 118.93.180.241 203.166.252.219 54.166.252.324 Levels: 118.93.180.241 203.166.252.219 54.166.252.324 [1] "------ ip_addr_player_id=118.93.180.241 ------------" [1] "index=1" "index=2" "index=3" ip_addr_player_id event_name level points_earned 1 118.93.180.241 Puzzle Complete Botany Lab Puzzle 1 1000 2 118.93.180.241 Puzzle Complete Botany Lab Puzzle 2 800 3 118.93.180.241 Puzzle Complete Botany Lab Puzzle 1 1000 stars_earned moves 1 2 2 2 2 2 3 2 2 [1] "------ ip_addr_player_id=203.166.252.219 ------------" [1] "index=4" ip_addr_player_id event_name level points_earned 4 203.166.252.219 Puzzle Complete Botany Lab Puzzle 1 1000 stars_earned moves 4 2 2 [1] "------ ip_addr_player_id=54.166.252.324 ------------" [1] "index=5" ip_addr_player_id event_name level points_earned 5 54.166.252.324 Puzzle Complete Botany Lab Puzzle 5 1000 stars_earned moves 5 2 2