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.1b914.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.1b914-py3-none-any.whl (1.2 MB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: geo_importer-0.0.1b914.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.1b914.tar.gz
Algorithm Hash digest
SHA256 245b535350b2ba6197bdea10083565fc6d19d5445773cebf9732250bbdaf9e3e
MD5 acc60c980c8494f1c023abcc5feb792f
BLAKE2b-256 281d9d172c4e94d2c09d5549934631af7eb7487e1974928707cf184291b71d3b

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for geo_importer-0.0.1b914-py3-none-any.whl
Algorithm Hash digest
SHA256 247fbce1f1839a33043c5b3665196f2fcbeea287a2a669dbe50b97bee8ce9ccb
MD5 71fa0297515e6f9f8a871070ea67804c
BLAKE2b-256 198160c20fb1d4b4dee847471640f1fa771f69f175b566e77f446758bac93299

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