Pandas 列包含列表，如何将唯一列表元素旋转到列

如何将Pandas列包含的列表元素旋转到列中

python
import pandas as pd

python
data = {'col1': [['A', 'B', 'C'], ['D', 'E'], ['F']], 'col2': [1, 2, 3]}
df = pd.DataFrame(data)
print(df)

       col1  col2
0  [A, B, C]     1
1     [D, E]     2
2        [F]     3

python
df_expanded = df.explode('col1')
print(df_expanded)

  col1  col2
0    A     1
0    B     1
0    C     1
1    D     2
1    E     2
2    F     3

python
df_final = df_expanded.drop('col1', axis=1)
print(df_final)

   col2
0     1
0     1
0     1
1     2
1     2
2     3