|-- event: string (nullable = true)
|-- yes: string (nullable = true)
|-- maybe: string (nullable = true)
|-- invited: string (nullable = true)
|-- no: string (nullable = true
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200212225936530.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JlaWlzQmVp,size_16,color_FFFFFF,t_70#pic_center)
### 二、首先考虑单独两行映射
df.filter(col(“yes”).isNotNull).select(col(“event”),col(“yes”)).withColumn(“userid”,explode(split(col(“yes”)," "))).drop($“yes”).withColumn(“status”,lit(“yes”)).show(3)
±---------±---------±-----+
| event| userid|status|
±---------±---------±-----+
|1159822043|1975964455| yes|
|1159822043| 252302513| yes|
|1159822043|4226086795| yes|
±---------±---------±-----+
only showing top 3 rows
### 三、同理将其余隔行依次映射