python read_csv、csv.reader dialect 常用参数、csv.writer用法

 

1.read_csv

 

 

 

2.csv.reader()参数

3.csv.writer 用法

#定义dialect
class my_dialect(csv.Dialect):
    lineterminator='\n'
    delimiter='|'
    quotechar='"'
    quoting=csv.QUOTE_MINIMAL


#新建一个文件并写入
with open('/Users/youshiqi/lianghaiming/Desktop/shiyan.csv','w')as f:
    writer=csv.writer(f,dialect=my_dialect)
    writer.writerow(('one','two','three'))
    writer.writerow((1,2,3))
    writer.writerow((4,5,6))
a=pd.read_csv('/Users/youshiqi/lianghaiming/Desktop/shiyan.csv')
print(a)

 

posted @ 2020-11-07 20:50  爬爬QQ  阅读(2585)  评论(0)    收藏  举报