mysql中的nan_使用python-cod将MySql列中的“NAN”值转换为NULL

我通过python在MySql中编写/存储数据。如果MySql中的列数据包含“NAN”，那么我如何处理它们。目前我知道如何处理空白或无值，但在这里我被卡住了。数据看起来像这样# file no 2

# some description line

#"Time","col.no","dat.va","all_val","graph_da","tem","vel","acc", "all.valu","rand"

"2016-02-25 14:50:00",0,12.94,20.88,17.87,"NAN",14,14,13.9,"NAN"

"2016-02-25 15:00:00",1,13.48,20.86,18,"NAN",13.4,13,13.2,"NAN"

"2016-02-25 15:10:00",2,13.89,20.84,18.07,18.03,12.8,12,12.6,13

"2016-02-25 21:30:00",3,15.76,20.18,17.96,18.25,0.09,0,0.07,0.16

"2016-02-25 21:40:00",4,15.72,,17.91,,0.08,"NAN",0.09,0.18

"2016-02-25 21:50:00",5,15.66,20.07,17.86,18.17,0.03,"NAN",0.05,0.09

"2016-02-25 23:30:00",6,14.98,19.26,17.12,17.44,"NAN","NAN","NAN","NAN"

有几千行随机地包含这个“NAN”，因此如果有人给我逻辑来处理它会很好，例如每当遇到NAN时，它都会输入NAN或none。我处理空白的代码是这样的。在

^{pr2}$

任何帮助或建议将不胜感激，因为我尽我所能找到解决办法，但我没有发现任何有用的。提前谢谢你的帮助。在