Data cleaning: Difference between revisions

Jump to navigation Jump to search
397 bytes added ,  11 January 2016
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 & values NOT I want)</td>
     <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>

Navigation menu