[Python] Loading csv files using pandas

import pandas as pd
xxx = pd.read_csv('sample.csv') #xxx is an appropriate variable

print (xxx) #Output of all columns

import pandas as pd
filename = pd.read_csv('sample.csv',encoding="SHIFT-JIS")#Or UTF-8

listA = []
listB = []

listA =  filename['student number']
listB =  filename['Score']
max=0
leng = len(listA)

for n in range(leng):
	if listB[n]>max:
		max=listB[n]
		num = n
print ('The student number with the highest score is'+str(listA[num]))

Recommended Posts