13,314
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→By purpose
m (→by purpose) |
|||
| Line 4: | Line 4: | ||
<table border="1" style="width: 100%"> | <table border="1" style="width: 100%"> | ||
<tr style="background-color: #555555; color: #ffffff;"> | <tr style="background-color: #555555; color: #ffffff;"> | ||
<td style="background-color: #777; color: #ffffff;"> | <td style="background-color: #777; color: #ffffff;">Purpose</td> | ||
<td style="background-color: #777; color: #ffffff;"> | <td style="background-color: #777; color: #ffffff; width: 350px;">Method (MySQL query syntax)</td> | ||
<td> | <td style="vertical-align: top;">Value1: <br />Fulfilled value what I want</td> | ||
<td> | <td style="vertical-align: top;">Value2: <br />Fulfilled value NOT I want</td> | ||
<td> | <td style="vertical-align: top;">Value3: <br />0</td> | ||
<td> | <td style="vertical-align: top;">Value4: <br />NULL value</td> | ||
<td> | <td style="vertical-align: top;">Value5: <br />Empty or white-spaces characters</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>values were not fulfilled or empty <br />(not contains 0)</td> | <td>values were not fulfilled or empty <br />(not contains 0)</td> | ||
<td>{{kbd | key= | <td>{{kbd | key=WHERE column_name IS NULL <br /> OR LENGTH(TRIM( column_name )) = 0}}</td> | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| Line 50: | Line 50: | ||
<tr> | <tr> | ||
<td>values (1) were not fulfilled or empty values (2) NOT I want <br />(not contains 0)</td> | <td>values (1) were not fulfilled or empty values (2) NOT I want <br />(not contains 0)</td> | ||
<td>{{kbd | key= | <td>{{kbd | key=WHERE column_name IS NULL <br /> OR LENGTH(TRIM( column_name )) = 0 <br /> OR column_name LIKE 'values NOT I want'}}</td> | ||
<td></td> | <td></td> | ||
<td>V</td> | <td>V</td> | ||