用 unicode 将 Pandas DataFrame 写入 JSON

Writing pandas DataFrame to JSON in unicode

提问by Swier

I'm trying to write a pandas DataFrame containing unicode to json, but the built in .to_jsonfunction escapes the characters. How do I fix this?

我正在尝试将包含 unicode 的 Pandas DataFrame 编写为 json，但内置.to_json函数会转义字符。我该如何解决？

Example:

例子：

import pandas as pd
df = pd.DataFrame([['τ', 'a', 1], ['π', 'b', 2]])
df.to_json('df.json')

This gives:

这给出：

{"0":{"0":"\u03c4","1":"\u03c0"},"1":{"0":"a","1":"b"},"2":{"0":1,"1":2}}

Which differs from the desired result:

这与所需的结果不同：

{"0":{"0":"τ","1":"π"},"1":{"0":"a","1":"b"},"2":{"0":1,"1":2}}

---

---

我试过添加force_ascii=Falseforce_ascii=False论点：

import pandas as pd
df = pd.DataFrame([['τ', 'a', 1], ['π', 'b', 2]])
df.to_json('df.json', force_ascii=False)

But this gives the following error:

但这会产生以下错误：

UnicodeEncodeError: 'charmap' codec can't encode character '\u03c4' in position 11: character maps to <undefined>

---

---

我正在使用 WinPython 3.4.4.2 64 位和 Pandas 0.18.0

回答by Swier

Opening a file with the encoding set to utf-8, and then passing that file to the .to_jsonfunction fixes the problem:

打开一个编码设置为 utf-8 的文件，然后将该文件传递给.to_json函数可以解决问题：

with open('df.json', 'w', encoding='utf-8') as file:
    df.to_json(file, force_ascii=False)

gives the correct:

给出正确的：

{"0":{"0":"τ","1":"π"},"1":{"0":"a","1":"b"},"2":{"0":1,"1":2}}

Note: it does still require the force_ascii=Falseargument.

注意：它仍然需要force_ascii=False参数。