能够使用drop,必须有行索引。读文件使用:
train = pd.read_csv("./deal_all.csv",encoding=“gbk”)
for i in range(len(clean_data)):
print(clean_data['h'][i])
if np.isnan(clean_data['h'][i]):
print(i)
clean_data = clean_data.drop(i, axis=0)
删除对应行
df = pd.DataFrame({"key": ['green', 'red', 'blue'],
"data1": ['a', 'b', 'c'], "sorce": [33, 61, 99]})
data1 = pd.concat([df, df], ignore_index=True)
data2 = data1[-data1.sorce.isin([61])]
print("---------------")
print(data1)
print("---------------")
print(data2)
print("---------------")
data3 = data1.drop(data1.ix[:, 'sorce'] == 61)
print(data3)
clean_data = clean_data[-clean_data.h.isin([61])]