Read JSON - PANDAS Read JSON

Question 1

Big data sets are often stored, or extracted as JSON.

Answer 1

Read JSON

Question 2

JSON is plain text, but has the format of an object

Answer 2

Read JSON

Question 3

Load the JSON file into a DataFrame: df = pd.read_json(‘data.json’)

Answer 3

Read JSON

Question 4

Use to_string() to print the entire DataFrame.

Answer 4

Read JSON

Question 5

JSON objects have the same format as Python dictionaries.

Answer 5

Dictionary as JSON

Question 6

If your JSON code is not in a file, but in a Python Dictionary, you can load it into a DataFrame directly:

Answer 6

Dictionary as JSON

Question 7

Exercise - What is a correct syntax for loading a .json file into a DataFrame?

Answer 7

df = pd.read_json(‘data.json’)

Question 8

JSON objects have the same format as a certain Python object, which one?

Answer 8

Python Dictionaries

Question 9

True or False. Python Dictionaries can be loaded directly into a Pandas DataFrame.

Answer 9

True