I have a dataset with an ID column with multiple visits for every ID. I am trying to create a new variable Status, which will check the Visit column and Value column. The conditions are as follows
For visit in 1,2 & 3, if the values are 1,1,1 then 1 For visit in 1,2 & 3, if the values are 0,1,1 then 0 For visit in 1,2 & 3, if the values are 0,0,0 then 0
How do I specify this condition in R ?
Below is a sample dataset
| ID | Visit | Value |
|---|---|---|
| 1 | 1 | 1 |
| 1 | 2 | 1 |
| 1 | 3 | 1 |
| 2 | 1 | 1 |
| 2 | 2 | 0 |
| 2 | 3 | 0 |
| 3 | 1 | 0 |
| 3 | 2 | 0 |
| 3 | 3 | 0 |
| 4 | 1 | 0 |
| 4 | 2 | 1 |
| 4 | 3 | 1 |
Result dataset
| ID | Visit | Value | Status |
|---|---|---|---|
| 1 | 1 | 1 | 1 |
| 1 | 2 | 1 | 1 |
| 1 | 3 | 1 | 1 |
| 2 | 1 | 1 | 0 |
| 2 | 2 | 0 | 0 |
| 2 | 3 | 0 | 0 |
| 3 | 1 | 0 | 0 |
| 3 | 2 | 0 | 0 |
| 3 | 3 | 0 | 0 |
| 4 | 1 | 0 | 0 |
| 4 | 2 | 1 | 0 |
| 4 | 3 | 1 | 0 |
Aucun commentaire:
Enregistrer un commentaire