Skip to main content

Qt application to transform raw tables into clean geographic data.

Project description

App Icon

Geo-Importer

Geo-Importer is a simple desktop app built with PySide6. You can upload your statistics in Excel, CSV, or PDF formats, extract and clean the tables, and then match your data to geographic regions (NUTS levels 0–3, LAU, LOR). Finally, you can export the matched data as CSV or GeoJSON.


Installation

Install from PyPI:

pip install geo-importer

Quick Start

Launch the application:

geo-importer

Or from Python:

import geo_importer
geo_importer.main()

Then:

  1. Upload your Excel, CSV or PDF file
  2. Select table region (PDF) or worksheet (Excel)
  3. Clean and prepare columns in the DataPrep view
  4. Filter which statistics to include
  5. Load and filter geodata (choose type, version, level)
  6. Automatically map statistics to regions (exact, prefix, fuzzy, regex)
  7. Manually adjust any unmatched records
  8. Preview on an interactive Folium map
  9. Export your matched data as CSV or GeoJSON

Features

  • Multi-format support: Excel (.xls/.xlsx), CSV, PDF
  • Interactive table cleaning with transpose, undo/redo, cut/copy/paste
  • Flexible automatic matching: exact, prefix, fuzzy (RapidFuzz), regex
  • Built-in geodata: NUTS (0–3), LAU, LOR — select version and level
  • Live preview on a Folium map (gradient or categorical coloring)
  • One-click export to CSV or GeoJSON

Documentation

Full documentation is available at: https://frievoe97.github.io/geo-importer/latest/


License

Distributed under the MIT License. See the LICENSE file for details.

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

geo_importer-0.0.1b913.tar.gz (1.1 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

geo_importer-0.0.1b913-py3-none-any.whl (1.2 MB view details)

Uploaded Python 3

File details

Details for the file geo_importer-0.0.1b913.tar.gz.

File metadata

  • Download URL: geo_importer-0.0.1b913.tar.gz
  • Upload date:
  • Size: 1.1 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for geo_importer-0.0.1b913.tar.gz
Algorithm Hash digest
SHA256 0dcf210a86f9e347078d9da06bb673c8b7e1a8311f44e0b1801701f8d2a0d52b
MD5 407e28a0b02f64c756e336cf41b49a06
BLAKE2b-256 f5bb65e015da74a207fae31bbea02552312581a0301af9a548e5a5e6e4a43c98

See more details on using hashes here.

File details

Details for the file geo_importer-0.0.1b913-py3-none-any.whl.

File metadata

File hashes

Hashes for geo_importer-0.0.1b913-py3-none-any.whl
Algorithm Hash digest
SHA256 68c6a5e6f310cf2d0cdf42f0075173f4724589b6be491bd1283a4b604de92683
MD5 10c8fff3a5d364683fc4817b5b91b62c
BLAKE2b-256 f737d1d851b5839a5944e7d35db69450a121e7b8e4b3fc82890df91dd70e028b

See more details on using hashes here.

Supported by

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