14,962
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→is null
m (→is null) |
|||
| Line 176: | Line 176: | ||
** (1) Using [http://www.w3resource.com/mysql/comparision-functions-and-operators/coalesce-function.php COALESCE() function] to replace the NULL value with 0. | ** (1) Using [http://www.w3resource.com/mysql/comparision-functions-and-operators/coalesce-function.php COALESCE() function] to replace the NULL value with 0. | ||
** (2) The case: 0/0 = null should be handled. | ** (2) The case: 0/0 = null should be handled. | ||
* MySQL SQL syntax: combined IF() & ISNULL():{{kbd | key = SELECT IF(ISNULL((column_name), 0, column_name}} or {{kbd | key = SELECT IF(ISNULL((column_name), 'other_filled_value', column_name)}} | * MySQL SQL syntax: combined IF() & ISNULL():{{kbd | key = SELECT IF(ISNULL((column_name), 0, column_name) }} or {{kbd | key = SELECT IF(ISNULL((column_name), 'other_filled_value', column_name) }} | ||
* python: [http://pandas.pydata.org/pandas-docs/dev/generated/pandas.DataFrame.fillna.html pandas.DataFrame.fillna — pandas 0.16.0 documentation] "Fill NA/NaN values using the specified method" | * python: [http://pandas.pydata.org/pandas-docs/dev/generated/pandas.DataFrame.fillna.html pandas.DataFrame.fillna — pandas 0.16.0 documentation] "Fill NA/NaN values using the specified method" | ||