add -0.0 null
@@ -77,10 +77,11 @@ NULL_POLICIES = {
'9999.25', '999.25', 'NA', 'INF', 'IO', 'IND'],
'aggressive': ['NULL',
'9999.25', '999.25', 'NA', 'INF', 'IO', 'IND',
- '999', '999.99', '9999', '9999.99' '2147483647', '32767'],
+ '999', '999.99', '9999', '9999.99' '2147483647', '32767',
+ '-0.0', ],
'all': ['NULL',
'9999.25', '999.25', 'NA', 'INF', 'IO', 'IND',
- '999', '999.99', '9999', '9999.99' '2147483647', '32767',
+ '999', '999.99', '9999', '9999.99' '2147483647', '32767', '-0.0',
'numbers-only', ]
}
@@ -102,6 +103,8 @@ NULL_SUBS = {
(re.compile(r'[ ](-?1\.#IO)'), ' NaN '), ],
'IND': [(re.compile(r'(-?1\.#IND)[ ]'), ' NaN '),
(re.compile(r'[ ](-?1\.#IND)'), ' NaN '), ],
+ '-0.0': [(re.compile(r'(-?0\.0+)[ ]'), ' NaN '),
+ (re.compile(r'[ ](-?0\.0+)'), ' NaN '), ],
'numbers-only': [(re.compile(r'([^ 0-9.\-+]+)[ ]'), ' NaN '),
(re.compile(r'[ ]([^ 0-9.\-+]+)'), ' NaN '), ],
}
