PYTHON

how to replace nan with 0 in pandas

df['product']=df['product'].fillna(0)
df['context']=df['context'].fillna(0)
df

replace nan in pandas

df['DataFrame Column'] = df['DataFrame Column'].fillna(0)

replace "-" for nan in dataframe

df.replace(np.nan,0)

pandas replace empty string with nan

df = df.replace(r'^s*$', np.NaN, regex=True)

pandas replace nan

data["Gender"].fillna("No Gender", inplace = True) 

python pandas replace nan with null

df.fillna('', inplace=True)

how to replace nan values with 0 in pandas

df.fillna(0)

replace error with nan pandas

df['workclass'].replace('?', np.NaN)

pandas replce none with nan

df = df.fillna(value=np.nan)

Replace the string with NAN value

data['horsepower'].replace(to_replace='?' , value = np.nan,inplace = True)
data['horsepower'].unique()

replace all nan values in dataframe

# Replacing all nan values with 0 in Dataframe
df = df.fillna(0)

pandas replace nan with mean

--fillna
product_mean = df['product'].mean()
df['product'] = df['product'].fillna(product_mean)

--replace method
col_mean = np.mean(df['col'])
df['col'] = df['col'].replace(np.nan, col_mean)

pandas nan to None

df = df.astype("object").where(pd.notnull(df), None)

python dataframe replace nan with 0

In [7]: df
Out[7]: 
          0         1
0       NaN       NaN
1 -0.494375  0.570994
2       NaN       NaN
3  1.876360 -0.229738
4       NaN       NaN

In [8]: df.fillna(0)
Out[8]: 
          0         1
0  0.000000  0.000000
1 -0.494375  0.570994
2  0.000000  0.000000
3  1.876360 -0.229738
4  0.000000  0.000000

replace nan with 0 pandas

DataFrame.fillna()

pandas replace nan with none

df = df.where(pd.notnull(df), None)

represent NaN with pandas in python

import pandas as pd

if pd.isnull(float("Nan")):
  print("Null Value.")

how to replace nan values in pandas with mean of column

#fill nan values with mean
df = df.fillna(df.mean())

pandas where retuning NaN

# Try using a loc instead of a where:
df_sub = df.loc[df.yourcolumn == 'yourvalue']

pandas replace nan with value above

>>> df = pd.DataFrame([[1, 2, 3], [4, None, None], [None, None, 9]])
>>> df.fillna(method='ffill')
   0  1  2
0  1  2  3
1  4  2  3
2  4  2  9

pandas replace empty string with nan

df = pd.DataFrame([
    [-0.532681, 'foo', 0],
    [1.490752, 'bar', 1],
    [-1.387326, 'foo', 2],
    [0.814772, 'baz', ' '],     
    [-0.222552, '   ', 4],
    [-1.176781,  'qux', '  '],         
], columns='A B C'.split(), index=pd.date_range('2000-01-01','2000-01-06'))

# replace field that's entirely space (or empty) with NaN
print(df.replace(r'^s*$', np.nan, regex=True))

# output
#                    A    B   C
# 2000-01-01 -0.532681  foo   0
# 2000-01-02  1.490752  bar   1
# 2000-01-03 -1.387326  foo   2
# 2000-01-04  0.814772  baz NaN
# 2000-01-05 -0.222552  NaN   4
# 2000-01-06 -1.176781  qux NaN

how to replace nan values in pandas with mean of column

#fill nan values with mean
df = df.fillna(df.mean())

turn False to nan pandas

In [1]: df = DataFrame([[True, True, False],[False, False, True]]).T

In [2]: df
Out[2]:
       0      1
0   True  False
1   True  False
2  False   True

In [3]: df.applymap(lambda x: 1 if x else np.nan)
Out[3]:
    0   1
0   1 NaN
1   1 NaN
2 NaN   1

pandas nan to none

df1 = df.where(pd.notnull(df), None)

replace all occurrences of a value to nan in pandas

import pandas as pd
import numpy as np

df = pd.DataFrame({'col1':['one', 'two', 'three', 'four']})

df['col1'] = df['col1'].map(lambda x: np.nan if x in ['two', 'four'] else x)

pandas using eval converter excluding nans

df.fillna('()').applymap(ast.literal_eval)

replace nan in pandas column with mode and printing it

def exercise4(df):
    df1 = df.select_dtypes(np.number)
    df2 = df.select_dtypes(exclude = 'float')
    mode = df2.mode()
    df3 = df1.fillna(df.mean())
    df4 = df2.fillna(mode.iloc[0,:])
    new_df = [df3,df4]
    df5 = pd.concat(new_df,axis=1)
    new_cols = list(df.columns)
    df6 = df5[new_cols]
    return df6

replace nan from another column

df.Temp_Rating.fillna(df.Farheit, inplace=True)
del df['Farheit']
df.columns = 'File heat Observations'.split()

pandas using eval converter excluding nans

from ast import literal_eval
from io import StringIO

# replicate csv file
x = StringIO("""A,B
,"('t1', 't2')"
"('t3', 't4')",""")

def literal_converter(val):
    # replace first val with '' or some other null identifier if required
    return val if val == '' else literal_eval(val)

df = pd.read_csv(x, delimiter=',', converters=dict.fromkeys('AB', literal_converter))

print(df)

          A         B
0            (t1, t2)
1  (t3, t4)          

replace nan with mode string pandas

#nan replace mode in string 
df['Brand'].fillna(df['Brand'].mode()[0], inplace=True)