pandas无法运行？

Question

import  pandas  as pd
import  matplotlib.pyplot as plt
import numpy as np
from matplotlib import cm
plt.rcParams['font.sans-serif'] = ['Microsoft YaHei']
plt.rcParams['axes.unicode_minus'] = False  # 用来正常显示负号,初始化
df=pd.read_csv(r'C:\Users\21015\PycharmProjects\pythonProject\性别比例城乡差距.csv')
df.head()
N=3
x=df.columns.values.tolist()[4:-2:N]
yl=df.iloc[-1].values.tolist()[4:-2:N]
plt.plot(x,yl,label='o',c='red',mec='blue',mcf='g')
plt.xlabel("年份/年")
plt.ylabel('百万')
plt.title('人口变化')
plt.legend()
plt.show()

运行结果是

Traceback (most recent call last):
  File "C:/Users/21015/PycharmProjects/pythonProject/main.py", line 7, in <module>
    df=pd.read_csv(r'C:\Users\21015\PycharmProjects\pythonProject\性别比例城乡差距.csv')
  File "C:\Users\21015\AppData\Roaming\Python\Python36\site-packages\pandas\io\parsers.py", line 688, in read_csv
    return _read(filepath_or_buffer, kwds)
  File "C:\Users\21015\AppData\Roaming\Python\Python36\site-packages\pandas\io\parsers.py", line 460, in _read
    data = parser.read(nrows)
  File "C:\Users\21015\AppData\Roaming\Python\Python36\site-packages\pandas\io\parsers.py", line 1198, in read
    ret = self._engine.read(nrows)
  File "C:\Users\21015\AppData\Roaming\Python\Python36\site-packages\pandas\io\parsers.py", line 2157, in read
    data = self._reader.read(nrows)
  File "pandas\_libs\parsers.pyx", line 847, in pandas._libs.parsers.TextReader.read
  File "pandas\_libs\parsers.pyx", line 862, in pandas._libs.parsers.TextReader._read_low_memory
  File "pandas\_libs\parsers.pyx", line 918, in pandas._libs.parsers.TextReader._read_rows
  File "pandas\_libs\parsers.pyx", line 905, in pandas._libs.parsers.TextReader._tokenize_rows
  File "pandas\_libs\parsers.pyx", line 2042, in pandas._libs.parsers.raise_parser_error
pandas.errors.ParserError: Error tokenizing data. C error: Expected 2 fields in line 7, saw 3

我好慌，这可是个大比赛，希望被知道一下蟹蟹。我只是个不知世事的小女孩

Answer 1

在用pd.read_csv读取csv文件时有许多参数可以设置，针对出现的问题，用以下方式尝试：

1.添加参数engine='python',默认是‘c';

2.设置error_bad_lines 和warn_bad_lines，关闭标准输出错误信息;

3.选定进行数据处理的相关列，用use_col,防止数据列数不一致。

read_csv(filename, usecols=[0:3], error_bad_lines=False, warn_bad_lines=False)