python的文件和格式化

  1. 简答题
    读csv文件里的内容

img

对文件中每位同学的成绩求平均分

保存成json文件


#!/usr/bin/env python
# -*- coding:utf-8 -*-
import pandas as pd
import json
from pprint import pprint

df = pd.read_csv('score.csv',encoding='utf-8')
avg = []
for y,s,e in zip( df['语文'],df['数学'],df['英语'] ):
    avg.append( int( (y+s+e)/3  ) )
df['平均分'] = avg

result_dict = df.to_dict(orient='records')
# pprint(result_dict)
result = json.dumps(result_dict,ensure_ascii=False)
print(result)   #把这个结果保存到文件就好了

img