Answers for "pd.read excel read cells with only spaces as nan not as string"

pandas replace empty string with nan

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

Posted by: Guest on June-09-2020

Code answers related to "pd.read excel read cells with only spaces as nan not as string"