处理Dataframe列中的列表

import pandas as pd

# 创建包含列表的Dataframe
df = pd.DataFrame({'col1': [[1, 2, 3], [4, 5], [6, 7, 8, 9]]})

# 展开列表
df_exploded = df.explode('col1')

print(df_exploded)

   col1
0     1
0     2
0     3
1     4
1     5
2     6
2     7
2     8
2     9

import pandas as pd

# 创建包含列表的Dataframe
df = pd.DataFrame({'col1': [[1, 2, 3], [4, 5], [6, 7, 8, 9]]})

# 聚合操作
df['col1_sum'] = df['col1'].apply(lambda x: sum(x))

print(df)

          col1  col1_sum
0     [1, 2, 3]         6
1        [4, 5]         9
2  [6, 7, 8, 9]        30