I have a data frame like below
df <- data.frame(HOD_ID =c("","KTN2252","ANA2719","ITI2624","DEV2698","HRT2921","","KTN2624","ANA2548","ITI2535","DEV2732","HRT2837","ERV2951","KTN2542","ANA2813","ITI2210"),
DEPT_Head = c("DEV0001","KTN2252","ANA2719","ITI2624","DEV2698","HRT2921","ERV0000","KTN2624","ANA2548","ITI2535","DEV2732","HRT2837","ERV2951","KTN2542","ANA2813","ITI2210"))
my code always required input parameters
DEPT_Head = "DEV0001"
now i want to mutate my data frame if HOD_ID for user input Dept_head should be blank , and if there is any other blank cells except user input parameters the mutate new column to 1
HOD_ID should always be blank for user defined DEPT_Head , else if there any blank cells then mutate if_blank to 1
the output should be like
| HOD_id |
Dept_id |
if_blank |
|
DEV0001 |
0 |
| KTN2252 |
KTN2252 |
0 |
| ANA2719 |
ANA2719 |
0 |
| ITI2624 |
ITI2624 |
0 |
| DEV2698 |
DEV2698 |
0 |
| HRT2921 |
HRT2921 |
0 |
|
ERV0000 |
1 |
| KTN2624 |
KTN2624 |
0 |
| ANA2548 |
ANA2548 |
0 |
| ITI2535 |
ITI2535 |
0 |
| DEV2732 |
DEV2732 |
0 |
| HRT2837 |
HRT2837 |
0 |
| ERV2951 |
ERV2951 |
0 |
| KTN2542 |
KTN2542 |
0 |
| ANA2813 |
ANA2813 |
0 |
| ITI2210 |
ITI2210 |
0 |