python mean dropna_Python/Pandas Dataframe替换0与中值

我认为你可以使用mask并添加参数skipna=True到mean而不是dropna。还需要更改条件data.artist_hotness == 0如果需要更换0值或data.artist_hotness.isnull()如果需要NaN值替换：

import pandas as pd

import numpy as np

data = pd.DataFrame({'artist_hotness': [0,1,5,np.nan]})

print (data)

artist_hotness

0 0.0

1 1.0

2 5.0

3 NaN

mean_artist_hotness = data['artist_hotness'].mean(skipna=True)

print (mean_artist_hotness)

2.0

data['artist_hotness']=data.artist_hotness.mask(data.artist_hotness == 0,mean_artist_hotness)

print (data)

artist_hotness

0 2.0

1 1.0

2 5.0

3 NaN

或者使用loc，但省略列名：

data.loc[data.artist_hotness == 0, 'artist_hotness'] = mean_artist_hotness

print (data)

artist_hotness

0 2.0

1 1.0

2 5.0

3 NaN

data.artist_hotness.loc[data.artist_hotness == 0, 'artist_hotness'] = mean_artist_hotness

print (data)

IndexingError: (0 True 1 False 2 False 3 False Name: artist_hotness, dtype: bool, 'artist_hotness')

data=data.replace({'artist_hotness': {0: mean_artist_hotness}})

print (data)

aa artist_hotness

0 0.0 2.0

1 1.0 1.0

2 5.0 5.0

3 NaN NaN

或者，如果需要的所有列替换所有0值：

import pandas as pd

import numpy as np

data = pd.DataFrame({'artist_hotness': [0,1,5,np.nan], 'aa': [0,1,5,np.nan]})

print (data)

aa artist_hotness

0 0.0 0.0

1 1.0 1.0

2 5.0 5.0

3 NaN NaN

mean_artist_hotness = data['artist_hotness'].mean(skipna=True)

print (mean_artist_hotness)

2.0

data=data.replace(0,mean_artist_hotness)

print (data)

aa artist_hotness

0 2.0 2.0

1 1.0 1.0

2 5.0 5.0

3 NaN NaN

如果需要更换NaN中的所有列使用DataFrame.fillna：

data=data.fillna(mean_artist_hotness)

print (data)

aa artist_hotness

0 0.0 0.0

1 1.0 1.0

2 5.0 5.0

3 2.0 2.0

但是，如果只在某些列使用Series.fillna：

data['artist_hotness'] = data.artist_hotness.fillna(mean_artist_hotness)

print (data)

aa artist_hotness

0 0.0 0.0

1 1.0 1.0

2 5.0 5.0

3 NaN 2.0