How to make columns into lists for .csv (excel) with Python?
What I mean by column is when you have:
Student Grade GPA
Max B 3.2
Angel A 3.5
Sonny C 2.1
So column 1, I want: Student Max Angel Sonny
Column 2 I want: Grades B A C
That is what I have on .csv file.
The code I would need to use is:
StudFile = open(“grades.csv”, “r”)
How to make it read so that I only show the Name of the student AND the GPA only?
Thank you for the help!
This question is in the General Section. Responses must be helpful and on-topic.