Creating DataFrame from dictionary in Pandas - Try It Yourself

Creating DataFrame from dictionary

📖 Scenario: You work in a small shop and keep track of your products and their prices. You want to organize this information in a table to see it clearly.

🎯 Goal: Create a pandas DataFrame from a dictionary that holds product names and their prices.

📋 What You'll Learn

Create a dictionary called products with exact keys and values

Create a pandas DataFrame called df from the products dictionary

Print the DataFrame df to see the organized table

💡 Why This Matters

🌍 Real World

Organizing product data in tables helps shop owners quickly see prices and manage inventory.

💼 Career

Data scientists often convert raw data like dictionaries into DataFrames for easy analysis and visualization.

1

Create the products dictionary

Create a dictionary called products with these exact entries: 'Apple': 0.5, 'Banana': 0.3, 'Orange': 0.7

Pandas

# Create the products dictionary with exact entries
# Your code here

Need a hint?

Use curly braces {} to create a dictionary with keys as product names and values as prices.

2

Import pandas library

Import the pandas library using the alias pd

Pandas

products = {'Apple': 0.5, 'Banana': 0.3, 'Orange': 0.7}
# Import pandas as pd
# Your code here

Need a hint?

Use import pandas as pd to import the pandas library.

3

Create DataFrame from dictionary

Create a pandas DataFrame called df from the products dictionary. Use pd.DataFrame.from_dict(products, orient='index', columns=['Price']) to make product names the index and prices a column named 'Price'.

Pandas

import pandas as pd
products = {'Apple': 0.5, 'Banana': 0.3, 'Orange': 0.7}
# Create DataFrame df from products dictionary
# Your code here

Need a hint?

Use pd.DataFrame.from_dict() with orient='index' and columns=['Price'] to create the DataFrame.

4

Print the DataFrame

Print the DataFrame df to display the table of products and prices.

Pandas

import pandas as pd
products = {'Apple': 0.5, 'Banana': 0.3, 'Orange': 0.7}
df = pd.DataFrame.from_dict(products, orient='index', columns=['Price'])
# Print the DataFrame df
# Your code here

Need a hint?

Use print(df) to show the DataFrame.