---
id: "dataprep"
category: "etl"
url: "http://registry.apicrafter.io/tool/dataprep"
---

# DataPrep (`dataprep`)

DataPrep is an open-source Python library for data preparation from the SFU Database Group. Its clean module standardises and validates the values of a DataFrame column: national identifiers, tax and VAT numbers, company registration numbers, bank account numbers and product, publication and securities codes (most of them checked with python-stdnum), as well as email addresses, phone numbers, URLs, IP addresses, dates, coordinates, countries and addresses.

Website: <https://github.com/sfu-db/dataprep>

## Supported datatypes (169)

- `aadhaar`
- `ad_nrt`
- `address`
- `al_nipt`
- `ar_cbu`
- `ardni`
- `at_vat`
- `at_vnr`
- `auabn`
- `auacn`
- `autfn`
- `be_iban`
- `be_vat`
- `bg_egn`
- `bg_pnf`
- `bg_vat`
- `bic`
- `brcpf`
- `bsn`
- `by_unp`
- `cabn`
- `casin`
- `casrn`
- `ch_esr`
- `chahv`
- `chuid`
- `cif`
- `cl_rut`
- `cnpj`
- `co_nit`
- `country`
- `cr_cpf`
- `cr_cpj`
- `cr_cr`
- `cu_ni`
- `cuit`
- `curp`
- `currency`
- `cusip`
- `cy_vat`
- `cz_dic`
- `cz_rc`
- `date`
- `datetime`
- `de_stnr`
- `de_wkn`
- `deust`
- `dk_cvr`
- `dkcprnum`
- `do_cedula`
- `do_ncf`
- `do_rnc`
- `ean`
- `ec_ci`
- `ec_ruc`
- `ee_ik`
- `ee_kmkr`
- `ee_registrikood`
- `email`
- `es_ccc`
- `es_cups`
- `es_dni`
- `es_iban`
- `es_referenciacatastral`
- `esnie`
- `esnif`
- `eu_at_02`
- `eu_banknote`
- `eu_eic`
- `eu_nace`
- `fi_alv`
- `fi_associationid`
- `fi_hetu`
- `fi_veronumero`
- `fi_ytunnus`
- `figi`
- `fr_nif`
- `frnir`
- `frvat`
- `gb_upn`
- `gb_vat`
- `geopoint`
- `gr_amka`
- `gr_vat`
- `grid_release`
- `gt_nit`
- `handelsregisternr`
- `hr_oib`
- `hu_anum`
- `iban`
- `idcard`
- `idnpwp`
- `ie_pps`
- `ie_vat`
- `il_hp`
- `il_idnr`
- `imei`
- `imonumber`
- `imsi`
- `ipaddr`
- `ipv4`
- `ipv6`
- `is_kennitala`
- `is_vsk`
- `isan`
- `isbn10`
- `isbn13`
- `isil`
- `isin`
- `ismn`
- `issn`
- `it_aic`
- `it_codicefiscale`
- `it_iva`
- `jp_cn`
- `krbusinessreg`
- `krrrn`
- `lei`
- `li_peid`
- `lt_asmens`
- `lt_pvm`
- `lu_tva`
- `lv_pvn`
- `mc_tva`
- `md_idno`
- `me_iban`
- `meid`
- `mt_vat`
- `mu_nid`
- `my_nric`
- `nl_brin`
- `nl_onderwijsnummer`
- `nl_postcode`
- `nlbtw`
- `no_fodselsnummer`
- `no_iban`
- `no_kontonr`
- `no_mva`
- `no_orgnr`
- `nz_bankaccount`
- `nz_ird`
- `p2pkhaddr`
- `p2shaddr`
- `p2wpkhaddr`
- `p2wshaddr`
- `pan`
- `pe_cui`
- `pe_ruc`
- `phone`
- `plnip`
- `plpesel`
- `plregon`
- `pt_nif`
- `py_ruc`
- `rfc`
- `ro_cf`
- `ro_cnp`
- `ro_cui`
- `ro_onrc`
- `sedol`
- `sirencode`
- `siretcode`
- `steuerid`
- `swiftcode`
- `taxid`
- `uknhsnum`
- `ukutr`
- `url`
- `vatin`