我對(duì) Pandas 很陌生,所以我不知道該怎么做。我有一個(gè)帶有 Pandas 的 Python 腳本,用于從在線 .csv 中檢索數(shù)據(jù),其中包含西班牙各省的 covid 數(shù)據(jù)。我想創(chuàng)建一個(gè)新列來創(chuàng)建一個(gè)新變量。這些將是(每日新增死亡人數(shù)/100.000 人口) 有可能嗎?在 csv 中,我們已經(jīng)有了人口數(shù)據(jù),因此函數(shù)為:(population/1.000.000)*daily_deaths這是我的代碼,所以我不知道如何開始import requestsimport pandas as pddf1 = pd.read_csv("https://raw.githubusercontent.com/montera34/escovid19data/master/data/output/covid19-provincias-spain_consolidated.csv")df1 = pd.DataFrame(df1) #no indexAlbacete = df1.loc[df1["province"] == "Albacete"]Alicante = df1[df1['ine_code'] == 3][['date',"PCR","TestAc",'province',"new_cases","activos","hospitalized","intensive_care","deceased","cases_accumulated","recovered","cases_per_cienmil","intensive_care_per_1000000","deceassed_per_100000","hospitalized_per_100000","daily_deaths","deaths_last_week"]]Almeria = df1.loc[df1['ine_code'] == 3]Alava = df1.loc[df1['ine_code'] == 1]Asturias = df1.loc[df1['ine_code'] == 33]Avila = df1.loc[df1['ine_code'] == 5]Badajoz = df1.loc[df1['ine_code'] == 6]Baleares = df1.loc[df1['ine_code'] == 7]Barcelona= df1.loc[df1['ine_code'] == 8]Bizcaia = df1.loc[df1['ine_code'] == 48]Burgos = df1.loc[df1['ine_code'] == 9]Caceres = df1.loc[df1['ine_code'] == 10]Cadiz = df1.loc[df1['ine_code'] == 11]Cantabria= df1.loc[df1['ine_code'] == 39] Castellon= df1.loc[df1['ine_code'] == 12]Ceuta = df1.loc[df1['ine_code'] == 51]Ciudad_R = df1.loc[df1['ine_code'] == 13]Cordoba = df1.loc[df1['ine_code'] == 14]Cuenca = df1.loc[df1['ine_code'] == 16]Guipuzcoa= df1.loc[df1['ine_code'] == 20]Girona = df1.loc[df1['ine_code'] == 17] Madrid = df1[df1['ine_code'] == 28][['date',"PCR","TestAc",'province',"new_cases","activos","hospitalized","intensive_care","deceased","cases_accumulated","recovered","cases_per_cienmil","intensive_care_per_1000000","deceassed_per_100000","hospitalized_per_100000","daily_deaths","deaths_last_week"]]
如何創(chuàng)建一個(gè)具有小而簡(jiǎn)單功能的新列
幕布斯6054654
2023-08-22 16:53:52