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