Replacing Pandas Dataframe output from NoneType to 0

Question

Output of a SQL query that I am storing in a dataframe is of NoneType.

How could I replace this to 0

db_conn.execute(f"""select count (*) from table""")
output = db_conn.fetchone()[0]

something like df.astype('str').replace('None','interesting') or for a specific column like df.col.astype('str').replace('None','interesting') should work, else please post some data — iamklaus
– iamklaus, Commented Sep 24, 2019 at 10:16

Zaynul Abadin Tuhin · Accepted Answer · 2019-09-24 10:17:04Z

1

you could use replace() if none is a string

df.replace('None', 0)

but for NaN you can try fillna

df = df.fillna(0)

answered Sep 24, 2019 at 10:17

32.1k6 gold badges38 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1