文章中的素材StudentPerformance.csv下载链接
链接:https://pan.baidu.com/s/1gYIIqOyHLWfl21KaJsZvFA
提取码:7br2
实训的目的:学生数据可视化分析
1、导入模块
import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif']=['simhei']
plt.rcParams['font.serif'] = ['simhei']
plt.rcParams['axes.unicode_minus'] = False
from matplotlib.font_manager import FontProperties
myfont=FontProperties(fname=r'C:\Windows\Fonts\SimHei.ttf',size=12)
2、获取数据
(1)导入数据---read_csv
df = pd.read_csv('data//StudentPerformance.csv')
print(df.head(20))
(2)修改表的列名--rename
df.rename(columns={'gender':'性别','NationalITy':'国藉','PlaceofBirth':'出生地','StageID':'学段','GradeID':'年级','SectionID':'班级','Topic':'科目','Semester':'学期','Relation':'监管人','raisedhands':'举手次数','VisITedResources':'浏览课件次数','AnnouncementsView':'浏览公告次数','Discussion':'讨论次数','ParentAnsweringSurvey':'父母问卷','ParentschoolSatisfaction':'家长满意度