Tutorial by Examples

# example data DT <- data.table(Titanic) Suppose that, for each sex, we want the rows with the highest survival numbers: DT[Survived == "Yes", .SD[ N == max(N) ], by=Sex] # Class Sex Age Survived N # 1: Crew Male Adult Yes 192 # 2: 1st Female Adult Yes...

# example data DT = data.table(Titanic) Suppose we only want to see second class: DT[ Class == "2nd" ] # Class Sex Age Survived N # 1: 2nd Male Child No 0 # 2: 2nd Female Child No 0 # 3: 2nd Male Adult No 154 # 4: 2nd Female Adult ...

# example data DT = data.table(Titanic) Suppose we want to see each class only if a majority survived: DT[, if (sum(N[Survived=="Yes"]) > sum(N[Survived=="No"]) ) .SD, by=Class] # Class Sex Age Survived N # 1: 1st Male Child No 0 # 2: 1st Fema...