[Solved] How I can find out 1st and last observation with in group in R for every by group
[ad_1] Here is an option with data.table_1.9.5. Create the “data.table” from “data.frame” using setDT, remove the NA values in “dialled” column (!is.na(dialled)), generate grouping variable by using rleid on “Dialled_nbr”, get the row index of the first and last rows for the levels of grouping variable (.I(c(1L, .N)]), finally subset the “dt1” based on the … Read more