ValueError when using pandas.read_json

by

I had the same error message, and I solved it by using an absolute path.

import os
basePath = os.path.dirname(os.path.abspath(__file__))
df = pandas.read_json(basePath + '/ut1.json', orient="records", dtype={"A":str, "B":list})

That worked for me!

More Related Contents:

  1. Tuples conversion into JSON with python [closed]
  2. Split / Explode a column of dictionaries into separate columns with pandas
  3. Efficient way to unnest (explode) multiple list columns in a pandas DataFrame
  4. How to extract multiple JSON objects from one file?
  5. JSON to pandas DataFrame
  6. Convert Pandas Dataframe to nested JSON
  7. Pandas read nested json
  8. How to flatten a nested JSON recursively, with flatten_json
  9. Python – How to convert JSON File to Dataframe
  10. How to flatten a pandas dataframe with some columns as json?
  11. How to normalize json correctly by Python Pandas
  12. How to flatten multilevel/nested JSON?
  13. pandas groupby to nested json
  14. flattening nested Json in pandas data frame
  15. How to json_normalize a column with NaNs
  16. Python: Read several json files from a folder
  17. pandas read_json: “If using all scalar values, you must pass an index”
  18. Convert numpy type to python
  19. pandas.io.json.json_normalize with very nested json
  20. FastAPI is very slow in returning a large amount of JSON data
  21. Reading multiple JSON records into a Pandas dataframe
  22. Create a Pandas DataFrame from deeply nested JSON
  23. Add Leading Zeros to Strings in Pandas Dataframe
  24. Progress indicator during pandas operations
  25. pandas applying regex to replace values
  26. Redefining the Index in a Pandas DataFrame object
  27. pandas .plot() x-axis tick frequency — how can I show more ticks?
  28. module ‘pandas’ has no attribute ‘rolling_mean’
  29. Group dataframe and get sum AND count?
  30. Python pandas – new column’s value if the item is in the list

Leave a Comment