Clean

DataPrep.Clean provides functions for quickly and easily cleaning and validating your data.

Section Contents

• Column Headers
• Country Names
• Dates and Times
• Duplicate Values
• Email Addresses
• Geographic Goordinates
• IP Addresses
• Phone Numbers
• Text
• URLs
• US Street Addresses
• Whole DataFrame
• For Downstreaming ML Tasks
• Australian Business Numbers
• Australian Company Numbers
• Introduction
• 1. Default clean_au_acn
• 2. Output formats
• 3. inplace parameter
• 4. errors parameter
• 4. validate_au_acn()
• Australian Tax File Numbers
• Belgian VAT Numbers
• Bulgarian National Identification Numbers
• Bulgarian VAT Numbers
• Belarusian UNP Numbers
• Canadian Business Numbers
• Swiss Einzahlungsschein MIT Referenznummers
• Swiss Social Security Numbers
• Swiss Business Identifiers
• Swiss VAT Numbers
• Chile RUT/RUN Numbers
• Chinese Resident Identity Card Numbers
• Colombian Identity Codes
• Costa Rica Physical Person ID Numbers
• Costa Rica Tax Numbers
• Costa Rica Foreigners ID Numbers
• Cuban Identity Card Numbers
• Cypriot VAT Numbers
• Czech VAT Numbers
• Czech Birth Numbers
• German Company RegistryIDs
• German Personal Tax Numbers
• German Tax Numbers
• German VAT Numbers
• German Securities Identification Codes
• Danish Citizen Numbers
• Danish CVR Numbers
• Dominican Republic National Identifiers
• Dominican Republic Invoice Numbers
• Dominican Republic Tax Registrations
• Ecuadorian Personal Identity Codes
• Ecuadorian Company Tax Numbers
• Estonian Personcal ID Numbers
• Estonian KMKR Numbers
• Spanish Bank Account Codes
• Spanish Fiscal Numbers
• Spanish Meter Point Numbers
• Spanish Personal Identity Codes
• Spanish IBANs
• Spanish Foreigner Identity Codes
• Spanish NIF Numbers
• Classification For Businesses In The EuropeanUnion
• European VAT Numbers
• Finnish ALV Numbers
• Finnish Personal Identity Codes
• Finnish Business Identifiers
• French Tax Identification Numbers
• French Personal Identification Numbers
• French Company Identification Numbers
• French TVA Numbers
• Stock Exchange Daily Official List Numbers
• English Unique Pupil Numbers
• United Kingdom Unique Taxpayer References
• United Kingdom VAT Numbers
• Greek Social Security Numbers
• Greek VAT Numbers
• Guatemala Tax Numbers
• Croatian Identification Numbers
• Hungarian ANUM Numbers
• Indonesian VAT Numbers
• Irish Personal Numbers
• Irish VAT Numbers
• Israeli Company Numbers
• Israeli Personal Numbers
• Indian Digital Resident Personal IdentityNumbers
• Indian Permanent Account Numbers
• Icelandic Identity Codes
• Icelandic VSK Numbers
• Italian Code For Identification Of Drugs
• Italian Fiscal Codes
• Italian IVA Numbers
• Japanese Corporate Numbers
• South Korea Business Registration Numbers
• South Korean Resident Registration Numbers
• Liechtenstein Tax Code For Individuals AndEntities
• Lithuanian Personal Numbers
• Lithuanian PVM Numbers
• Luxembourgian TVA Numbers
• Latvian PVN (VAT) Numbers
• Monacan TVA Numbers
• Moldavian Company Identification Numbers
• Montenegro IBANs
• Maltese VAT Numbers
• Mauritian National ID Numbers
• Mexican Personal Identifiers
• Mexican Tax Numbers
• Malaysian National Registration Identity CardNumbers
• BRIN Numbers
• Dutch BTW Numbers
• Norwegian IBANs
• Norwegian Bank Account Numbers
• Norwegian VAT Numbers
• Norwegian Organisation Numbers
• New Zealand IRD Numbers
• Peruvian Personal Numbers
• Peruvian Fiscal Numbers
• Polish VAT Numbers
• Polish National Identification Numbers
• Polish Register Of Economic Units
• Portuguese NIF Numbers
• Paraguay RUC Numbers
• Romanian CF (VAT) Numbers
• Romanian Numerical Personal Codes
• Romanian Company Identifiers
• Romanian Trade Register Identifiers
• French Company Establishment IdentificationNumbers
• United Kingdom National Health Service PatientIdentifiers
• Dutch Citizen Identification Numbers
• Dutch Student IdentificationNumbers
• Belgian IBANs
• Bulgarian Personal Numbers
• Brazilian Company Identifiers
• Brazilian National Identifiers
• Canadian Social Insurance Numbers
• Chinese Unified Social Credit Codes
• Estonian Organisation RegistrationCodes
• Spanish Real State IDs
• Euro Banknote Serial Numbers
• European Energy Identification Codes
• Finnish Association Registry IDs
• Finnish Individual Tax Numbers
• Dutch Postal Codes
• Norwegian Birth Numbers
• New Zealand Bank Account Numbers