# Фиксим CSV-файл

broken_csv = open("broken.csv", "r")
csv = broken_csv.read()
broken_csv.close()

csv = csv.replace(",", ".")
csv = csv.replace("|", ",")
csv = csv.replace(";REF#", "")
csv = csv.replace("</span", "")
csv = csv.replace("&amp;", "")
csv = csv.replace("id,name,a,b\n", "")
csv = csv.replace("#", ".")

# убираем точки в начале строк
csv_lines = csv.split("\n")
for i in range(len(csv_lines)):
    csv_lines[i] = csv_lines[i] + "\n"
    if csv_lines[i][0] == ".":
        csv_lines[i] = csv_lines[i][1:]

correct_csv = open("correct.csv", "w")
correct_csv.writelines(csv_lines)
correct_csv.close()