Tools

Alteryx Woodwork

ID woodwork

detector

Woodwork is an open source Python library from Alteryx that adds typing metadata to pandas DataFrames: a logical type and semantic tags for each column. It infers some logical types from the values, including EmailAddress, URL, PhoneNumber, PostalCode, IPAddress, Datetime and Boolean, and validates email, URL and phone values with configurable regular expressions; other types, such as Address, CountryCode or LatLong, are set by the user. Version 0.31.0 defines 26 logical types in woodwork/logical_types.py, and woodwork.list_logical_types() lists them.

Website
https://woodwork.alteryx.com/en/stable/guides/logical_types_and_semantic_tags.html
Supported types
15

Supported semantic types

IDNameCategoriesCountriesDescription
address Address (physical location) PII common, pii, geo global Geographic address, commonly consist of postindex, country, area, town, street and building
age Age PII draft datetime global Age of the person or organization in years
boolean Boolean common global In computer science, the Boolean data type is a data type that has one of two possible values (usually denoted true and false) which is...
countrycode_alpha2 ISO 3166-1 Alpha2 country code pattern geo global ISO 3166-1 alpha-2 codes are two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the...
datetime Date and time datetime global Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an...
duration Time duration datetime global The amount of time elapsed between two events
email Email address PII common, internet, pii global Address of an electronic mailbox in the form local-part@domain, defined in section 3.4.1 of RFC 5322. The local part names the mailbox,...
geopoint Geopoint draft geo global Basic geopoint as coordinates
ipaddr IP address (IPv4 or IPv6) PII internet, pii global Address of a network interface in the Internet Protocol: a 32-bit IPv4 address in dotted-decimal form (192.0.2.1) or a 128-bit IPv6...
iso3166code identifier for a country subdivision per ISO 3166-2 geo global identifier for a country subdivision per ISO 3166-2 (include country code)
iso4217curcode ISO 4217 Currency code pattern draft finances global ISO 4217 Currency code
person_fullname Person fullname PII draft persons, pii global Full name of the person as combination of last, first, and sometimes middle name
phone Phone number PII pii, common, telecom global Telephone number in standard format (RFC3966), without 'tel:' prefix
postindex Postal code/index PII geo, pii, common global Postal index/code, unique post identifier used in address
url Uniform Resource Locator (URL) common, internet global Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query...

Use this record