我不能从数据框中删除没有值的行,为什么?

2024-04-19 05:26:38 发布

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

我不能删除数据帧中没有值的行,为什么?我已经试过很多方法,但都不管用。我的dataframe是一个json,我的“priority”列有许多空值,我想删除一些没有值的卷,或者至少用一些东西填充它们,以便我可以进行一些培训。你知道吗

我试过了

raw_df = pd.read_json("pd_calls.json")
df = raw_df.rename(columns=raw_df.iloc[0]).drop(0)

df.dropna()
feature_cols = ['date_time','FullAddress','call_type','priority','lat','long']
x = df[feature_cols]

x.dropna()
x = x[pd.notnull(x['priority'])]
df = df.dropna(how='any') 
df
still displaying the rows with no values for "priority" 

我的json优先级数据集是L,应该是1到4 空的L是“”

{"A": "P17070009161", "B": "7/6/2017 8:35", "C": "5", "D": "36200", "E": "", "F": "BLADEN AV MURRIETTA", "G": "", "H": "36200 BLADEN AV MURRIETTA, San Diego, CA", "I": "1182", "J": "CAN", "K": "999", "L": "2", "M": "33.5569955", "N": "-117.1839502"},
{"A": "P17070042146", "B": "7/25/2017 10:58", "C": "3", "D": "42100", "E": "", "F": "ALEXANDRA DR MURRIETTA", "G": "", "H": "42100 ALEXANDRA DR MURRIETTA, San Diego, CA", "I": "WARRANT", "J": "W", "K": "999", "L": "3", "M": "32.903892", "N": "-117.219352"},
{"A": "P17040037291", "B": "4/22/2017 16:35", "C": "7", "D": "42100", "E": "", "F": "ORANGE BOSSOM TEMECULA", "G": "", "H": "42100 ORANGE BOSSOM TEMECULA, San Diego, CA", "I": "AU1", "J": "W", "K": "999", "L": "1", "M": "33.5121386", "N": "-117.1350924"},
{"A": "P17050008176", "B": "5/5/2017 19:57", "C": "6", "D": "59800", "E": "", "F": "ALBEMARLE", "G": "ST", "H": "59800 ALBEMARLE ST, San Diego, CA", "I": "MCTSTP", "J": "O", "K": "438", "L": "1", "M": "32.676946", "N": "-117.0652657"},
{"A": "P17020026861", "B": "2/16/2017 12:08", "C": "5", "D": "60300", "E": "", "F": "AVE DE LAS VISTAS", "G": "", "H": "60300 AVE DE LAS VISTAS, San Diego, CA", "I": "MCTSTP", "J": "O", "K": "725", "L": "1", "M": "32.5822973", "N": "-117.0092733"},
{"A": "P17010005533", "B": "1/4/2017 13:57", "C": "4", "D": "75700", "E": "", "F": "SARANAC", "G": "", "H": "75700 SARANAC, San Diego, CA", "I": "FU", "J": "K", "K": "326", "L": "2", "M": "32.7707775", "N": "-117.0492753"},
{"A": "P17050025037", "B": "5/15/2017 16:10", "C": "2", "D": "104400", "E": "", "F": "BLACK MOUNTAIN", "G": "RD", "H": "104400 BLACK MOUNTAIN RD, San Diego, CA", "I": "REPORT", "J": "W", "K": "242", "L": "", "M": "32.9390205", "N": "-117.1284305"},
{"A": "P17070034017", "B": "7/20/2017 14:46", "C": "5", "D": "104400", "E": "", "F": "BLACK MOUNTAIN", "G": "RD", "H": "104400 BLACK MOUNTAIN RD, San Diego, CA", "I": "REPORT", "J": "W", "K": "242", "L": "", "M": "32.9390205", "N": "-117.1284305"},
{"A": "P17080000540", "B": "8/1/2017 9:55", "C": "3", "D": "123300", "E": "", "F": "SALMON RIVER", "G": "RD", "H": "123300 SALMON RIVER RD, San Diego, CA", "I": "REPORT", "J": "W", "K": "233", "L": "", "M": "32.9540226", "N": "-117.1207721"}
]

在熊猫身上

date_time                 FullAddress   call_type   priority  lat           long
1   6/14/2017 21:54 10 14TH ST, San Diego, CA   1151    2   32.7054489  -117.1518696
2   3/29/2017 22:24 10 14TH ST, San Diego, CA   1016    2   32.7054489  -117.1518696
3   6/3/2017 18:04  10 14TH ST, San Diego, CA   1016    2   32.7054489  -117.1518696
4   3/17/2017 10:57 10 14TH ST, San Diego, CA   1151    2   32.7054489  -117.1518696
5   3/3/2017 23:45  10 15TH ST, San Diego, CA   911P    2   32.7057215  -117.1503498
6   2/10/2017 8:23  10 15TH ST, San Diego, CA   AU2     2   32.7057215  -117.1503498
7   4/11/2017 4:57  10 15TH ST, San Diego, CA   5150    2   32.7057215  -117.1503498
8   3/28/2017 6:30  10 15TH ST, San Diego, CA   1146        32.7057215  -117.1503498
9   6/22/2017 10:19 10 15TH ST, San Diego, CA   242      1  32.7057215  -117.1503498
10  6/5/2017 19:27  10 15TH ST, San Diego, CA   5150    2   32.7057215  -117.1503498
11  6/28/2017 11:51 10 15TH ST, San Diego, CA   415     2      32.7057215   -117.1503498
12  6/28/2017 12:28 10 15TH ST, San Diego, CA   911P    2   32.7057215  -117.1503498
13  7/7/2017 21:59  10 15TH ST, San Diego, CA   647F    2   32.7057215  -117.1503498
14  8/11/2017 7:07  10 15TH ST, San Diego, CA   1140OD      32.7057215  -117.1503498

Tags: reportjsondfrawrdcapdblack