Python Crosstab data in CSV file || Pandas and Numpy

Описание

file=pd.read_csv("C:\\Users\\home\\Documents\\ytdata2.csv")
#rename header
header_names=['student_name','subj_name','total_marks','grade_id','NA']
file=pd.read_csv("C:\\Users\\home\\Documents\\ytdata2.csv",header=None,skiprows=1,names=header_names)
file2=pd.crosstab(file.subj_name,file.grade_id,values=file.total_marks,aggfunc=np.sum)
file3=pd.file2=pd.crosstab(file.student_name,[file.subj_name,file.grade_id],values=file.total_marks,aggfunc=np.sum)