Package to interact with Monzo API to fetch transactions and upload to a database
Project description
Monzy
A Python data pipeline to fetch, transform, and process Monzo transactions and pot data from the Monzo API.
Table of Contents
Introduction
This project provides a data pipeline to interact with the Monzo API, retrieve transaction and pot data, transform it into a structured format, and process it for analysis or storage in a PostgreSQL database. It uses the monzo-API Python package developed by Peter MacDonald: https://github.com/petermcd/monzo-api
Features
- Fetch Monzo transactions and pot data
- Transform and normalize transaction data
- Process transactions to prepare for analysis
- Insert and query data in a PostgreSQL database
- Environment configuration using
.env
files
Setup
Prerequisites
- Python 3.8+
- PostgreSQL database
Installation
-
Clone the repository:
git clone https://github.com/yourusername/monzy.git cd monzy
-
Create and activate a virtual environment with Poetry:
./local-setup.sh
-
Set up environment variables:
Create a
.env
file in the root directory of the project and add your environment variables:DB_USERNAME=your_username DB_PASSWORD=your_password DB_HOST=your_host DB_NAME=your_database DB_PORT=your_port
Usage
Monzo API Token
...
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
Built Distribution
File details
Details for the file monzy-0.1.5.dev0.tar.gz
.
File metadata
- Download URL: monzy-0.1.5.dev0.tar.gz
- Upload date:
- Size: 8.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.3 CPython/3.11.3 Darwin/23.2.0
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | e6221901d769c92ddfd63024a356c07884fd49fc6ad6e420143ae091722e9f78 |
|
MD5 | d648d36435ae9cc63d00d20ee1316c08 |
|
BLAKE2b-256 | 8e07d9002fbdd398bb186f2797324b45d268f009760af694468281e5ab39134a |
File details
Details for the file monzy-0.1.5.dev0-py3-none-any.whl
.
File metadata
- Download URL: monzy-0.1.5.dev0-py3-none-any.whl
- Upload date:
- Size: 9.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.3 CPython/3.11.3 Darwin/23.2.0
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 00187d70e42ff992226967927312d3e8d5ec0ae594421409a5bfc5f452baabb9 |
|
MD5 | 5e685bcba75975b4cf7df18102f509b1 |
|
BLAKE2b-256 | 587ef0bd8e6e1715597038f5667afb24c34d43cdef6959f102c71473a8dba0b2 |