想麻烦大佬看看为什么错呢，应该怎么改？

LYLlllhhh

1. #数据读取
   
2. import pandas as pd
   
3. 
   
4. df=pd.read_csv('D:\\本人\\必须冲！\\学nlp\\安徽.csv')   #此处路径需要修改
   
5. 
   
6. with open('实验.txt','w+',encoding='utf-8') as f:
   
7.     for i in range(len(df)):
   
8.         f.write(str(df['内容'][i])+'\n')
   
9. 
   
10. import codecs
    
11. import re
    
12. import numpy as np
    
13. import pymysql
    
14. from snownlp import SnowNLP
    
15. import matplotlib.pyplot as plt
    
16. from snownlp import sentiment
    
17. from snownlp.sentiment import Sentiment
    
18. 
    
19. 
    
20. comment = []
    
21. with open('安徽.txt', mode='r', encoding='utf-8') as f:
    
22.     rows = f.readlines()
    
23.     for row in rows:
    
24.         if row not in comment:
    
25.             comment.append(row.strip('\n'))
    
26. 
    
27. key=[]
    
28. values=[]
    
29. re=[]
    
30. def snowanalysis(self):
    
31.     sentimentslist = []
    
32.     for li in self:
    
33.         #text = re.sub(r'(?:回复)?(?://)?@[\w\u2E80-\u9FFF]+:?|\[\w+\]', ',',li)
    
34.         s = SnowNLP(li)
    
35.         
    
36.         key.append(li)
    
37.         values.append(s.sentiments)
    
38.         sentimentslist.append(s.sentiments)
    
39.     plt.figure(figsize=(12,8))
    
40.     plt.hist(sentimentslist, bins=np.arange(0, 1, 0.01))
    
41.     plt.show()
    
42.    
    
43. snowanalysis(comment)
    
44. 
    
45. res=pd.DataFrame({'评论':key,'评分':values})
    
46. 
    
47. #保存文件为excel格式
    
48. res.to_excel('D:\\本人\\必须冲！\\学nlp\\安徽（实验）.xlsx')  #此处路径需要修改�

复制代码

C:\Users\lyl\PycharmProjects\pythonProject1\venv\Scripts\python.exe "D:/本人/必须冲！/学nlp/微博评论评分 - 可用.py"
Traceback (most recent call last):
  File "D:/本人/必须冲！/学nlp/微博评论评分 - 可用.py", line 4, in <module>
    df=pd.read_csv('D:\\本人\\必须冲！\\学nlp\\安徽.csv')   #此处路径需要修改
  File "C:\Users\lyl\PycharmProjects\pythonProject1\venv\lib\site-packages\pandas\io\parsers.py", line 610, in read_csv
    return _read(filepath_or_buffer, kwds)
  File "C:\Users\lyl\PycharmProjects\pythonProject1\venv\lib\site-packages\pandas\io\parsers.py", line 468, in _read
    return parser.read(nrows)
  File "C:\Users\lyl\PycharmProjects\pythonProject1\venv\lib\site-packages\pandas\io\parsers.py", line 1057, in read
    index, columns, col_dict = self._engine.read(nrows)
  File "C:\Users\lyl\PycharmProjects\pythonProject1\venv\lib\site-packages\pandas\io\parsers.py", line 2061, in read
    data = self._reader.read(nrows)
  File "pandas\_libs\parsers.pyx", line 756, in pandas._libs.parsers.TextReader.read
  File "pandas\_libs\parsers.pyx", line 771, in pandas._libs.parsers.TextReader._read_low_memory
  File "pandas\_libs\parsers.pyx", line 827, in pandas._libs.parsers.TextReader._read_rows
  File "pandas\_libs\parsers.pyx", line 814, in pandas._libs.parsers.TextReader._tokenize_rows
  File "pandas\_libs\parsers.pyx", line 1951, in pandas._libs.parsers.raise_parser_error
pandas.errors.ParserError: Error tokenizing data. C error: Expected 1 fields in line 3, saw 2

qq1151985918

https://blog.csdn.net/alicelmx/article/details/83902760