需要函数(使用'def'),该函数按行分隔数据帧中的两列,并添加一个显示resu的新列

2024-09-30 20:18:45 发布

您现在位置:Python中文网/ 问答频道 /正文

在读取数据帧之后,添加了一个具有常量值的新列,我需要将已经呈现的“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

Tags: csvnewdatavalregionpopulationwestkaras