[已解决]python3 csv 中newline的问题

fineconey

先附上代码

1. import csv
   
2. import random
   
3. import time
   
4. 
   
5. t1=time.time()
   
6. for i in range(10000):
   
7.     t1 = random.randint(1, 999)
   
8.     t2 = random.randrange(999, 1999)
   
9.     # print(t1, t2)
   
10.     with open("删除.csv", "a", encoding="utf-8") as f:
    
11.         file = csv.writer(f, delimiter="|",newline=" ")
    
12.         file.writerows([str(t1), str(t2)])
    
13. t2=time.time()
    
14. print(t2-t1)

复制代码

如上，加上newline=" "  就报错

1. D:\Python38\python.exe E:/Python_files/-打发无聊时光-/csv练习.py
   
2. Traceback (most recent call last):
   
3.   File "E:/Python_files/-打发无聊时光-/csv练习.py", line 11, in <module>
   
4.     file = csv.writer(f, delimiter="|",newline=" ")
   
5. TypeError: 'newline' is an invalid keyword argument for this function
   

复制代码

如果不加，可以正常运行，但是每个一个数据就有一个空行，很麻烦。且不美观。
请问我的问题出在哪里   python3.8
谢谢

最佳答案

月排行榜 / 总排行榜

疾风怪盗

2020-9-14 16:25:36

1.     with open("删除.csv", "a", encoding="utf-8",newline='') as f:
   
2.         file = csv.writer(f, delimiter="|")
   
3.         file.writerows([str(t1), str(t2)])

复制代码

newline是open()函数的参数

跳转到最佳答案楼层

疾风怪盗

1.     with open("删除.csv", "a", encoding="utf-8",newline='') as f:
   
2.         file = csv.writer(f, delimiter="|")
   
3.         file.writerows([str(t1), str(t2)])

复制代码

newline是open()函数的参数

wingl

1. import csv
   
2. import random
   
3. import time
   
4. 
   
5. t1=time.time()
   
6. for i in range(10000):
   
7.     t1 = random.randint(1, 999)
   
8.     t2 = random.randrange(999, 1999)
   
9.     # print(t1, t2)
   
10.     with open("删除.csv", "a", encoding="utf-8",newline='') as f:
    
11.         file = csv.writer(f, delimiter="|")
    
12.         file.writerows([str(t1), str(t2)])
    
13. t2=time.time()
    
14. print(t2-t1)

复制代码

百度newline要放到open里面，经测试能解决

kogawananari

读

1. import csv
   
2. filename = '名单.csv'
   
3. with open(filename) as f:
   
4.     reader = csv.reader(f)
   
5.     print(list(reader))

复制代码

写

1. import csv
   
2. filename = '名单.csv'
   
3. csvFile = open(filename, "w", encoding='utf-8', newline='')
   
4. writer = csv.writer(csvFile)
   
5. 
   
6. fileHeader = ("姓名", "年龄")
   
7. writer.writerow(fileHeader)
   
8. 
   
9. data = ("张三",17)
   
10. writer.writerow(data)
    
11. 
    
12. csvFile.close()

复制代码

fineconey

感谢各位。一句话点醒梦中人。