Avatar ·

根据字典替换DataFrame特定列中的值

📁 python

需要根据字典替换DataFrame特定列中的值,如果字典中未找到键,则从DataFrame中删除整行。

我能够这样完成任务:

dict1 = {'Car': 'c', 'Motorcycle': 'mt', 'Truck': 'tr'}df = pd.DataFrame({'Product': 'Truck Motorcycle Car Car Tire Wheel Truck'.split(),                   'Price': [10000, 5000, 23000, 15000, 500, 300, 8000]})df['Product_new'] = df['Product'].map(dict1)df.dropna(inplace=True)df.drop('Product', axis=