← 返回题库
初级

解析广告屏设备注册体

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    scr_csv = open_url("https://data.zuihe.com/dbd/ms-adlift/state_00/screens.csv").read()
    screens = pd.read_csv(StringIO(scr_csv))
    print("Screen registry (first 5):")
    for _, row in screens.head(5).iterrows():
        print("  "+row['screen_id']+": model="+row['model']+" net="+row['network_type']+" v="+row['player_version']+" status="+row['status']+" storage="+str(row['storage_total_mb'])+"MB")
    print("Status dist: "+str(dict(screens.groupby('status').size())))
    print("Network dist: "+str(dict(screens.groupby('network_type').size())))

示例

输入
solve()
期望输出
Screen registry (first 5):
  SCR-0001: model=LCD-720P-V net=4G+WiFi v=2.3.3 status=online storage=4096MB
  SCR-0002: model=LCD-1080P-H net=WiFi v=2.3.2 status=online storage=8192MB
  SCR-0003: model=LCD-1080P-V net=4G+WiFi v=2.2.7 status=fault storage=8192MB
  SCR-0004: model=LCD-720P-V net=4G+WiFi v=2.3.0 status=online storage=16384MB
  SCR-0005: model=LCD-720P-H net=4G v=2.2.7 status=online storage=4096MB
Status dist: {'fault': np.int64(10), 'maintenance': np.int64(19), 'offline': np.int64(22), 'online': np.int64(129)}
Network dist: {'4G': np.int64(58), '4G+WiFi': np.int64(68), 'WiFi': np.int64(54)}
Python 代码 🔒 登录后使用
🔒

登录后即可练习

注册免费账号，在浏览器中直接运行 Python 代码

登录 免费注册