我有一個 CSV 文件：101, "Name1", "Designation1", "blah1", "Blah1", 20200914001102, "Name2", "Designation2", "blah2", "Blah2", 20200914002103, "Name3", "Designation3", "blah3", "Blah3", 20200914003104, "Name4", "Designation4", "blah4", "Blah4", 20200914004105, "Name5", "Designation5", "blah5", "Blah5", 20200914005將每一行替換如下：101|| "Name1", "Designation1", "blah1", "Blah1"|| 20200914001類似的結構也適用于其余的行/記錄。我的代碼替換了所有分隔符。data = ""with open('firstCSV.csv', 'r') as file: data = file.read().replace(',', '||').replace(' ', '')with open("first_Out.csv", "w") as out_file: out_file.write(data)提前致謝。
2 回答
繁星coding
TA貢獻1797條經驗 獲得超4個贊
使用
^([^,]*),|,(?=[^,]*$)
替換為\1||.?見證明。
解釋
--------------------------------------------------------------------------------
? ^? ? ? ? ? ? ? ? ? ? ? ? the beginning of the string
--------------------------------------------------------------------------------
? (? ? ? ? ? ? ? ? ? ? ? ? group and capture to \1:
--------------------------------------------------------------------------------
? ? [^,]*? ? ? ? ? ? ? ? ? ? any character except: ',' (0 or more
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?times (matching the most amount
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?possible))
--------------------------------------------------------------------------------
? )? ? ? ? ? ? ? ? ? ? ? ? end of \1
--------------------------------------------------------------------------------
? ,? ? ? ? ? ? ? ? ? ? ? ? ','
--------------------------------------------------------------------------------
?|? ? ? ? ? ? ? ? ? ? ? ? OR
--------------------------------------------------------------------------------
? ,? ? ? ? ? ? ? ? ? ? ? ? ','
--------------------------------------------------------------------------------
? (?=? ? ? ? ? ? ? ? ? ? ? look ahead to see if there is:
--------------------------------------------------------------------------------
? ? [^,]*? ? ? ? ? ? ? ? ? ? any character except: ',' (0 or more
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?times (matching the most amount
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?possible))
--------------------------------------------------------------------------------
? ? $? ? ? ? ? ? ? ? ? ? ? ? before an optional \n, and the end of
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?the string
--------------------------------------------------------------------------------
? )? ? ? ? ? ? ? ? ? ? ? ? end of look-ahead
import re
regex = r'^([^,]*),|,(?=[^,]*$)'
test_str = r'101, "Name1", "Designation1", "blah1", "Blah1", 20200914001'
subst = r'\1||'
print(re.sub(regex, subst, test_str))
結果：101|| "Name1", "Designation1", "blah1", "Blah1"|| 20200914001.
隔江千里
TA貢獻1906條經驗 獲得超10個贊
您可以拆分第一個（maxsplit=1從左起）和最后一個（maxsplit=1從右起）逗號并連接結果，例如：
>>> line = '101, "Name1", "Designation1", "blah1", "Blah1", 20200914001'
>>> first, rest = line.split(',', maxsplit=1)
>>> rest, last = rest.rsplit(',', maxsplit=1)
>>> '||'.join((first, rest, last))
'101|| "Name1", "Designation1", "blah1", "Blah1"|| 20200914001'
添加回答
舉報
0/150
提交
取消