1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
#!/usr/bin/env python
import json
import camelot
import pandas
# https://www.bankinfrastruktur.se/framtidens-betalningsinfrastruktur/iban-och-svenskt-nationellt-kontonummer
URL = (
"https://www.bankinfrastruktur.se/media/s0of3yyj/"
"iban-id-och-bic-adress-for-banker-2023-09-07.pdf"
)
def process():
registry = {}
tables = camelot.read_pdf(URL, pages="1,2")
datas = pandas.concat([tables[0].df, tables[1].df], ignore_index=True)
datas.drop(index=datas.index[0], inplace=True)
datas.drop(index=datas.index[0], inplace=True)
datas.fillna("", inplace=True)
datas.sort_values(1, inplace=True)
for row in datas.itertuples(index=False):
bank_code, bic, name = row[1:4]
registry[str(bank_code).strip()] = {
"country_code": "SE",
"primary": True,
"bic": str(bic).upper(),
"bank_code": str(bank_code).strip(),
"name": str(name).strip(),
"short_name": str(name).strip(),
}
print(f"Fetched {len(registry)} bank records")
return list(registry.values())
if __name__ == "__main__":
with open("schwifty/bank_registry/generated_se.json", "w") as fp:
json.dump(process(), fp, indent=2)
|
