Work with JSON orientations
JSON isn't a tabular format, so pandas
makes assumptions about its orientation when loading data. Most JSON data you encounter will be in orientations that pandas
can automatically transform into a dataframe.
Sometimes, like in this modified version of the Department of Homeless Services Daily Report, data is oriented differently. To reduce the file size, it has been split
formatted. You'll see what happens when you try to load it normally versus with the orient
keyword argument. The try/except
block will alert you if there are errors loading the data.
pandas
has been loaded as pd
.
This exercise is part of the course
Streamlined Data Ingestion with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
try:
# Load the JSON without keyword arguments
df = ____
# Plot total population in shelters over time
df["date_of_census"] = pd.to_datetime(df["date_of_census"])
df.plot(x="date_of_census",
y="total_individuals_in_shelter")
plt.show()
except ValueError:
print("pandas could not parse the JSON.")