wrangles:
- compute.case_when:
output: Letter Grade
cases:
- condition: Grade > 89
value: 'A'
- condition: 90 > Grade > 79
value: 'B'
- condition: 80 > Grade > 69
value: 'C'
- condition: 70 > Grade
value: 'F'
| | |
| Student |
Grade |
| Billy |
62 |
| Sarah |
91 |
| Timmy |
88 |
| Tammy |
74 |
|
→
|
| Student |
Grade |
Letter Grade |
| Billy |
62 |
F |
| Sarah |
91 |
A |
| Timmy |
88 |
B |
| Tammy |
74 |
C |
|
Conditions can be combined/strung together so that multiple conditions must be met in order to achieve the desired output.
wrangles:
- compute.case_when:
output: Letter Grade
cases:
- condition: (Grade > .89) & (Attendance == 'Good')
value: 'A'
- condition: (.90 > Grade > .79) & (Attendance == 'Good')
value: 'B'
- condition: (.80 > Grade > .69) & (Attendance == 'Good')
value: 'C'
- condition: (.70 > Grade) or (Attendance == 'Poor')
value: 'F'
| | |
| Student |
Grade |
Attendance |
| Billy |
62 |
Poor |
| Sarah |
91 |
Poor |
| Timmy |
88 |
Good |
| Tammy |
74 |
Good |
|
→
|
| Student |
Grade |
Attendance |
Letter Grade |
| Billy |
62 |
Poor |
F |
| Sarah |
91 |
Poor |
F |
| Timmy |
88 |
Good |
B |
| Tammy |
74 |
Good |
C |
|