我的数据帧是这样的.我正在试着创建一份名单.对于EX:["Mike", "Jean"]:
0. Mike, Jean
1. May, Weather
2. Jack, 100
我试过的是:
df["NAME"] = df["NAME"].str.split(",")
for i in range(len(df["NAME"])):
df["NAME"][i] = df["NAME"][i] .split(",")
OUTPUT个
0. [Mike, Jean]
1. [May, Weather]
2. [Jack, 100]
OUTPUT I WANT个
0. ["Mike", "Jean"]
1. ["May", "Weather"]
2. ["Jack", "100"]
我是第一次接触Python和Pandas.
假设输入如下:
df = pd.DataFrame({'Name': ['Mike, Jean', 'May, Weather', 'Jack, 100']})
当你 run 时:
df['Name'].str.split(', ')
并获得:
0 [Mike, Jean]
1 [May, Weather]
2 [Jack, 100]
Name: Name, dtype: object
[Mike, Jean]格式是just a representation.
实际数据实际上是一系列列表，如将系列显式转换为列表所示:
df['Name'].str.split(', ').to_list()
输出:
[['Mike', 'Jean'],
['May', 'Weather'],
['Jack', '100']]