Home / Expert Answers / Computer Science / question-10-a-e-10-use-pandas-python-library-to-do-the-following-a-load-the-file-34-student-grades-pa800

(Solved): Question 10 a-e 10- Use pandas Python library to do the following: a- Load the file "student_grades. ...



Question 10 a-e
10- Use pandas Python library to do the following:
a- Load the file student_grades. csv that you created in question 5 and
HQuestion 5
outFile = open ( student_grades. csv,   \( ^{*} \) )
outfile.write (banner, Math, Phys 1cs, Chemistry, Blolo
10- Use pandas Python library to do the following: a- Load the file "student_grades. csv" that you created in question 5 and print its content. b- Use python codes to print the column names of the dataframe. c- Sum the total grades for each student and add the total column to the datafiame, as "total" column. d- For the new data frame with the new total column, make the "banner" column as the index and assign the new gataframe to "df2" variable. e- Slice the columns Physics and Chemistry in a new gataframe, HQuestion 5 outFile = open ( "student_grades. csv", " " \( ^{*} \) ) outfile.write ("banner, Math, Phys 1cs, Chemistry, Blology/n") outF1le.write ("ST0001, \( 90,70,108,88 \) in") outFile write("STD002, 33,45,90,75ln") outFile.write("5TD004, \( \left.67,70,40,351 n^{*}\right) \) outF1le.write ("5TDe05, 34,25,60,52) in" \( \left.^{*}\right) \) outFile.write("ST0e06,67,80,77,45 \( \left.\ln ^{*}\right) \) outF11e. write("STDe07,87,90,66,84)n") outFile.write ("ST0008, \( 54,70,55,481 n^{\prime \prime} \) ) outf1le.write( "510089,32,55,39,65ln") outfile.closef)


We have an Answer from Expert

View Expert Answer

Expert Answer


python code: import
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe