我想將選項(xiàng)卡添加到 tex 數(shù)據(jù)并導(dǎo)出為 excel csv 和 txt 文件。我有：13 turned in the research Paper on Friday; otherwise, he Would have not passed the Class我想在最后一個(gè)詞之前添加標(biāo)簽。我寫了這段代碼：df = df.replace({"\s([A-Z][a-z]+[a-z])$": " \\t\\1"}, regex=True)df.to_csv("file.csv", sep='\t')df.to_csv("file.txt", sep='\t', index=False)df.to_excel("file.xlsx", sheet_name='Sheet1')問題是當(dāng)我導(dǎo)出并查看不在原始文件和 excel 文件中的 *"*s 文件時(shí)，整行停留在一列而不是兩列中。"13 turned in the research Paper" "on Friday; otherwise, he Would" "have not passed the Class"我錯(cuò)過了什么？
1 回答
瀟湘沐
TA貢獻(xiàn)1816條經(jīng)驗(yàn) 獲得超6個(gè)贊
您必須使用r'\\t'or '\\\\t'，這就是我的做法。
代碼
import pandas as pd
import re
#create the sample dataframe
df = pd.DataFrame({'sent':['13 turned in the research Paper',\
'on Friday; otherwise, he Would',\
'have not passed the Class']})
#df.head()
#apply regex substitution
df['sent'] = df['sent'].astype(str).apply(lambda x: re.sub(r'\s([A-Z][a-z]+$)', r'\\t\g<1>', x))
df.to_csv('tabbed.txt',index=False)
'''
sent
13 turned in the research\tPaper
"on Friday; otherwise, he\tWould"
have not passed the\tClass
'''
#not-so-pretty output
pd.read_csv('tabbed.txt', sep=r'\\t', engine='python')
'''
sent
13 turned in the research Paper
"on Friday; otherwise, he Would"
have not passed the Class
'''
美化輸出
#prettify it
(pd.read_csv('tabbed.txt', sep='\\\\t', engine='python')
.reset_index().rename(columns={'index':'sent0','sent':'sent1'})
.replace(r'"', '', regex=True)
)
'''
sent0 sent1
0 13 turned in the research Paper
1 on Friday; otherwise, he Would
2 have not passed the Class
'''
添加回答
舉報(bào)
0/150
提交
取消