Replacing Pandas or Numpy Nan with a None to use with MysqlDB

Become part of the top 3% of the developers by applying to Toptal https://topt.al/25cXVn

--

Music by Eric Matyas
https://www.soundimage.org
Track title: Book End

--

Chapters
00:00 Question
00:35 Accepted answer (Score 320)
01:51 Answer 2 (Score 292)
02:16 Answer 3 (Score 27)
02:33 Answer 4 (Score 23)
02:47 Thank you

--

Full question
https://stackoverflow.com/questions/1416...

Accepted answer links:
[where]: https://pandas.pydata.org/pandas-docs/st...
[astype]: https://pandas.pydata.org/pandas-docs/st...
[fillna]: https://pandas.pydata.org/pandas-docs/st...
[replace]: https://pandas.pydata.org/pandas-docs/st...
[this (closed) issue]: https://github.com/pydata/pandas/issues/...
[the difference between NaN and None in pandas]: https://stackoverflow.com/q/17534106/124...

Answer 2 links:
[For pandas versions <1.4,]: https://github.com/pandas-dev/pandas/iss...
[this Github issue]: https://github.com/pandas-dev/pandas/iss...
[Killian Huyghe]: https://stackoverflow.com/users/12094598...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#python #pandas #numpy #mysqlpython

#avk47