<commit_before>#!/usr/bin/env python
import json
import xlrd
import requests

URL = ("https://www.nbb.be/doc/be/be/protocol/r_fulllist_of_codes_current.xlsx")

r = requests.get(URL)
book = xlrd.open_workbook(file_contents=r.content)
registry = []
skip_field = ["VRIJ", "NAV", "NAP", "-", "VRIJ - LIBRE"]
row_count = 0

if len(book.sheets()) == 1:
    sheet = book.sheets()[0]
for i in range(sheet.nrows):
    if row_count > 1:
        row_count += 1
        row = sheet.row_values(i)
        column = 0
        registry_entry_template = {"bank_code": None, "bic": None,
                                   "country_code": "BE", "name": None, "primary": True, "short_name": None}<commit_msg>cleaned too long line<commit_after>#!/usr/bin/env python
import json
import xlrd
import requests

URL = ("https://www.nbb.be/doc/be/be/protocol/r_fulllist_of_codes_current.xlsx")

r = requests.get(URL)
book = xlrd.open_workbook(file_contents=r.content)
registry = []
skip_field = ["VRIJ", "NAV", "NAP", "-", "VRIJ - LIBRE"]
row_count = 0

if len(book.sheets()) == 1:
    sheet = book.sheets()[0]
for i in range(sheet.nrows):
    if row_count > 1:
        row_count += 1
        row = sheet.row_values(i)
        column = 0
        registry_entry_template = {"bank_code": None, "bic": None,
                                   "country_code": "BE", "name": None, "primary": True,
                                   "short_name": None}
{'fraction_non_alphanumeric': 0.15763546798029557, 'fraction_numerical': 0.00844475721323012, 'mean_word_length': 2.7718832891246685, 'pattern_counts': {'":': 12, '<': 3, '<?xml version=': 0, '>': 5, 'https://': 2, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 3, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5808426', 'n_tokens_mistral': 525, 'n_tokens_neox': 502, 'n_words': 110}