how to replace empty string with null in pandas?

Question

empty string like this isnull() not find empty string

conn = connect(host='localhost',port=3306,user='root',password='root',database='spiderdata',charset='utf8')
df = pd.read_sql('select * from beikedata_community1',con=conn)
df
df.subway.isnull()

**i want to use 'isnull()' find missing value, but it's not support empty string, what can i do? thanks very much!**

Answer 1

You can use print(df.replace(r' ', 'NaN')) . This Replaces the empty cells with NaN.