How to write Cyrillic to CSV in Python?

Question

Python

Hello everyone, I've encountered writing Cyrillic in a CSV file. there is this code:

# -*- coding: utf-8 -*-
....
    with open(filename, 'w+', encoding='utf8', newline='') as file:
        writer = csv.writer(file, delimiter=';')
        count_elements = len(data['urls'])
        for i in range(1, count_elements):
            writer.writerow([
                data['titles'][i],
                data['titles'][i],
                int(data['costs'][i]),
                data['address'][i],
                data['urls'][i],
            ])

As a result, I get a krakozyabra in the file:

How to write the Cyrillic alphabet correctly?

Answer 1

data['urls'][i].encode("cp1251")

Answer 2

Use unicodecsv

Answer 3

with open(filename, 'w+', encoding='utf8', newline='')
replace
with with open(filename, 'w+', newline='')
or
with open(filename, 'w+', encoding='cp1251 ',newline='')

Answer 4

Take note of the encoding you are using:
encoding='utf8'
Take note of this question . There is an answer there.