Skip to main content

Simplified table-type data normalization

Project description

Simplified table data normalization.


PyPi Status Repository Tag Supported Versions Release Status License Documentation Status Build Status Code Coverage Requirements Status Say Thanks

Basic Usage

Learn more by reading the documentation!

from sandpaper import SandPaper

paper = SandPaper('my-sandpaper').strip(  # strip whitespace from column comment
    column_filter=r'comment'
).translate_text(                         # get group id from column group
    column_filter=r'group',
    from_regex=r'^group_(\d+)$',
    to_format='{0}'
).translate_date(                         # normalize date from column date
    column_filter=r'date',
    from_formats=['%Y-%m-%d', '%m-%d'],
    to_format='%c'
)

for result in paper.apply('~/random_data.{1..3}.{csv,xls{,x}}'):
    # apply sandpaper rules to all files matching the brace expanded glob given
    print(result)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sandpaper-0.0.4.tar.gz (15.0 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page