=== Data Cleaner ===
Input:  @messy_customers.csv
Output: @messy_customers_clean.csv
Raw records:  20 

--- Cleaning Summary ---

  Raw rows:       20 
  Blank removed:  1 
  Kept:           0 
  Flagged:        0 
  Duplicates:     1 

--- Issues by Field ---

  name               9 issues
  signup_date        7 issues
  email              5 issues
  phone              2 issues
  purchase_amount    2 issues
  ALL                1 issue

--- Issue Log ---

  Row  Field           Problem                       Original
  ---  -----           -------                       --------
   1   email           lowercased                    JSMITH@GMAIL.COM
   1   signup_date     reformatted                   03/15/2025
   2   name            reformatted                   mary   jones
   3   name            reformatted                   ROBERT CHEN
   3   signup_date     reformatted                   01-07-2025
   4   name            reformatted                     sarah connor
   4   email           lowercased                    SARAH@WORK.COM
   4   signup_date     reformatted                   2025/02/28
   5   name            missing                       
   6   phone           missing                       (empty)
   6   signup_date     reformatted                   06/30/2025
   7   name            reformatted                   lisa PARK
   8   signup_date     reformatted                   04/18/2025
   9   name            reformatted                     Amy   Wu
   10  name            reformatted                   david miller
   10  email           lowercased                    DAVID.MILLER@OUTLOOK.COM
   12  email           missing                       
   12  signup_date     reformatted                   2025/07/15
   13  name            reformatted                   tom HANKS  jr
   13  signup_date     invalid date                  13/25/2025
   14  purchase_amount not a number                  free
   16  purchase_amount not a number                  $abc
   18  ALL             blank row                     (empty)
   20  name            reformatted                     peter parker
   20  phone           invalid (not 10 digits)       555CALL-ME
   15  email           duplicate of row 3            bob.chen@hotmail.com

--- Sample Clean Output (first 5) ---

  John Smith
    jsmith@gmail.com  (555) 123-4567
    Seattle, WA  2025-03-15  $ 1250 

  Mary Jones
    mary.jones@yahoo.com  (555) 234-5678
    Portland, OR  2025-04-22  $ 850 

  Robert Chen
    bob.chen@hotmail.com  (555) 345-6789
    San Francisco, CA  2025-01-07  $ 3400.5 

  Sarah Connor
    sarah@work.com  (555) 456-7890
    Los Angeles, CA  2025-02-28  $ 2100 

  
    admin@test.com  (555) 000-0000
    Boise, ID  2025-05-10  $ 500 
    FLAGS: no-name

Clean file written: @messy_customers_clean.csv