Czyszczenie danych w PySpark
Mike Metzger
Data Engineering Consultant
Klauzule warunkowe to:
.when().otherwise().when(<warunek if>, <wartość then x>)
df.select(df.Name, df.Age, F.when(df.Age >= 18, "Adult"))
| Name | Age | |
|---|---|---|
| Alice | 14 | |
| Bob | 18 | Adult |
| Candice | 38 | Adult |
Wiele wywołań .when()
df.select(df.Name, df.Age,
.when(df.Age >= 18, "Adult")
.when(df.Age < 18, "Minor"))
| Name | Age | |
|---|---|---|
| Alice | 14 | Minor |
| Bob | 18 | Adult |
| Candice | 38 | Adult |
.otherwise() działa jak else
df.select(df.Name, df.Age,
.when(df.Age >= 18, "Adult")
.otherwise("Minor"))
| Name | Age | |
|---|---|---|
| Alice | 14 | Minor |
| Bob | 18 | Adult |
| Candice | 38 | Adult |
Czyszczenie danych w PySpark