CSV:python
s="""\
1,tom,20,
2,jerry,30,
3,,,
"""
with open('c:/vbn.csv',mode='wt+') as f:
# for line in s.splitlines(keepends=True):
# print(line)
# f.write(line)
# f.writelines(s.splitlines(keepends=True))
for line in s.splitlines():
f.write(line+'\n')
csv_body="""\
id,name,age,comment
1,zs,18,"I'm vbn"
2,ls,20,"this is a ""test"" string"
3,ww,22,"发士大夫
吧"
"""
from pathlib import Path
import csv
path='c:/b/p/vbn.csv'
p=Path(path)
if not p.parent.exists():
p.parent.mkdir(parents=True)
line1=['1','tom',20,'']
line2=('1','jerry',30)
line3=[line1,line2]
with open(str(p),mode='w') as f:
writer=csv.writer(f)
writer.writerow(line1)
writer.writerow(line2)
writer.writerows(line3)
with open(str(p),mode='rt+') as f:
reader=csv.reader(f)
for line in reader:
if line:
print(line,type(line))
p=Path('c:/b/p/vbn.csv')
with open(str(p),mode='rt+') as f:
reader=csv.reader(f)
print(next(reader))
row=[4,'vbn',22,'bnm']
rows=[
(5,'cvb',22,'ui\to'),
(7,'xcv',77,'')
]
with open(str(p),mode='a+') as f:
writer=csv.writer(f)
writer.writerow(row)
writer.writerows(rows)