import matplotlib.pyplot as plt
import pandas as pd
import numpy as np
from matplotlib import cm
plt.rcParams['font.sans-serif'] = ['Microsoft YaHei'] # 设置字体,否则中文会显示异常
df = pd.read_excel("china.xlsx",error_bad_lines=False,warn_bad_lines=False)
N = 3
year = df.columns.values.tolist()[4:-2:N]
data = df.iloc[-1].values.tolist()[4:-2:N]
data = np.asarray(data) / 1e+8
plt.figure(figsize=(12,8))
plt.title("中国总人口(亿人)")
plt.plot(year, data, marker='o', c='red', mec='blue', mfc='g')
plt.xlabel("年份/年")
plt.ylabel("人口/亿人")
for a, b in zip(year, data):
plt.text(a, b, '%0.2f' % b, ha='right', va='bottom', fontsize=8)
plt.grid()
plt.show()
代码是这样的
以下是错误提示:
C:\Users\21015\AppData\Local\Programs\Python\Python36\python.exe C:/Users/21015/PycharmProjects/pythonProject/main.py
Traceback (most recent call last):
File "C:/Users/21015/PycharmProjects/pythonProject/main.py", line 6, in <module>
df = pd.read_excel("china.xlsx",warn_bad_lines=False)
File "C:\Users\21015\AppData\Roaming\Python\Python36\site-packages\pandas\util\_decorators.py", line 296, in wrapper
return func(*args, **kwargs)
TypeError: read_excel() got an unexpected keyword argument 'warn_bad_lines'
Process finished with exit code 1
希望得到帮助,第一次学python,参加一个大数据比赛,刚开始就卡了好久了,谢谢大家!