Here are the dataset columns. Find the number of unique employee IDs for employees over the age of 36 for at least one record. Find the number of records for employees with 0 children, the number for employees with 1 child, and so on. Given your answer as a Series with index equal to the number of children and values equal to the corresponding number of records, sorted by number of children from least to most. Find the mean number of hours absent for records where the employee was absent due to diseases of the genitourinary system. Among the records for absences that were less than 4 hours, find the percentage that involved social drinkers. (Be sure your answer is in percentage and not proportion. Do not include the % symbol. (Can someone help me code these in Python using numpy and pandas and preferably without loops?)
90 172 178
3 31 31 24 8
ane
11 33
26
289 118 179 279 280 179 361 260 155 235 260 260 179 179 246 179 179 189 330 179
13 18 50 18 14 39 13 33 18 38 3| 28 11 36 14 34 14 37 11 36 11 18 18 38 16 41 18 38 18 38 13 33 4 28 18 38 3 28 11 36 13 33 e 28 13 33 9 29 13 33 18 28 18 12 48 14 37 12 48 18 3 28 13 33 12 12 48 11 18 38 13 43 14 3 10 37 18 38 12 40 | 11| 36 12 40
239,65 239,554 239,554 239,554 239,554 239,554 239,554 239,554 239,564 239,554 239,554 239,554 239,554 239,554 239,554 239,554 239,564 239,554 205,917 205,917 205,917 205,917 205,917 205,917 205,917 205,917 205,917 205,917 205,917 206,917 205,917 205,917 205,917 205,917 205,917 205,917 205,917 205,917 241,476 241,476 241,476 241,476 241,476 241,476 241,476 241,476
97 26 26 26 6 26 26 6 6 6 6
2
13
0
7 11
168 172 170 172 168 196 172 168 168 170 170
36 51 52 50 12 11 50 50 51 51 25 51 51 29 16 51 52 50 36 52 36 27 36 51 5 29 11 29 51 52 36 50 29 50 51 20 12 10 51 31 50 31
23
0
to 30 16
27 23 25
23
0
65
2
23 23 3y 31
65
26 26 26 6 6 97
0
17
170
18
2
67
92 92
or
?,
260 289 361 289 157 289 179 179 235 235 235 179 361 289 291 235 260 179 235 155 118
92 92
92 92 92 92 92 92 92 92 92 92 92 92 92 92 92
31 11
33
0
17
10
7
8 23 33 23 31 38 25 28 31 25 23 25
1B
0
65
691 63 65 168 170 106 167 as 196 0 83 172 0 89 170 0 73 171 65 168 0 1 73 171
90
0
9
0
23
2
0 0 0
1
23 23 | 22 14
1
1
5
7
260 291
92 92
9
2
0
1
32