新冠疫情数据统计蓝桥杯楼赛第二十三期（不考虑自动化处理缺省值）

最新推荐文章于 2022-09-18 14:45:44 发布

终是蝶衣梦晓楼

最新推荐文章于 2022-09-18 14:45:44 发布

阅读量152

点赞数 1

分类专栏：蓝桥杯 python

本文链接：https://blog.csdn.net/SUMPLUSS/article/details/119802981

版权

python 同时被 2 个专栏收录

36 篇文章 1 订阅

订阅专栏

蓝桥杯

2 篇文章 0 订阅

订阅专栏

原题链接

import csv
import json
import country_converter as coco

def main():
    cc = coco.CountryConverter()
    Confirmed = {"Africa": 0, "Asia": 0, "Oceania": 0,"Europe": 0, "America": 0, "Others": 0, "Total": 0}
    Deaths = {"Africa": 0, "Asia": 0, "Oceania": 0,"Europe": 0, "America": 0, "Others": 0, "Total": 0}
    Recovered = {"Africa": 0, "Asia": 0, "Oceania": 0,"Europe": 0, "America": 0, "Others": 0, "Total": 0}
    Active = {"Africa": 0, "Asia": 0, "Oceania": 0,"Europe": 0, "America": 0, "Others": 0, "Total": 0}

    country_list = []
    ls = []

    data = "楼赛第三题\okcases_country.csv"
    with open(data, 'r') as f:
        reader = csv.reader(f)
        for row in reader:
            if row[0] == "Country_Region":
                pass
            else:
                country_name = row[0]
                country_list.append(country_name)
        continent = cc.convert(names = country_list, to = 'continent', not_found= "Others")

    with open(data, 'r') as f:
        reader = csv.reader(f)    
        rows = [row for row in reader]

        for a in range(len(continent)):
            #print(a)
            #print(int(float(rows[a+1][4])))
            #print(int(float(rows[a+1][5])))
            #print(int(float(rows[a+1][6])))
            #print(int(float(rows[a+1][7])))

            if continent[a] == "Asia":
                Confirmed[continent[a]] = Confirmed.get(continent[a] , 0) + int(float(rows[a+1][4]))
                Deaths[continent[a]] = Deaths.get(continent[a] , 0) + int(float(rows[a+1][5]))
                Recovered[continent[a]] = Recovered.get(continent[a] , 0) + int(float(rows[a+1][6]))
                Active[continent[a]] = Active.get(continent[a] , 0) + int(float(rows[a+1][7]))
            elif continent[a] == "Europe":
                Confirmed[continent[a]] = Confirmed.get(continent[a] , 0) + int(float(rows[a+1][4]))
                Deaths[continent[a]] = Deaths.get(continent[a] , 0) + int(float(rows[a+1][5]))
                Recovered[continent[a]] = Recovered.get(continent[a] , 0) + int(float(rows[a+1][6]))
                Active[continent[a]] = Active.get(continent[a] , 0) + int(float(rows[a+1][7]))
            elif continent[a] == "Africa":
                Confirmed[continent[a]] = Confirmed.get(continent[a] , 0) + int(float(rows[a+1][4]))
                Deaths[continent[a]] = Deaths.get(continent[a] , 0) + int(float(rows[a+1][5]))
                Recovered[continent[a]] = Recovered.get(continent[a] , 0) + int(float(rows[a+1][6]))
                Active[continent[a]] = Active.get(continent[a] , 0) + int(float(rows[a+1][7]))
            elif continent[a] == "America":
                Confirmed[continent[a]] = Confirmed.get(continent[a] , 0) + int(float(rows[a+1][4]))
                Deaths[continent[a]] = Deaths.get(continent[a] , 0) + int(float(rows[a+1][5]))
                Recovered[continent[a]] = Recovered.get(continent[a] , 0) + int(float(rows[a+1][6]))
                Active[continent[a]] = Active.get(continent[a] , 0) + int(float(rows[a+1][7]))
            elif continent[a] == "Oceania":
                Confirmed[continent[a]] = Confirmed.get(continent[a] , 0) + int(float(rows[a+1][4]))
                Deaths[continent[a]] = Deaths.get(continent[a] , 0) + int(float(rows[a+1][5]))
                Recovered[continent[a]] = Recovered.get(continent[a] , 0) + int(float(rows[a+1][6]))
                Active[continent[a]] = Active.get(continent[a] , 0) + int(float(rows[a+1][7]))
            elif continent[a] == "Others":
                Confirmed[continent[a]] = Confirmed.get(continent[a] , 0) + int(float(rows[a+1][4]))
                Deaths[continent[a]] = Deaths.get(continent[a] , 0) + int(float(rows[a+1][5]))
                Recovered[continent[a]] = Recovered.get(continent[a] , 0) + int(float(rows[a+1][6]))
                Active[continent[a]] = Active.get(continent[a] , 0) + int(float(rows[a+1][7]))

            
            Confirmed["Total"] = Confirmed["Africa"] + Confirmed["Asia"] + Confirmed["Oceania"] + Confirmed["Europe"] + Confirmed["America"] +Confirmed["Others"]
            Active["Total"] = Active["Africa"] + Active["Asia"] + Active["Oceania"] + Active["Europe"] + Active["America"] +Active["Others"]
            Deaths["Total"] = Deaths["Africa"] + Deaths["Asia"] + Deaths["Oceania"] + Deaths["Europe"] + Deaths["America"] +Deaths["Others"]
            Recovered["Total"] = Recovered["Africa"] + Recovered["Asia"] + Recovered["Oceania"] + Recovered["Europe"] + Recovered["America"] +Recovered["Others"]
            
            results = {
                "Confirmed": Confirmed,
                "Deaths": Deaths,
                "Recovered": Recovered,
                "Active": Active,
            }
    print(results)    
    return json.dumps(results, indent=2)       
main()
#一个学生物的编程爱好者#

这是在不考虑自动化处理缺省值的情况下的答案，至于使用numpy和pandas的自动化处理的版本近期将会更新。