pandas replace nan
data["Gender"].fillna("No Gender", inplace = True)
pandas replace nan
data["Gender"].fillna("No Gender", inplace = True)
python pandas replace nan with null
df.fillna('', inplace=True)
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)
pandas using eval converter excluding nans
df.fillna('()').applymap(ast.literal_eval)
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us