problem in encoding .csv file content conversion to .json file

Question

I use this piece of code to convert a .csv file content to a .json file:

import csv
import json

with open('export.csv', encoding='utf-8') as f:
    reader = csv.DictReader(f)
    rows = list(reader)

with open('test.json', 'w', encoding='utf-8') as f:
    json.dump(rows, f)

The conversion is successful, but Arabic characters in .csv file convert to something like this in .json file:

"\u06a9\u0627"

How can I solve this?

GooDeeJAY · Accepted Answer · 2022-03-27 05:53:40Z

2

According to json.dump docstring:

If ensure_ascii is false, then the strings written to fp can contain non-ASCII characters if they appear in strings contained in obj. Otherwise, all such characters are escaped in JSON strings.

Solution:

json.dump(rows, f, ensure_ascii=False)

answered Mar 27, 2022 at 5:53

GooDeeJAY

1,8602 gold badges26 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

problem in encoding .csv file content conversion to .json file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related