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
|
#!/usr/bin/env python
import json
import pandas
URL = (
"https://www.finanssiala.fi/"
"wp-content/uploads/2021/03/Finnish_monetary_institution_codes_and_BICs_in_excel_format.xlsx"
)
def process():
datas = pandas.read_excel(URL, sheet_name=0, dtype=str, header=None)
datas.fillna("", inplace=True)
return [
{
"country_code": "FI",
"primary": True,
"bic": str(bic).upper().strip(),
"bank_code": bank_code,
"name": name,
"short_name": name,
}
for bank_code, bic, name in list(datas.itertuples(index=False))[2:]
if bank_code != ""
]
if __name__ == "__main__":
with open("schwifty/bank_registry/generated_fi.json", "w") as fp:
json.dump(process(), fp, indent=2)
|
