Wrangling JSON Data in Pandas

How to read in, parse, and reshape JSON data into a tabular form that can be used for further analysis. Concepts covered include: Lists and Dictionaries, Normalising JSON data, exploding nested values into additional columns, reshaping wide datasets into narrow datasets by melting, joining datasets together, and briefly covering aggregations to create a summary analysis.