I read the data from Panda through pd.read_csv.
pd = pd.read_csv('data.csv')
data= pd['header']
There's a zero in the read value has zero I want to give the value of 0 in nan. So,
data = data.replace(0,np.NAN)
If you give it, 0 changes to nan.
But I want to talk about no negative numbers I added conditions after reloading the data.
data= pd['header']
data = data.replace(0<data , np.NAN)
There is no error, but it does not change. That's all I'm saying
data[data<0] = 'nan'
If you do that, the nano value will be str.
Is there a way?
python pandas replace
For DataFrame, all values not selected in the conditional statement are NaN processed. Therefore, if you want to replace a value less than 0 with a missing value in an existing DataFrame, the following code is sufficient.
data = data[data < 0]
For Series, list compression is available.
new_data = pd.Series([i if i < 0 else np.NaN for i in data])
© 2024 OneMinuteCode. All rights reserved.