Question

blockpy python review 16 processing json files

second pic is the report.json file data

BlockPy: Review 16) Process JSON The given file contains JSON data. Use the data associated with the "Employees" key (a list inside of a dictionary inside of a dictionary inside of a dictionary) to plot the distribution of employees. Note: You cannot embed the contents of the file directly in your program. Use the appropriate file handling style to access the data in the file. Note: You do not need to title and label your graph. Files Available: report.jsonじ f"Title": "Business Report", "Generated": "11/20/2017 at 1: 09pm", "Authors" ["Ada Lovelace, "Alan Turing", "Guido von Rossum"], "Records": "Number of Records": 4, "Span": "8-11-2017", "12-20-2017" "Data": "Sales": [46, 50, 47, 56, 54, 45, 55, 37, 54, 46, 64, 55, 56, 55, 52, 53, 39, 68, "Revenue" [66, 52, 53, 42, 49, 57, 55, 49, 54, 55, 51, 50, 57, 50, 46, 64, 43, 6 "Emp loyees" [11, 8, 10, 3, 11, 14, 6, 17, 7, 7, 6, 14, 9, 8, 10, 6, 9, 7, 12, 8, "Dogs": [20, 19, 16, 19, 19, 15, 16, 16, 21, 23, 24, 14, 19, 16, 21, 14, 23, 17, 55, 55, 44, 39, 62, 56, 53, 42, 35, 43, 42, 51], 4, 45, 52, 30, 55, 38, 64, 40, 49, 59, 38, 63, 54], 11, 18, 14, 9, 11, 11, 14, 8, 11, 4], 24, 25, 21, 17, 16, 17, 20, 19, 15, 21, 19, 22]

Answer 1

import json
import matplotlib.pyplot as plt

data = open("report.json").read()

data = json.loads(data)
plt.plot(data["Records"]["Data"]["Employees"])
plt.show()

18 16 14 12 10 8 4 10 20 0 15 25 30