ValueError: Expected object or value when reading json as pandas dataframe

Sample data:

{
   "_id": "OzE5vaa3p7",
   "categories": [
      {
         "__type": "Pointer",
         "className": "Category",
         "objectId": "nebCwWd2Fr"
      }
   ],
   "isActive": true,
   "imageUrl": "https://firebasestorage.googleapis.com/v0/b/shopgro-1376.appspot.com/o/Barcode%20Data%20Upload%28II%29%2FAnil_puttu_flour_500g.png?alt=media&token=9cf63197-0925-4360-a31a-4675f4f46ae2",
   "barcode": "8908001921015",
   "isFmcg": true,
   "itemName": "Anil puttu flour 500g",
   "mrp": 58,
   "_created_at": "2016-10-02T13:49:03.281Z",
   "_updated_at": "2017-02-22T08:48:09.548Z"
}

{
   "_id": "ENPCL8ph1p",
   "categories": [
      {
         "__type": "Pointer",
         "className": "Category",
         "objectId": "B4nZeUHmVK"
      }
   ],
   "isActive": true,
   "imageUrl": "https://firebasestorage.googleapis.com/v0/b/kirananearby-9eaa8.appspot.com/o/Barcode%20data%20upload%2FYippee_Magic_Masala_Noodles,_70_g.png?alt=media&token=d9e47bd7-f847-4d6f-9460-4be8dbcaae00",
   "barcode": "8901725181222",
   "isFmcg": true,
   "itemName": "Yippee Magic Masala Noodles, 70 G",
   "mrp": 12,
   "_created_at": "2016-10-02T13:49:03.284Z",
   "_updated_at": "2017-02-22T08:48:09.074Z"
}

I tried:

import pandas as pd
data= pd.read_json('Data.json')

getting error ValueError: Expected object or value

also

import json
with open('gdb.json') as datafile:
    data = json.load(datafile)
retail = pd.DataFrame(data)

error: json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 509)

with open('gdb.json') as datafile:
for line in datafile:
    data = json.loads(line)
retail = pd.DataFrame(data)

error: json.decoder.JSONDecodeError: Extra data: line 1 column 577 (char 576)

How to read this json into pandas

Related Posts:

  1. pandas read_json: “If using all scalar values, you must pass an index”
  2. JSON to pandas DataFrame
  3. Loading a file with more than one line of JSON into Pandas
  4. Renaming column names in Pandas
  5. Delete a column from a Pandas DataFrame
  6. How to deal with SettingWithCopyWarning in Pandas
  7. How to deal with SettingWithCopyWarning in Pandas
  8. How to iterate over rows in a DataFrame in Pandas
  9. Adding new column to existing DataFrame in Python pandas
  10. ImportError: No module named pandas
  11. How to change the order of DataFrame columns?
  12. Converting dictionary to JSON
  13. How to change the order of DataFrame columns?
  14. What does `ValueError: cannot reindex from a duplicate axis` mean?
  15. How can I use the apply() function for a single column?
  16. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  17. Convenient way to deal with ValueError: cannot reindex from a duplicate axis
  18. How to fix IndexError: invalid index to scalar variable
  19. Merging dataframes on index with pandas
  20. Create a Pandas Dataframe by appending one row at a time
  21. Convert Python dict into a dataframe
  22. re.sub erroring with “Expected string or bytes-like object”
  23. How do I select rows from a DataFrame based on column values?
  24. How do I select rows from a DataFrame based on column values?
  25. Pandas group-by and sum
  26. How do I get the row count of a Pandas DataFrame?
  27. Python pandas groupby aggregate on multiple columns, then pivot
  28. Convert pandas dataframe to NumPy array
  29. Error:cannot convert float NaN to integer in pandas
  30. Replacing column values in a pandas DataFrame
  31. How do I get the row count of a Pandas DataFrame?
  32. Python Pandas – Missing required dependencies [‘numpy’] 1
  33. Get list from pandas dataframe column or row?
  34. pandas DataFrame “no numeric data to plot” error
  35. ‘DataFrame’ object has no attribute ‘sort’
  36. TypeError: cannot unpack non-iterable int objec
  37. Pandas DataFrame column to list
  38. Rename Pandas DataFrame Index
  39. pandas: filter rows of DataFrame with operator chaining
  40. Convert DataFrame column type from string to datetime, dd/mm/yyyy format
  41. Pandas how to use pd.cut()
  42. How to Read .txt in Pandas
  43. Get a list from Pandas DataFrame column headers
  44. Convert a python dict to a string and back
  45. TypeError: Object of type ‘bytes’ is not JSON serializable
  46. How to check whether a pandas DataFrame is empty?
  47. Convert columns to string in Pandas
  48. Shuffle DataFrame rows
  49. How to POST JSON data with Python Requests?
  50. How to overcome “datetime.datetime not JSON serializable”?
  51. How to load a tsv file into a Pandas DataFrame?
  52. Displaying better error message than “No JSON object could be decoded”
  53. How to iterate over columns of pandas dataframe to run regression
  54. Converting between datetime and Pandas Timestamp objects
  55. Creating a Pandas DataFrame from a Numpy array: How do I specify the index column and column headers?
  56. Convert pandas data frame to series
  57. Get first row value of a given column
  58. Selecting/excluding sets of columns in pandas
  59. How to add title to seaborn boxplot
  60. How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
  61. Deleting DataFrame row in Pandas based on column value
  62. Map to List error: Series object not callable
  63. Pandas long to wide reshape, by two variables
  64. SettingWithCopyWarning even when using .loc[row_indexer,col_indexer] = value
  65. Pandas DataFrame: replace all values in a column, based on condition
  66. OSError: Initializing from file failed on csv in Pandas
  67. Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
  68. Pandas – How to flatten a hierarchical index in columns
  69. What is the difference between json.load() and json.loads() functions
  70. NumPy array is not JSON serializable
  71. AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas
  72. Plot correlation matrix using pandas
  73. How to get a value from a cell of a dataframe?
  74. Plotting multiple lines, in different colors, with pandas dataframe
  75. Groupby value counts on the dataframe pandas
  76. TypeError: cannot concatenate a non-NDFrame object
  77. Pandas – Drop function error (label not contained in axis)
  78. Pandas index column title or name
  79. ImportError: No module named ‘xlrd’
  80. Building multi-regression model throws error: `Pandas data cast to numpy dtype of object. Check input data with np.asarray(data).`
  81. Moving Average Pandas
  82. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  83. How to add pandas data to an existing csv file?
  84. Importing Pandas gives error AttributeError: module ‘pandas’ has no attribute ‘core’ in iPython Notebook
  85. JSON object must be str, bytes or bytearray, not dict
  86. matplotlib: plot multiple columns of pandas data frame on the bar chart
  87. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  88. TypeError: expected str, bytes or os.PathLike object, not _io.TextIOWrapper
  89. How to convert index of a pandas dataframe into a column
  90. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  91. pandas replace multiple values one column
  92. Convert floats to ints in Pandas?
  93. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  94. Loading and parsing a JSON file with multiple JSON objects
  95. Got continuous is not supported error in RandomForestRegressor
  96. Extract first and last row of a dataframe in pandas
  97. TypeError: the JSON object must be str, not ‘bytes’
  98. ValueError: Must pass DataFrame with boolean values only
  99. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  100. Extracting specific selected columns to new DataFrame as a copy

Leave a Comment