14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→by purpose
| Line 14: | Line 14: | ||
<tr> | <tr> | ||
<td>find not fulfilled or empty values <br />(not contains 0)</td> | <td>find not fulfilled or empty values <br />(not contains 0)</td> | ||
<td>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0</td> | <td>{{kbd | key=<nowiki>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0</nowiki>}}</td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| Line 41: | Line 41: | ||
<tr> | <tr> | ||
<td>find fulfilled and non-empty values <br />(contains 0)</td> | <td>find fulfilled and non-empty values <br />(contains 0)</td> | ||
<td>WHERE LENGTH(TRIM( column_name )) > 0</td> | <td>{{kbd | key=<nowiki>WHERE LENGTH(TRIM( column_name )) > 0</nowiki>}}</td> | ||
<td>V</td> | <td>V</td> | ||
<td>V</td> | <td>V</td> | ||
| Line 49: | Line 49: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>find not fulfilled or empty values <br />(not contains 0 | <td>find (1) not fulfilled or empty values (2) values NOT I want <br />(not contains 0)</td> | ||
<td>{{kbd | key=<nowiki>WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0 OR column_name LIKE 'values NOT I want'</nowiki>}}</td> | |||
<td></td> | |||
<td>V</td> | |||
<td></td> | |||
<td>V</td> | |||
<td>V</td> | |||
</tr> | |||
<tr> | |||
<td>find (1) not fulfilled or empty values (2) values NOT I want <br />(contains 0)</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
<td>V</td> | <td>V</td> | ||
<td></td> | <td>V</td> | ||
<td>V</td> | <td>V</td> | ||
<td>V</td> | <td>V</td> | ||