实验内容:
(1)代码:
import pandas as pd
from pyecharts.charts import Bar
from pyecharts import options as opts
df=pd.read_excel(r"C:\Users\admin\Desktop\教师文件\成绩表.xlsx",index_col="学号")
print(df)
(2)代码:
print(df.sort_values("数据处理",ascending=False))
(3)代码:
corrl=df["数据处理"].corr(df["数据挖掘"])
print(corrl)
(4)代码:
df_mean=df.mean(axis=1)
print(df_mean)
b=Bar()
b.add_xaxis(df_mean.index.to_list())
b.add_yaxis("平均分",df_mean.to_list())
#添加标题
b.set_global_opts(title_opts = opts.TitleOpts(title="成绩平均分"))
b.render(r"C:\Users\admin\Desktop\教师文件\成绩平均分.html")
b.render_notebook()