User Guide

The User Guide introduces the components of the DataPrep library.

• Datasets
• EDA
  • plot(): analyze distributions
  • plot_correlation(): analyze correlations
  • plot_missing(): analyze missing values
  • plot_diff(): analyze difference betweenDataFrames
  • create_report(): create a profile report
  • How-to guide: customize your output
  • Insight: automatically insight detection
  • Case study: Titanic
  • Case study: House Prices
• Connector
  • Case study: dblp API
  • Configuration files: usage and composition
  • connect(): establish the connection and load the configurationfiles
  • query(): fetch data into DataFrames via APIs
  • info(): get information of a website
  • Authorization schemes supported
  • Auto-pagination
  • read_sql(): fetch data into DataFrames via SQL query
• Clean
  • 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