Python-将单个 csv 单元格拆分为多个单元格

Question

我有一个只有一列的 csv 文件，单元格的示例是:

"What is the capital of France?1)Lille 2)Paris OK3)Nice"

我试图通过将陈述与所有可能的答案分开来划分每个句子。有没有有效的方法来做到这一点？

Answer 1

我认为需要split通过正则表达式 - \d+ 表示一个或多个数字，\) 被转义 ):

df1 = df['col'].str.split('\d+\)', expand=True)

示例:

df = pd.DataFrame({'col':[
        "What is the capital of France?1)Lille 2)Paris OK3)Nice",
        "What is the capital of Slovakia?1)Bratislava OK 2)Zilina3)Praha"]})


df1 = df['col'].str.split('\d+\)', expand=True)
df1.columns = ['Question','No1','No2','No3']
print (df1)
                           Question             No1       No2    No3
0    What is the capital of France?          Lille   Paris OK   Nice
1  What is the capital of Slovakia?  Bratislava OK     Zilina  Praha