pandas explode 将一个列表类元素拆成一行数据

pandas explode 将一个列表类元素拆成一行数据

Series.explode(ignore_index=False)

Transform each element of a list-like to a row.

s = pd.Series([[1, 2, 3], 'foo', [], [3, 4]])
s
0    [1, 2, 3]
1          foo
2           []
3       [3, 4]
dtype: object
    
s.explode()
0      1
0      2
0      3
1    foo
2    NaN
3      3
3      4
dtype: object

DataFrame.explode(column, ignore_index=False)

df = pd.DataFrame({'A': [[1, 2, 3], 'foo', [], [3, 4]], 'B': 1})
df
           A  B
0  [1, 2, 3]  1
1        foo  1
2         []  1
3     [3, 4]  1

df.explode('A')
     A  B
0    1  1
0    2  1
0    3  1
1  foo  1
2  NaN  1
3    3  1
3    4  1