Quiffen is a Python package for parsing QIF files and exporting the data in more useful formats, such as dictionaries or pandas DataFrames. It’s written in plain text, so it’s really easy to parse.It’s standardised - no more hard coding different CSV schema for different banks.
Despite its age, the QIF file format is useful because: Regardless of this, most banks and other financial institutions (stock brokers, etc.) will offer QIF as an option when exporting your data. However, the format is very old now (older than OFX, even). QIF, or Quicken Interchange Format, is a file format developed by Intuit initially for use in their QuickBooks product. Different banks use different header names for the amount, reference and so on, and hard coding every single bank is nigh on impossible. Most banks will allow you to export your bank statement as a CSV, but what a lot of them don’t tell you is how terribly structured these CSV files are. If you’ve ever tried to complete a data science project that revolves around personal finances, you’re probably familiar with the joys of bank-exported CSV files for transaction data.
0 kommentar(er)
