“Python 数据分析入门与进阶”实验报告

Pandas 处理 JSON 文件

实验楼

``` import pandas as pd import json import sys import os def analysis(filename,search_id): times = 0 minutes = 0 # search_id = argv[1] data = pd.read_json(filename) df = pd.DataFrame(data) minutes = df[df.user_id == search_id]['minutes'].sum() times = df[df.user_id == search_id]['minutes'].count() return(times,minutes)

filename = 'user_study.json' if os.path.exists(filename): search_id = int(sys.argv[1]) times,minutes = analysis(filename,search_id) print(times,minutes)```

感觉没问题呀,为什么就是通不过 文件判断那是有点多余,但也不至于说是统计错误吧。。。

最新评论
暂无评论~