summaryrefslogtreecommitdiff
path: root/bofa.py
blob: 3a84427b36e97b576a5b722e7cdfc4b4f8500b94 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#!/usr/bin/env python3

from pyexcel_ods3 import get_data

from settings import EXPENSES_FILENAME


class BofaData():
    def get(self) -> None:
        with open(EXPENSES_FILENAME, "rb") as expenses:
            data = get_data(expenses)
            main_page = data.get("Main")

            headlines = main_page[0]
            amounts = main_page[1]

            formatted_data = {}

            for i in range(len(headlines)):
                formatted_data[headlines[i]] = amounts[i]

        return formatted_data