Writing pandas DataFrame to JSON in unicode

by

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

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=False argument.

Related Contents:

  1. Saving UTF-8 texts with json.dumps as UTF-8, not as a \u escape sequence
  2. UnicodeDecodeError when reading CSV file in Pandas with Python
  3. Split / Explode a column of dictionaries into separate columns with pandas
  4. How to get string objects instead of Unicode from JSON?
  5. JSON to pandas DataFrame
  6. Loading a file with more than one line of JSON into Pandas
  7. Efficient way to unnest (explode) multiple list columns in a pandas DataFrame
  8. Reading multiple JSON records into a Pandas dataframe
  9. How to flatten a pandas dataframe with some columns as json?
  10. UnicodeDecodeError when reading CSV file in Pandas
  11. Python: Read several json files from a folder
  12. Pandas read nested json
  13. pandas read_json: “If using all scalar values, you must pass an index”
  14. Convert numpy type to python
  15. How to extract multiple JSON objects from one file?
  16. pandas json_normalize with very nested json
  17. Convert Pandas Dataframe to nested JSON
  18. Nested Json to pandas DataFrame with specific format
  19. Pandas dataframe to json without index
  20. How to invert the x or y axis
  21. Convert Pandas column containing NaNs to dtype `int`
  22. Find element’s index in pandas Series
  23. Pandas DataFrame column to list [duplicate]
  24. String to Dictionary in Python [duplicate]
  25. Python, Unicode, and the Windows console
  26. How to select rows in a DataFrame between two values, in Python Pandas?
  27. Pandas groupby cumulative sum
  28. Give column name when read csv file pandas
  29. Get last “column” after .str.split() operation on column in pandas DataFrame
  30. How to send requests with JSON in unit tests
  31. Add multiple empty columns to pandas DataFrame
  32. sending NaN in json
  33. Pandas – Filtering None Values
  34. Pandas: Convert Timestamp to datetime.date
  35. AttributeError: ‘Series’ object has no attribute ‘reshape’
  36. How to fix ”UnicodeDecodeError: ‘charmap’ codec can’t decode byte 0x9d in position 29815: character maps to ”?
  37. Pandas – Strip white space
  38. pandas – find first occurrence
  39. How to open my files in data_folder with pandas using relative path?
  40. How to group DataFrame by a period of time?
  41. Upgrade version of Pandas
  42. python pandas replacing strings in dataframe with numbers
  43. List of objects to JSON with Python
  44. how to read json object in python [duplicate]
  45. Selecting columns from pandas MultiIndex
  46. pandas dataframe str.contains() AND operation
  47. Why does base64.b64encode() return a bytes object?
  48. Use None instead of np.nan for null values in pandas DataFrame
  49. Pandas Timedelta in months
  50. Get unique values from index column in MultiIndex

Leave a Comment