如何解析下面的行，以便它将第三列作为 Python 中的列表

由于第三列包含字符串格式的数据，因此请考虑使用 and 参数将字符串表示形式转换为实际列表。StringIOconverters

import pandas as pd
from io import StringIO
import ast

# Your data 
data = ...

# Coverting data into string representation
data_file = StringIO(data)

# Converter function to convert the string representation of lists to actual lists
def parse_list(s):
    return ast.literal_eval(s)

df = pd.read_csv(data_file, converters={'col3': parse_list})
print(df)

尝试忽略方括号之间的逗号，delimiter=', (?![^\[]*[\]])'

import io
data = '''col1, col2, col3 <br>
name, date, ["data"] <br>
name, date, ["data", "data2", "data3"]  <br>
name, date, ["data1", "data2"] <br>'''

df = pd.read_csv(io.StringIO(data),delimiter=', (?![^\[]*[\]])', engine="python")
print(df)

---

输出：

   col1   col2                          col3 <br>
0  name   date                      ["data"] <br>
1  name   date   ["data", "data2", "data3"]  <br>
2  name   date            ["data1", "data2"] <br>

要删除 ，<br>

# To remove <br> tags from each line
df.rename(columns={'col3 <br>':'col3'}, inplace=True)
df['col3'] = df['col3'].apply(lambda x : x.replace(' <br>', '').strip())

>>> output
   col1  col2                        col3
0  name  date                    ["data"]
1  name  date  ["data", "data2", "data3"]
2  name  date          ["data1", "data2"]

另一个可能的解决方案：

from io import StringIO

df = pd.read_csv(StringIO(text), sep=r', (?!\")|\s+\<br\>',
             engine='python').dropna(axis=1)

输出：

   col1  col2                        col3
0  name  date                    ["data"]
1  name  date  ["data", "data2", "data3"]
2  name  date          ["data1", "data2"]