Python JSON Data Extraction | Movie Information Retrieval

Introduction

In this project, you will learn how to extract movie information from a JSON file and print the movie names and release dates in ascending order of release date. This project will help you develop skills in working with JSON data and file handling in Python.

👀 Preview

movie: The Shawshank Redemption, published: 1994-10-14
movie: Pulp Fiction, published: 1994-10-14
movie: The Dark Knight, published: 2008-07-18
movie: Inception, published: 2010-07-16

🎯 Tasks

In this project, you will learn:

How to read and parse JSON data using the json module in Python
How to extract specific information from a JSON data structure
How to sort a list of dictionaries based on a specific key
How to print formatted output to the console

🏆 Achievements

After completing this project, you will be able to:

Understand how to work with JSON data in Python
Extract and manipulate data from a JSON file
Sort data based on a specific criteria
Present the extracted information in a readable format

Skills Graph

%%%%{init: {'theme':'neutral'}}%%%% flowchart RL python(("`Python`")) -.-> python/FileHandlingGroup(["`File Handling`"]) python(("`Python`")) -.-> python/BasicConceptsGroup(["`Basic Concepts`"]) python(("`Python`")) -.-> python/ControlFlowGroup(["`Control Flow`"]) python(("`Python`")) -.-> python/DataStructuresGroup(["`Data Structures`"]) python(("`Python`")) -.-> python/FunctionsGroup(["`Functions`"]) python(("`Python`")) -.-> python/ModulesandPackagesGroup(["`Modules and Packages`"]) python(("`Python`")) -.-> python/PythonStandardLibraryGroup(["`Python Standard Library`"]) python/FileHandlingGroup -.-> python/with_statement("`Using with Statement`") python/BasicConceptsGroup -.-> python/variables_data_types("`Variables and Data Types`") python/BasicConceptsGroup -.-> python/strings("`Strings`") python/ControlFlowGroup -.-> python/conditional_statements("`Conditional Statements`") python/ControlFlowGroup -.-> python/for_loops("`For Loops`") python/DataStructuresGroup -.-> python/lists("`Lists`") python/DataStructuresGroup -.-> python/tuples("`Tuples`") python/DataStructuresGroup -.-> python/sets("`Sets`") python/FunctionsGroup -.-> python/function_definition("`Function Definition`") python/FunctionsGroup -.-> python/lambda_functions("`Lambda Functions`") python/ModulesandPackagesGroup -.-> python/importing_modules("`Importing Modules`") python/ModulesandPackagesGroup -.-> python/standard_libraries("`Common Standard Libraries`") python/FileHandlingGroup -.-> python/file_opening_closing("`Opening and Closing Files`") python/PythonStandardLibraryGroup -.-> python/data_serialization("`Data Serialization`") python/FunctionsGroup -.-> python/build_in_functions("`Build-in Functions`") subgraph Lab Skills python/with_statement -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/variables_data_types -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/strings -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/conditional_statements -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/for_loops -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/lists -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/tuples -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/sets -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/function_definition -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/lambda_functions -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/importing_modules -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/standard_libraries -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/file_opening_closing -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/data_serialization -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} python/build_in_functions -.-> lab-302723{{"`Extracting and Sorting Movie Data from JSON`"}} end

Implement the `extract_movie_info` Function

In this step, you will implement the extract_movie_info function to extract the movie names and release dates from the movie.json file.

Open the movie.py file.
Inside the extract_movie_info function, add the following code to read the movie data from the movie.json file, sort the movies by release date, and print the movie names and release dates:

def extract_movie_info(file_path):
    with open(file_path, "r") as file:
        data = json.load(file)
        movies = data["movies"]
        sorted_movies = sorted(movies, key=lambda x: x["published_at"])

        for movie in sorted_movies:
            name = movie["name"]
            published_at = movie["published_at"]
            print(f"movie: {name}, published: {published_at}")

Run the Script

In this step, you will run the movie.py script to extract the movie information.

Open a terminal and navigate to the /home/labex/project directory.
Run the movie.py script using the following command:

python3 movie.py

You should see the following output:

movie: The Shawshank Redemption, published: 1994-10-14
movie: Pulp Fiction, published: 1994-10-14
movie: The Dark Knight, published: 2008-07-18
movie: Inception, published: 2010-07-16

Congratulations! You have successfully completed the project. You have implemented the extract_movie_info function to extract and print the movie names and release dates from the movie.json file in ascending order of release date.

Summary

Congratulations! You have completed this project. You can practice more labs in LabEx to improve your skills.

Extracting and Sorting Movie Data from JSON