pandas replace empty string with nan
df = df.replace(r'^s*$', np.NaN, regex=True)pandas replace empty string with nan
df = df.replace(r'^s*$', np.NaN, regex=True)pandas dataframe convert nan to string
df.fillna('', inplace=True)pandas read_csv nan as empty string
pd.read_csv('test.csv', keep_default_na=False)pandas using eval converter excluding nans
df.fillna('()').applymap(ast.literal_eval)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)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
