Skip to main content

Collect and clean data using Excel spreadsheets.

Project description

![Tests](https://github.com/hammerheadlemon/datamaps/workflows/Tests/badge.svg)

## Introduction

datamaps is a command line tool, written in Python, which facilitates the collection of data using Excel as the ‘form’. It accepts that Excel files are freely distributable, easy to understand and already well integrated in the non-technical office environment.

The tool uses a concept a datamap, which is simple, user-created CSV file which maps cell references within Excel ‘templates’. The datamap concept makes it easy to design pretty Excel spreadsheets with blank cells (the ‘template’) intended for the user to complete - the cell references in the datamap inform the datamaps program where it should expect to find user-entered data. At this point, the output is another master spreadsheet which contains all the data from each completed template compiled into a single table. This is then used by other tools for further analysis.

The documentation found at [Datamaps - Twenty Four Software](https://datamaps.twentyfoursoftware.com) gives a more detailed explanation.

## Installation

pip install datamaps

## Bugs and issues

Please report bugs as [Github issues](https://github.com/yulqen/datamaps/issues).

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

datamaps-1.1.9.tar.gz (20.3 kB view details)

Uploaded Source

Built Distribution

datamaps-1.1.9-py3-none-any.whl (23.9 kB view details)

Uploaded Python 3

File details

Details for the file datamaps-1.1.9.tar.gz.

File metadata

  • Download URL: datamaps-1.1.9.tar.gz
  • Upload date:
  • Size: 20.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/4.11.4 pkginfo/1.8.3 requests/2.28.0 requests-toolbelt/0.9.1 tqdm/4.64.0 CPython/3.9.13

File hashes

Hashes for datamaps-1.1.9.tar.gz
Algorithm Hash digest
SHA256 413e81fcdc83b36deff75d2b1d898260f0e2ccc12be7ec8d3f1e5c03ca07e743
MD5 76d7fd09f738fed0ebdff7813cd4bf68
BLAKE2b-256 5e1fc0a950d023f281d56eb97bb26d704b2069c3a8c386e49e1061b9b6dcd04e

See more details on using hashes here.

File details

Details for the file datamaps-1.1.9-py3-none-any.whl.

File metadata

  • Download URL: datamaps-1.1.9-py3-none-any.whl
  • Upload date:
  • Size: 23.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/4.11.4 pkginfo/1.8.3 requests/2.28.0 requests-toolbelt/0.9.1 tqdm/4.64.0 CPython/3.9.13

File hashes

Hashes for datamaps-1.1.9-py3-none-any.whl
Algorithm Hash digest
SHA256 94fc9d42ed94fb55b1541f9f4af0f91fb73d126d7fa979e722af57eafcf6701c
MD5 339a5570069f9f269bdf740386451246
BLAKE2b-256 04f9125ff96b360d8b8cb45fa5736c941f4721784c1757ffabfb03afa949b103

See more details on using hashes here.

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