USguns

来源:互联网 发布:classic动作数据mmd 编辑:程序博客网 时间:2024/06/06 02:15

数据来源:链接

import csvimport datetimedata = list(csv.reader(open("guns.csv")))[1:]years_count = {}years = [row[1]for row in data]for item in years:    if item in years_count:        years_count[item] += 1     else:        years_count[item] = 1dates = [datetime.datetime(year=int(row[1]),month=int(row[2]),day=1)for row in data]date_counts= {}for item in dates:    format_date = item.strftime("%Y-%m-%d")    if format_date in date_counts:        date_counts[format_date] += 1    else :         date_counts[format_date] = 1def fac_counts(fac_num):    fac_counts ={}    for row in data:        if row[fac_num] in fac_counts:            fac_counts[row[fac_num]] += 1        else:            fac_counts[row[fac_num]] = 1    return fac_countssex_counts = fac_counts(5)race_counts =fac_counts(7)census =list(csv.reader(open("census.csv")))race_population = {    "Asian/Pacific Islander":15159516+674625,    "Black":40250635,    "Native American/Native Alaskan":3739506,    "Hispanic":44618105,    "White":197318956}race_per_hundredk ={}for item in race_counts:    race_per_hundredk[item] = race_counts[item]/race_population [item]*100000intents =[row[3]for row in data]races = [row[7]for row in data]homicide_race_per_hundredk={}for i, race in enumerate(races):    if intents[i] == "Homicide":        if race in homicide_race_per_hundredk:            homicide_race_per_hundredk[race] += 1        else:            homicide_race_per_hundredk[race] = 1for item in homicide_race_per_hundredk:    homicide_race_per_hundredk[item] = homicide_race_per_hundredk[item]/race_population [item]*100000homicide_race_per_hundredk
0 0