JSON to pandas DataFrame

I found a quick and easy solution to what I wanted using json_normalize() included in pandas 1.01.

from urllib2 import Request, urlopen
import json

import pandas as pd    

path1 = '42.974049,-81.205203|42.974298,-81.195755'
request=Request('http://maps.googleapis.com/maps/api/elevation/json?locations='+path1+'&sensor=false')
response = urlopen(request)
elevations = response.read()
data = json.loads(elevations)
df = pd.json_normalize(data['results'])

This gives a nice flattened dataframe with the json data that I got from the Google Maps API.

Related Posts:

  1. pandas read_json: “If using all scalar values, you must pass an index”
  2. Type error: cannot convert the series to
  3. Loading a file with more than one line of JSON into Pandas
  4. ValueError: Expected object or value when reading json as pandas dataframe
  5. Renaming column names in Pandas
  6. Delete a column from a Pandas DataFrame
  7. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  8. Writing a pandas DataFrame to CSV file
  9. Adding new column to existing DataFrame in Python pandas
  10. Modifing data while using iterrows() does not work
  11. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  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. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  16. ValueError: Unknown label type: ‘continuous’
  17. How to fix IndexError: invalid index to scalar variable
  18. Create a Pandas Dataframe by appending one row at a time
  19. json.dumps vs flask.jsonify
  20. How do I select rows from a DataFrame based on column values?
  21. How do I get the row count of a Pandas DataFrame?
  22. Python Pandas Counting the Occurrences of a Specific value
  23. Convert pandas dataframe to NumPy array
  24. Count unique values per groups with Pandas
  25. Convert pandas Series to DataFrame
  26. Error:cannot convert float NaN to integer in pandas
  27. Replacing column values in a pandas DataFrame
  28. TypeError: unhashable type: ‘dict’, when dict used as a key for another dict
  29. How do I get the row count of a Pandas DataFrame?
  30. Pandas “Can only compare identically-labeled DataFrame objects” error
  31. Pandas: ValueError: cannot convert float NaN to integer
  32. Get list from pandas dataframe column or row?
  33. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  34. ‘DataFrame’ object has no attribute ‘sort’
  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. Convert DataFrame column type from string to datetime, dd/mm/yyyy format
  40. How to customize a scatter matrix to see all titles?
  41. Get a list from Pandas DataFrame column headers
  42. What is dtype(‘O’), in pandas?
  43. Convert a python dict to a string and back
  44. TypeError: Object of type ‘bytes’ is not JSON serializable
  45. Python TypeError: cannot convert the series to when trying to do math on dataframe
  46. Shuffle DataFrame rows
  47. How to take column-slices of dataframe in pandas
  48. Python error load JSON code of google API
  49. How to overcome “datetime.datetime not JSON serializable”?
  50. Group by index + column in pandas
  51. How to iterate over columns of pandas dataframe to run regression
  52. Convert a Pandas DataFrame to a dictionary
  53. Create a Pandas Dataframe by appending one row at a time
  54. Modify the legend of pandas bar plot
  55. Displaying better error message than “No JSON object could be decoded”
  56. Count unique values using pandas groupby
  57. Ignoring NaNs with str.containsv
  58. Converting XML to JSON using Python?
  59. Count unique values per groups with Pandas [duplicate]
  60. Map to List error: Series object not callable
  61. Pandas DataFrame: replace all values in a column, based on condition
  62. How to convert string to datetime format in pandas python?
  63. No numeric types to aggregate – change in groupby() behaviour?
  64. Pandas – How to flatten a hierarchical index in columns
  65. What is the difference between json.load() and json.loads() functions
  66. Pandas OR statement ending in series contains
  67. How to convert an XML string to a dictionary?
  68. Solution for SpecificationError: nested renamer is not supported while agg() along with groupby()
  69. How to check if a column exists in Pandas
  70. How to get a value from a cell of a dataframe?
  71. Pandas split DataFrame by column value
  72. Groupby value counts on the dataframe pandas
  73. Pandas – Drop function error (label not contained in axis)
  74. Pandas index column title or name
  75. Building multi-regression model throws error: `Pandas data cast to numpy dtype of object. Check input data with np.asarray(data).`
  76. datetime to string with series in pandas
  77. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  78. How to add pandas data to an existing csv file?
  79. Importing Pandas gives error AttributeError: module ‘pandas’ has no attribute ‘core’ in iPython Notebook
  80. pandas groupby sort within groups
  81. JSON object must be str, bytes or bytearray, not dict
  82. if else function in pandas dataframe
  83. cannot convert the series to
  84. Read data (.dat file) with Pandas
  85. TypeError: expected str, bytes or os.PathLike object, not _io.TextIOWrapper
  86. How to convert index of a pandas dataframe into a column
  87. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  88. pandas replace multiple values one column
  89. Boolean Series key will be reindexed to match DataFrame index
  90. Convert floats to ints in Pandas?
  91. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  92. Difference between data type ‘datetime64[ns]’ and ‘
  93. pandas: multiple conditions while indexing data frame – unexpected behavior
  94. Extract first and last row of a dataframe in pandas
  95. Logical operators for Boolean indexing in Pandas
  96. TypeError: the JSON object must be str, not ‘bytes’
  97. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  98. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  99. Extracting specific selected columns to new DataFrame as a copy
  100. Compare two columns using pandas

Leave a Comment