请大佬们看看这些错误都是什么

LYLlllhhh

1. #数据读取
   
2. import pandas as pd
   
3. 
   
4. df=pd.read_csv('D:\\本人\\必须冲！\\学nlp\\qunaer-budalagong.csv')   #此处路径需要修改
   
5. 
   
6. with open('实验2.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('实验2.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 "C:\Users\lyl\PycharmProjects\pythonProject1\venv\lib\site-packages\pandas\core\indexes\base.py", line 3080, in get_loc
    return self._engine.get_loc(casted_key)
  File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  File "pandas\_libs\index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc
  File "pandas\_libs\hashtable_class_helper.pxi", line 4554, in pandas._libs.hashtable.PyObjectHashTable.get_item
  File "pandas\_libs\hashtable_class_helper.pxi", line 4562, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: '内容'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "D:/本人/必须冲！/学nlp/微博评论评分 - 副本.py", line 8, in <module>
    f.write(str(df['内容'])+'\n')
  File "C:\Users\lyl\PycharmProjects\pythonProject1\venv\lib\site-packages\pandas\core\frame.py", line 3024, in __getitem__
    indexer = self.columns.get_loc(key)
  File "C:\Users\lyl\PycharmProjects\pythonProject1\venv\lib\site-packages\pandas\core\indexes\base.py", line 3082, in get_loc
    raise KeyError(key) from err
KeyError: '内容'

Process finished with exit code 1

Stubborn

请添加解码方式为GB18030：

1. df = pd.read_csv(r'qunaer-budalagong.csv', encoding='GB18030')

复制代码

LYLlllhhh

Stubborn 发表于 2021-2-23 00:06
请添加解码方式为GB18030：

嗯嗯好，解决啦。谢谢！