替换值replace
from pandas import Series import numpy as np data = Series([1,-999,2,-999,-1000,3]) print(data) ''' 0 1 1 -999 2 2 3 -999 4 -1000 5 3 dtype: int64 ''' print(data.replace(-999,np.nan)) ''' 0 1.0 1 NaN 2 2.0 3 NaN 4 -1000.0 5 3.0 dtype: float64 ''' # 一次性替换多个值 print(data.replace([-999,-1000],np.nan)) ''' 0 1.0 1 NaN 2 2.0 3 NaN 4 NaN 5 3.0 dtype: float64 ''' # 不同的值进行不同的替换 print(data.replace([-999,-1000],[np.nan,0])) ''' 0 1.0 1 NaN 2 2.0 3 NaN 4 0.0 5 3.0 dtype: float64 ''' # 传入的参数也可以是字典 print(data.replace({-999:np.nan,-1000:0})) ''' 0 1.0 1 NaN 2 2.0 3 NaN 4 0.0 5 3.0 dtype: float64 '''
本文来自博客园,作者:OTAKU_nicole,转载请注明原文链接:https://www.cnblogs.com/nicole-zhang/p/14958809.html