How do I do that in data.table? Find code for dozens of data tasks in this searchable cheat sheet of R data.table ... multiple if else statements (like SQL’s CASE) Calculate # Needs data.table ...