pandas 去除非数字及错误

    path = r'\\c价.xlsx'
    df = pd.read_excel(path)
    df = df.sort_values(by='YM', ascending=False)
    df.dropna(inplace=True)
    df['cc'] = np.where(df['单价'].str.isdigit()==False, '非数字', df['单价'])
    df = df[df['cc']!='非数字']
    del df['cc']
    df = df.drop_duplicates(subset='编码', keep='first')
    print(df)