Parse BBVA monthly reports directly to a Dataframe
Project description
BBVA reports extractor
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
You can either provide the file to be read or the raw string:
from bbva2pandas.file_handler import read_report
with open(filename, 'rb') as f:
dataframe = read_report(f)
from bbva2pandas.report_parser import parse_report_content
dataframe = report_parser.parse_report_content('filecontent')
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-0.1.0.tar.gz
(16.5 kB
view hashes)
Built Distribution
Close
Hashes for bbva2pandas-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5af917b9b6acd87549543b40c808b8ae20b72644c2d6924b3556cd89c15d9f7a |
|
MD5 | 638307b1c8637c30853058b52896f347 |
|
BLAKE2b-256 | ef52a0bd3abf433b371294d9e33f46bf22a53903df343409b469f3375633e464 |