Why built-in plotting matters in Pandas - See It in Action

Why built-in plotting matters

📖 Scenario: You work in a small business that tracks monthly sales data. You want to quickly see how sales change over the months without writing complex code. Using built-in plotting in pandas helps you create simple charts fast, just like drawing on paper to understand your data better.

🎯 Goal: Build a small program that creates a pandas DataFrame with monthly sales data, then uses pandas built-in plotting to show a line chart of sales over months.

📋 What You'll Learn

Create a pandas DataFrame with exact months and sales values

Create a variable for the plot title

Use pandas built-in plotting to create a line chart of sales

Print the plot title before showing the plot

💡 Why This Matters

🌍 Real World

Quickly visualizing data helps businesses understand trends without complex coding.

💼 Career

Data analysts and scientists often use pandas built-in plotting for fast data exploration and reporting.

1

Create the sales data DataFrame

Create a pandas DataFrame called sales_data with two columns: 'Month' and 'Sales'. Use these exact values: Months are 'Jan', 'Feb', 'Mar', 'Apr', 'May'. Sales are 250, 300, 280, 350, 400.

Pandas

import pandas as pd
# Create the sales_data DataFrame with Month and Sales columns
# Your code here

Hint

Use pd.DataFrame with a dictionary containing the exact keys and lists of values.

2

Create a plot title variable

Create a variable called plot_title and set it to the string 'Monthly Sales Data'.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Month': ['Jan', 'Feb', 'Mar', 'Apr', 'May'],
    'Sales': [250, 300, 280, 350, 400]
})
# Create the plot_title variable
# Your code here

Hint

Assign the exact string to the variable plot_title.

3

Create a line plot using pandas built-in plotting

Use the pandas built-in plotting to create a line plot of Sales over Month from the sales_data DataFrame. Use sales_data.plot(x='Month', y='Sales', kind='line').

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Month': ['Jan', 'Feb', 'Mar', 'Apr', 'May'],
    'Sales': [250, 300, 280, 350, 400]
})
plot_title = 'Monthly Sales Data'
# Create the line plot using pandas built-in plotting
# Your code here

Hint

Use sales_data.plot with x='Month', y='Sales', and kind='line'.

4

Print the plot title and show the plot

Write two lines: first, print the plot_title variable; second, call import matplotlib.pyplot as plt and then plt.show() to display the plot.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Month': ['Jan', 'Feb', 'Mar', 'Apr', 'May'],
    'Sales': [250, 300, 280, 350, 400]
})
plot_title = 'Monthly Sales Data'
sales_data.plot(x='Month', y='Sales', kind='line')
# Print the plot_title and show the plot
# Your code here

Hint

Use print(plot_title) and then plt.show() after importing matplotlib.pyplot as plt.

Practice

1. Why is built-in plotting in pandas useful for beginners?

easy

A. It replaces the need for data cleaning

B. It requires complex coding to create charts

C. It allows quick visualization without extra setup

D. It only works with large datasets

Solution

1. Step 1: Understand built-in plotting purpose

   Built-in plotting in pandas is designed to help users quickly visualize data without needing extra libraries or complex setup.

2. Step 2: Compare options

   It allows quick visualization without extra setup correctly states this benefit. Options A, B, and C are incorrect because built-in plotting is simple, works with any size data, and does not replace data cleaning.

3. Final Answer:

   It allows quick visualization without extra setup -> Option C

4. Quick Check:

   Built-in plotting = Quick visualization [OK]

Hint: Built-in plotting means fast charts with little code [OK]

Common Mistakes:

• Thinking it needs complex code
• Believing it only works on big data
• Confusing plotting with data cleaning

2. Which of the following is the correct syntax to plot a line chart from a pandas DataFrame df?

easy

A. df.plotchart('line')

B. df.plot.line()

C. plot(df, kind='line')

D. df.lineplot()

Solution

1. Step 1: Recall pandas plotting syntax

   The correct method to plot a line chart is using df.plot.line() or df.plot(kind='line').

2. Step 2: Evaluate options

   df.plot.line() matches the correct pandas syntax. Options B, C, and D are not valid pandas plotting methods and will cause errors.

3. Final Answer:

   df.plot.line() -> Option B

4. Quick Check:

   Correct pandas plot method = df.plot.line() [OK]

Hint: Use df.plot.line() for line charts in pandas [OK]

Common Mistakes:

• Using non-existent methods like df.plotchart
• Trying to call plot as a standalone function
• Confusing method names like lineplot

3. Given the code:

import pandas as pd
import matplotlib.pyplot as plt

df = pd.DataFrame({'A': [1, 3, 2, 4]})
df.plot(kind='bar')
plt.show()

What will this code display?

medium

A. An error because plot kind 'bar' is invalid

B. A line chart showing values 1, 3, 2, 4 for column A

C. A table printed with values 1, 3, 2, 4

D. A bar chart showing values 1, 3, 2, 4 for column A

Solution

1. Step 1: Understand the plot kind parameter

   The code uses df.plot(kind='bar'), which creates a bar chart of the data.

2. Step 2: Check the data and output

   The DataFrame has values 1, 3, 2, 4 in column 'A'. The bar chart will show these values as bars.

3. Final Answer:

   A bar chart showing values 1, 3, 2, 4 for column A -> Option D

4. Quick Check:

   kind='bar' means bar chart [OK]

Hint: kind='bar' creates bar charts in pandas plots [OK]

Common Mistakes:

• Confusing bar chart with line chart
• Expecting printed tables instead of plots
• Thinking 'bar' is an invalid kind

4. What is wrong with this code snippet?

import pandas as pd

df = pd.DataFrame({'X': [5, 2, 7]})
df.plot(kind='scatter', x='X')

medium

A. Missing y parameter for scatter plot

B. DataFrame is empty

C. Scatter plot does not exist in pandas

D. Syntax error in DataFrame creation

Solution

1. Step 1: Check scatter plot requirements

   Scatter plots need both x and y data to plot points.

2. Step 2: Analyze the code

   The code provides only x='X' but no y parameter, so it will raise an error.

3. Final Answer:

   Missing y parameter for scatter plot -> Option A

4. Quick Check:

   Scatter plot needs x and y [OK]

Hint: Scatter plots need both x and y columns [OK]

Common Mistakes:

• Forgetting y parameter in scatter plots
• Thinking scatter plots are unsupported
• Assuming DataFrame is empty

5. You have a DataFrame df with columns ['Month', 'Sales']. You want to quickly check if sales increase over months using built-in plotting. Which code snippet is best?

hard

A. df.plot(x='Month', y='Sales', kind='line')

B. df.plot(kind='bar')

C. df.plot.scatter(x='Sales', y='Month')

D. df.plot.pie(y='Month')

Solution

1. Step 1: Identify the goal

   You want to see if sales increase over months, which is best shown by a line chart with Month on x-axis and Sales on y-axis.

2. Step 2: Evaluate options

   df.plot(x='Month', y='Sales', kind='line') uses a line plot with correct x and y, ideal for trends. df.plot(kind='bar') shows bars but no x specified, so less clear. df.plot.scatter(x='Sales', y='Month') swaps axes and uses scatter, less suitable. df.plot.pie(y='Month') uses pie chart on Month, which is not meaningful here.

3. Final Answer:

   df.plot(x='Month', y='Sales', kind='line') -> Option A

4. Quick Check:

   Line plot with x=Month, y=Sales shows trends [OK]

Hint: Use line plot with x and y for trend checks [OK]

Common Mistakes:

• Using pie charts for time series
• Swapping x and y in scatter plots
• Not specifying x and y in plots