Hi, I'm trying to replace values in a nested column in a JSON-based dataframe using withColumn().
This syntax works for select, filter, etc, giving only the nested "country"
column:
df.select('body.payload.country')
but if I do this, it will create a new column with the name
"body.payload.country"
df.withColumn('body.payload.country', lit(None))
Also tried with 'body["payload"]["country"]', etc. but no luck. Is it
possible to do this somehow?
Best,
Zsolt
