csv.reader(): Limit the number of columns read in Windows

[pjfarley3]

Using a copy of the file you pasted in your last message stored on my machine in "utf-8" encoding, this seems to work:

import csv

file1 = 'C:/Users/MyUserId/envtest/testutf.csv'
with open(file1, encoding="utf-8") as fp:
    crdr = csv.reader(fp, delimiter = ',')
    for data1 in crdr:
        print(data1)

Output:
['', '', '', '', 'max Attendance', '', '', 'Max Score', '425', '', '', '', '50', '25', '', '50', '25', '', '50', '25', '', '50', '25', '', '50', '25', '', '0', '25', '', '0', '25', '']
['', '', '', '23名', '8', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '']
['Photo', 'phone', '学号', '姓名', '出勤', '出勤率', '期末分数', '得分率', '得分', 'HW', 'CW', 'Week 16', 'HW', 'CW', 'Week 15', 'HW', 'CW', 'Week 14', 'HW', 'CW', 'Week 13', 'HW', 'CW', 'Week 12', 'HW', 'CW', 'Week 11', 'HW', 'CW', 'Week 10', 'HW', 'CW', 'Week 9']
['', '', '1921030146', '聂林', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0']
['', '', '1921090147', '郜阳杰', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0']
['', '', '1922190144', '汪毓韬', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0']
['', '', '1923010312', '张长乐', '7', '100', '100', '100', '425', '', '', '', '50', '25', '1', '50', '25', '1', '50', '25', '1', '50', '25', '1', '50', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1925010121', '陈尚', '4', '57.1', '47.6', '41.2', '175', '', '', '', '0', '25', '1', '50', '25', '1', '0', '0', '0', '0', '25', '0', '0', '25', '1', '0', '25', '1', '0', '0', '0']
['', '', '1926070127', '蒲瑞杰', '6', '85.7', '83.7', '82.4', '350', '', '', '', '50', '25', '1', '50', '25', '1', '50', '25', '1', '50', '25', '1', '0', '25', '1', '0', '25', '1', '0', '0', '0']
['', '', '1926070150', '张旭', '1', '14.3', '9.3', '5.9', '25', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25', '1', '0', '0', '0', '0', '0', '0']
['', '', '1926080140', '陈子华', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0']
['', '', '1926080205', '王天亮', '5', '71.4', '56.8', '47.1', '200', '', '', '', '0', '25', '0', '0', '25', '1', '0', '25', '1', '0', '25', '1', '50', '25', '1', '0', '25', '1', '0', '0', '0']
['', '', '1926080209', '闫怀壮', '3', '42.9', '27.7', '17.6', '75', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '0', '0']
['', '', '1926080216', '朱增援', '6', '85.7', '84.4', '83.5', '355', '', '', '', '50', '25', '0', '40', '25', '1', '0', '25', '1', '40', '25', '1', '50', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1926080230', '杨澜', '6', '85.7', '62.5', '47.1', '200', '', '', '', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '50', '25', '1', '0', '25', '1', '0', '0', '0']
['', '', '1926080234', '张建军', '6', '85.7', '62.5', '47.1', '200', '', '', '', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '50', '25', '1', '0', '25', '1', '0', '0', '0']
['', '', '1926080243', '游杰', '7', '100', '100', '100', '425', '', '', '', '50', '25', '1', '50', '25', '1', '50', '25', '1', '50', '25', '1', '50', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1926080254', '王润迪', '6', '85.7', '62.5', '47.1', '200', '', '', '', '0', '25', '1', '0', '25', '1', '0', '0', '0', '0', '25', '1', '50', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1927040125', '黄楚兰', '7', '100', '91.5', '85.9', '365', '', '', '', '50', '25', '1', '50', '25', '1', '0', '25', '1', '40', '25', '1', '50', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1928040103', '曹予曦', '5', '71.4', '46.2', '29.4', '125', '', '', '', '0', '0', '0', '0', '25', '1', '0', '0', '0', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1928040213', '严昕', '5', '71.4', '53.3', '41.2', '175', '', '', '', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '50', '25', '1', '0', '0', '0', '0', '0', '0']
['', '', '1929020321', '伍竹', '5', '71.4', '46.2', '29.4', '125', '', '', '', '0', '25', '1', '0', '0', '0', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '0', '0']
['', '', '1929020325', '张清源', '6', '85.7', '55.5', '35.3', '150', '', '', '', '0', '25', '1', '0', '0', '0', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1929020329', '章明慧', '7', '100', '57.6', '29.4', '125', '', '', '', '0', '25', '1', '0', '25', '1', '0', '0', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '0', '1']
['', '', '1929030133', '丁桃园', '7', '100', '70.4', '50.6', '215', '', '', '', '0', '25', '1', '40', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1', '0', '25', '1']
['', '', '1929050140', '石楷', '7', '100', '90.1', '83.5', '355', '', '', '', '50', '25', '1', '0', '25', '1', '50', '25', '1', '50', '25', '1', '30', '25', '1', '0', '25', '1', '0', '25', '1']

I hope that helps you.

Peter