Skip to main content

Frictionless is a framework to describe, extract, validate, and transform tabular data

Project description

Frictionless Framework

Build Coverage Registry Codebase Support

Frictionless@4 is now live! Please read the Migration Guide

Frictionless is a framework to describe, extract, validate, and transform tabular data (DEVT Framework). It supports a great deal of data schemes and formats, as well as provides popular platforms integrations. The framework is powered by the lightweight yet comprehensive Frictionless Data Specifications.

Purpose

  • Describe your data: You can infer, edit and save metadata of your data tables. It's a first step for ensuring data quality and usability. Frictionless metadata includes general information about your data like textual description, as well as, field types and other tabular data details.
  • Extract your data: You can read your data using a unified tabular interface. Data quality and consistency are guaranteed by a schema. Frictionless supports various file schemes like HTTP, FTP, and S3 and data formats like CSV, XLS, JSON, SQL, and others.
  • Validate your data: You can validate data tables, resources, and datasets. Frictionless generates a unified validation report, as well as supports a lot of options to customize the validation process.
  • Transform your data: You can clean, reshape, and transfer your data tables and datasets. Frictionless provides a pipeline capability and a lower-level interface to work with the data.

Features

  • Open Source (MIT)
  • Powerful Python framework
  • Convenient command-line interface
  • Low memory consumption for data of any size
  • Reasonable performance on big data
  • Support for compressed files
  • Custom checks and formats
  • Fully pluggable architecture
  • The included API server
  • More than 1000+ tests

Example

$ frictionless validate data/invalid.csv
[invalid] data/invalid.csv

  row    field  code              message
-----  -------  ----------------  --------------------------------------------
             3  blank-header      Header in field at position "3" is blank
             4  duplicate-header  Header "name" in field "4" is duplicated
    2        3  missing-cell      Row "2" has a missing cell in field "field3"
    2        4  missing-cell      Row "2" has a missing cell in field "name2"
    3        3  missing-cell      Row "3" has a missing cell in field "field3"
    3        4  missing-cell      Row "3" has a missing cell in field "name2"
    4           blank-row         Row "4" is completely blank
    5        5  extra-cell        Row "5" has an extra value in field  "5"

Documentation

Please visit our documentation portal:

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

frictionless-4.0.11.tar.gz (153.0 kB view details)

Uploaded Source

Built Distribution

frictionless-4.0.11-py2.py3-none-any.whl (216.7 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file frictionless-4.0.11.tar.gz.

File metadata

  • Download URL: frictionless-4.0.11.tar.gz
  • Upload date:
  • Size: 153.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/53.0.0 requests-toolbelt/0.9.1 tqdm/4.58.0 CPython/3.9.2

File hashes

Hashes for frictionless-4.0.11.tar.gz
Algorithm Hash digest
SHA256 c6d753cbf4b565a4adf2e44915af9f409c5717d18086733cfdeea3ab68ddb649
MD5 33eeeb712467f5c850ac79df7dafb21e
BLAKE2b-256 8dd6b989ee53392f7c4796fbc9242c25fbdf798d9e3e08a3917366214b475b3b

See more details on using hashes here.

Provenance

File details

Details for the file frictionless-4.0.11-py2.py3-none-any.whl.

File metadata

  • Download URL: frictionless-4.0.11-py2.py3-none-any.whl
  • Upload date:
  • Size: 216.7 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/53.0.0 requests-toolbelt/0.9.1 tqdm/4.58.0 CPython/3.9.2

File hashes

Hashes for frictionless-4.0.11-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 c60d6d7265d3542b2d2905ac8c1d2a86c3383e69a4e1b663e6f7ea68c4b70084
MD5 f7ef9c5fae6f736eee3f479af7ea81fa
BLAKE2b-256 6315a2b55b34a08efd641195758fc0ea707e2299671aa701512897588ed2a2e9

See more details on using hashes here.

Provenance

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