The hiereskopia package is a library to infer properties like date formats or numeric separators in pandas series of type object or string.
Project description
Hieroskopia
The hiereskopia package is a library to infer properties like date formats or numeric separators in pandas series of type object or string.
Support
Date-times:
- Support to dates and datetime format
- This library receive a series as input and try to return a dictionary with the format found in the series Based on the 1989 C (Default) , Snowflake Standard or Java Simple date time format code.
Numeric:
- This library receive a series as input and try to return a dictionary with the three digit and decimal character separator
Usage
Infer datetime or date
>>> from hieroskopia import InferDatetime
>>> InferDatetime.infer(pd.Series(["2019-11-27",
"2019/11/28",
"2018-11-08"]))
>>> {'formats': ['%Y-%m-%d', '%Y/%m/%d'], 'type':'date'}
Using return_format
parameter
>>> from hieroskopia import InferDatetime
>>> InferDatetime.infer(pd.Series(["2019-11-27",
"2019/11/28",
"2018-11-08"]), return_format='snowflake')
>>> {'formats': ['yyyy-mm-dd', 'yyyy/mm/dd'], 'type':'date'}
>>> from hieroskopia import InferDatetime
>>> InferDatetime.infer(pd.Series(["2019-11-27",
"2019/11/28",
"2018-11-08"]), return_format='java')
>>> {'formats': ['yyyy-MM-dd', 'yyyy/MM/dd'], 'type':'date'}
The above method works with a best guess approach to detect a format in a object type series and try
to return a datetime.strftime
/strptime
, Snowflake Date format
, Java Simple Date Format
format that will cover or parse the majority
of the samples.
Infer numeric
>>> from hieroskopia import InferNumeric
>>> InferNumeric.infer(pd.Series(['767313628196.2', '76731362819.546', '767313628196']))
>>> {'three_digit_separator': '', 'decimal_separator': '.', 'type':'float'}
The above method will try to detect and return certain properties in a object type series
like datatype
, three_digit_separator
or decimal_separator
character that will cover
the majority of the samples.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for hieroskopia-0.1.30-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2b5564a337e245a4b51b2e875313fdb0a4d0e9d36f48de57f5dd5551cd803f16 |
|
MD5 | 959cd26a15cdd1d2ddd53de80d172e5d |
|
BLAKE2b-256 | e162d7863967918d20ea49dd37449f28628dab6e7175df604a63d4e5121d4522 |