Skip to main content

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

  1. Clone the repository:

    git clone https://github.com/yourusername/monzy.git
    cd monzy
    
  2. Create and activate a virtual environment with Poetry:

    ./local-setup.sh
    
  3. 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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

monzy-0.1.7.dev0.tar.gz (8.2 kB view details)

Uploaded Source

Built Distribution

monzy-0.1.7.dev0-py3-none-any.whl (9.2 kB view details)

Uploaded Python 3

File details

Details for the file monzy-0.1.7.dev0.tar.gz.

File metadata

  • Download URL: monzy-0.1.7.dev0.tar.gz
  • Upload date:
  • Size: 8.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.8.3 CPython/3.11.3 Darwin/23.2.0

File hashes

Hashes for monzy-0.1.7.dev0.tar.gz
Algorithm Hash digest
SHA256 26b4d0eb24dea6aea490cc6430b4d9ae09f67f7fc1b7f5762f14d2e475d6e432
MD5 01008363abd29cc4cd5a484a798dd707
BLAKE2b-256 76e4af456410d88efa5e48c2b33a2b4d32d339c069a46ead71f08be6cbb9d0c0

See more details on using hashes here.

File details

Details for the file monzy-0.1.7.dev0-py3-none-any.whl.

File metadata

  • Download URL: monzy-0.1.7.dev0-py3-none-any.whl
  • Upload date:
  • Size: 9.2 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

Hashes for monzy-0.1.7.dev0-py3-none-any.whl
Algorithm Hash digest
SHA256 2280f99e76d324044dba930f80a1ec3251d6293d04ca9dc35f9cba5241f4f950
MD5 5cb231a212ce4aacc926a0ea71ba0d51
BLAKE2b-256 f3f78383d7387b680cee1abac2c65743f4ea44a2af474d0dab08039260b4b6af

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