Join & Concatenation Examples

On adult.csv data set: 1. calculate the average age and number of rows for the 4 groups (sex, income) and join the corresponding 2 values to each row in the group; 2. extract people with age between 20 and 40 and working in a work group starting with "S" and people with age between 40 and 60 and working in the Private sector (workclass starts with "P"). Put both groups in a single data table.


This is a companion discussion topic for the original entry at https://kni.me/w/1EpJ3nS0z0Ml5shH