Python写入CSV文件出现字符逐个被逗号分隔的格式错误如何解决？

csv模块的writerow()方法要求传入一个由列元素组成的可迭代对象，你直接传入字符串类型的链接时，Python会将字符串识别为单个字符构成的可迭代序列，因此每个字符都会被作为单独的一列拆分，用逗号分隔输出。

将每个链接包装为只有一个元素的列表/元组传入writerow()，代表整行只有一列，值为该链接即可。

修正后代码： #

import csv

links = [
    'https://www.pickles.com.au/cars/item/-/details/CP-04-16--Built-12-15--Volkswagen--Caddy--2KN-MY16-TSI160-SWB-Runner--Van--2-Seats--4-Doors/980483287',
    'https://www.pickles.com.au/cars/item/-/details/CP-01-17--Built-09-16--Holden--Captiva--CG-MY16-LTZ-AWD--Wagon--7-Seats--5-Doors/980483305',
    'https://www.pickles.com.au/cars/item/-/details/CP-09-16--Built-06-16--Holden--Colorado--RG-MY16-LS-Crew-Cab--Cab-Chassis-Dual-Cab--5-Seats--4-Doors/302151687',
    'https://www.pickles.com.au/cars/item/-/details/CP-07-16--Volkswagen--Amarok--2H-MY16-TDI420-4x2--Utility-Dual-Cab--5-Seats--4-Doors/502529815',
]

with open('f.csv', 'a+', newline='', encoding='utf-8') as w:
    r = csv.writer(w)
    for link in links:
        # 把单个字符串包装成列表
        r.writerow([link])

如果要简化代码，也可以直接用writerows()批量写入：

with open('f.csv', 'a+', newline='', encoding='utf-8') as w:
    r = csv.writer(w)
    r.writerows([[link] for link in links])

内容的提问来源于stack exchange，提问作者codewithawais