它的代码我给下面它给我错误.我使用jupyter笔记本，我写了一个代码来删除表列和行，但代码给我错误

Question

这是我的代码

import pandas as pd area=pd.Series({"Peshawar":
> 123456,"Karak":4784832,"Kohat":843932,"Mansehra":748392})
> 
> pop=pd.Series({"Peshawar":
> 123456,"Karak":4784832,"Kohat":849392,"Mansehra":743392})
> 
> data=pd.DataFrame({"area":area,"pop":pop}) data
> data.drop[:"peshawar",:"pop"]
code error

NameError回溯(最近的)call last) ~AppDataLocalTemp/ipykernel_9516/3219075350.py in——比;1 data.drop[:"peshawar":"pop"]

NameError: name 'data' is not defined

Answer 1

格式在python中很重要，尊重换行符!

import pandas as pd
area=pd.Series({"Peshawar": 123456,"Karak":4784832,"Kohat":843932,"Mansehra":748392})
pop=pd.Series({"Peshawar": 123456,"Karak":4784832,"Kohat":849392,"Mansehra":743392})
data=pd.DataFrame({"area":area,"pop":pop})
#data.drop[:"peshawar",:"pop"] # this is not valid in pandas

Answer 2

创建data的正确代码:

area=pd.Series({"Peshawar":123456,"Karak":4784832,"Kohat":843932,"Mansehra":748392})
pop=pd.Series({"Peshawar":123456,"Karak":4784832,"Kohat":849392,"Mansehra":743392})
data=pd.DataFrame({"area":area,"pop":pop})

删除一行:

>>> data.drop('Peshawar')
area      pop
Karak     4784832  4784832
Kohat      843932   849392
Mansehra   748392   743392

删除一个列:

>>> data.drop('pop', axis=1)
area
Peshawar   123456
Karak     4784832
Kohat      843932
Mansehra   748392

删除一列和一行:

>>> data.drop('pop', axis=1).drop('Peshawar', axis=0)  # axis=0 is the default
area
Karak     4784832
Kohat      843932
Mansehra   748392

不能删除单元格，但可以将其设置为NaN:

>>> data.loc['Peshawar', 'pop'] = float('nan')
area        pop
Peshawar   123456        NaN
Karak     4784832  4784832.0
Kohat      843932   849392.0
Mansehra   748392   743392.0