python3 读取csv

最新推荐文章于 2024-04-27 11:43:04 发布

qq_40168156

最新推荐文章于 2024-04-27 11:43:04 发布

阅读量264

点赞数

分类专栏： Python

本文链接：https://blog.csdn.net/qq_40168156/article/details/81128603

版权

Python 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

#coding=utf-8
import csv
with open('csvtest.csv', 'r') as csvfile:
    read = csv.reader(csvfile)
    for i in read:
        print(i)




# with open('./csvtest.csv', 'w', newline='') as csvfile:
#     writer = csv.writer(csvfile)
#     writer.writerow(['id', 'url', 'keywords']) #只能写入一行
#     data = [('1', 'www.xiaoheiseo.com', '小黑'), ('2', 'www.baidu.com', '百度'), ('3', 'www.jd.com', '京东')]
#     writer.writerows(data)
#
# with open('./csvtest.csv', 'r') as csvfile:
#     read = csv.reader(csvfile)
#     for i in read:
#         print(i)

# with open('csvtest11.csv','w' , newline='') as csvfile:
#     writer = csv.DictWriter(csvfile, fieldnames=['id','name'])
#     writer.writeheader()







#更改编码方式
# import codecs
# with codecs.open('csvtest11.csv', 'w', encoding='utf-8') as myfile:
#     writer = csv.writer(myfile)
#     writer.writerow(['编号', '网址', '名称'])
# #
# with open('csvtest11.csv', 'r', encoding='utf-8') as csvfile:
#     read = csv.reader(csvfile)
#     for i in read:
#         print(i)





# with open('./csvtest.csv', 'w', newline='', encoding='utf-8') as csvfile:
#     writer = csv.writer(csvfile)
#     writer.writerow(['id', 'url', 'keywords'])
#     data = [('1', 'www.xiaoheiseo.com', '小黑'), ('2', 'www.baidu.com', '百度'), ('3', 'www.jd.com', '京东')]
#     writer.writerows(data)
#
# # #自定义读取
# csv.register_dialect('abc', delimiter='|', quoting=csv.QUOTE_ALL)
# with open('./csvtest.csv', 'r', encoding='utf-8') as csvfile:
#     lines = csv.reader(csvfile, 'abc')
#     for i in lines:
#         print(i)