在读取数据帧之后,添加了一个具有常量值的新列,我需要将已经呈现的“Population”值除以该列
#set directory
os.chdir("C:/Users/218214559/Desktop/Geo_Scripting/NewNamibia_data/Namibia")
#Reading data
data = pd.read_csv("Regional_Population.csv")
#Add column
data["New_val"] = ''
new = data.assign(New_val =10)
print(new)
输出
REGION_NAM Population New_val
0 Zambezi 90596 10
1 Erongo 150809 10
2 Hardap 79507 10
3 Karas 77421 10
4 Kavango West 223352 10
5 Kavango East 223352 10
6 Kunene 86856 10
7 Ohangwena 245446 10
8 Omaheke 71233 10
9 Omusati 243166 10
10 Oshana 176674 10
11 Oshikoto 181973 10
12 Otjozondjupa 143903 10
13 Khomas 342141 10
我需要将“Population”除以“New\ val”并输出“Divided”(新列),所有这些都在一个3参数函数中,例如
def divide(x,y,z):
x = Population
y = New_val
z = Divided
所需输出
REGION_NAM Population New_val Divided
0 Zambezi 90596 10 9059.6
1 Erongo 150809 10 15080.9
2 Hardap 79507 10 7950.7
3 Karas 77421 10 7742.1
4 Kavango West 223352 10 22335.2
5 Kavango East 223352 10 22335.2
6 Kunene 86856 10 8685.6
7 Ohangwena 245446 10 24544.6
8 Omaheke 71233 10 7123.3
9 Omusati 243166 10 24316.6
10 Oshana 176674 10 17667.4
11 Oshikoto 181973 10 18197.3
12 Otjozondjupa 143903 10 14390.3
13 Khomas 342141 10 34214.1
目前没有回答
相关问题 更多 >
编程相关推荐