6.Read the ‘Student.csv’ to create a data frame and do the following operation:
To display Student file with new column names.
To modify the Percentage of student below 40 with NaN value in dataframe.
Solution :-
import pandas as pd
import numpy as np
import csv
df=pd.read_csv("Student.csv")
print(df)
#To display Student_result file with new column names.
df1 = pd.read_csv("Student.csv",skiprows=1,
names=['Adm_No','Roll no' ,'Name' ,'Gender' 'S1','S2','S3','S4','S5','S6','total','Perc'])
print("To display Student_result file with new column names")
print(df1)
#To modify the Percentage of student below 40 with NaN value.
df2 = pd.read_csv("Student.csv")
print(df2)
print("To modify the percentage od Student below 40 with NaN value.")
df2.loc[(df2['Perc']<40,'Perc')]=np.nan
print(df2)
Output :-
