Skip to main content

Parse BBVA monthly reports directly to a Dataframe

Project description

BBVA reports extractor

Checked with mypy Made with Python

Library + script to extract your bank account movements from the pdf reports that BBVA provides each month. Export it to csv or sqlite.

A Grafana dashboard is provided to visualize this data.

Dependencies

The following libpoppler dependencies are needed for pdftotext:

sudo apt install build-essential libpoppler-cpp-dev pkg-config python3-dev

Downloading the reports

In bbva.es, login and go to Posición global > Cuentas y Tarjetas > Ficha. Then click Operaciones > Extracto mensual cuentas. Ready to go!

Using the libray

Just provide the filepath:

import bbva2pandas
dataframe = bbva2pandas.Report('myfile').to_df()

Running the script

The provided script loads all the PDFs in the provided directory and generates a CSV/sqlite file

usage: bbva2pandas [-h] [--output_filename OUTPUT_FILENAME] directory {csv,sqlite}
bbva2pandas: error: the following arguments are required: directory, output_format

Testing

Run

python3 -m unittest discover tests

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

bbva2pandas-1.1.0.tar.gz (17.0 kB view details)

Uploaded Source

Built Distribution

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

bbva2pandas-1.1.0-py3-none-any.whl (17.7 kB view details)

Uploaded Python 3

File details

Details for the file bbva2pandas-1.1.0.tar.gz.

File metadata

  • Download URL: bbva2pandas-1.1.0.tar.gz
  • Upload date:
  • Size: 17.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.1 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.10

File hashes

Hashes for bbva2pandas-1.1.0.tar.gz
Algorithm Hash digest
SHA256 c4e069a18dde823c164106e80b258d1475eec968db2024c9d9fcf71f28487f3c
MD5 cd8b122b6e9788b226a5f975fe361edf
BLAKE2b-256 a99fe019e5eaa793cf9b542c35f20e6da0078ee827e09a3778c4e87b37d8c4da

See more details on using hashes here.

File details

Details for the file bbva2pandas-1.1.0-py3-none-any.whl.

File metadata

  • Download URL: bbva2pandas-1.1.0-py3-none-any.whl
  • Upload date:
  • Size: 17.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.1 pkginfo/1.8.2 requests/2.27.1 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.10

File hashes

Hashes for bbva2pandas-1.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 42053a5717c18eac67958d778ea2070b6c8a06181162183fec578dbfbb5102aa
MD5 63f06c5cbc39919c367f89b57efc9239
BLAKE2b-256 84e21f6cce86bdde69317863ce391f81f2874d9076ca463434e0fca1d3680f70

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