Scatter plots in Pandas - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a scatter plot using pandas.

Pandas

import pandas as pd
import matplotlib.pyplot as plt

data = {'x': [1, 2, 3, 4], 'y': [10, 20, 25, 30]}
df = pd.DataFrame(data)
df.plot.scatter(x='x', y=[1])
plt.show()

Drag options to blanks, or click blank then click option'

Ax

Bindex

Cy

Dz

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'x' for both axes causes a line, not a scatter plot.

Using a non-existent column like 'z' causes an error.

The scatter plot requires the y-axis column name. Here, it is 'y'.

2fill in blank

medium

Complete the code to set the color of points in the scatter plot.

Pandas

import pandas as pd
import matplotlib.pyplot as plt

data = {'height': [150, 160, 170, 180], 'weight': [50, 60, 65, 70]}
df = pd.DataFrame(data)
df.plot.scatter(x='height', y='weight', c=[1])
plt.show()

Drag options to blanks, or click blank then click option'

A'blue'

B'circle'

C'scatter'

D'line'

Attempts:

3 left

💡 Hint

Common Mistakes

Using shape names like 'circle' instead of color names.

Passing plot types like 'scatter' or 'line' as color.

The 'c' parameter sets the color of points. It accepts color names like 'blue'.

3fill in blank

hard

Fix the error in the code to correctly plot a scatter plot with size variation.

Pandas

import pandas as pd
import matplotlib.pyplot as plt

data = {'age': [20, 25, 30, 35], 'income': [2000, 2500, 3000, 3500], 'score': [10, 20, 30, 40]}
df = pd.DataFrame(data)
df.plot.scatter(x='age', y='income', s=[1])
plt.show()

Drag options to blanks, or click blank then click option'

Adf['score']

B'score'

Cscore

Ddf.score()

Attempts:

3 left

💡 Hint

Common Mistakes

Passing the column name as a string instead of the Series.

Trying to call the column as a method.

The 's' parameter expects numeric values for sizes. Passing the Series df['score'] works correctly.

4fill in blank

hard

Fill both blanks to create a scatter plot with custom marker and transparency.

Pandas

import pandas as pd
import matplotlib.pyplot as plt

data = {'temp': [30, 35, 40, 45], 'sales': [100, 150, 200, 250]}
df = pd.DataFrame(data)
df.plot.scatter(x='temp', y='sales', marker=[1], alpha=[2])
plt.show()

Drag options to blanks, or click blank then click option'

A'x'

B0.5

C1.5

D'o'

Attempts:

3 left

💡 Hint

Common Mistakes

Using alpha values greater than 1 causes errors.

Using invalid marker strings.

The marker 'x' is a valid shape, and alpha 0.5 sets transparency to 50%.

5fill in blank

hard

Fill all three blanks to create a scatter plot with color, size, and title.

Pandas

import pandas as pd
import matplotlib.pyplot as plt

data = {'speed': [5, 10, 15, 20], 'distance': [50, 100, 150, 200], 'weight': [100, 200, 300, 400]}
df = pd.DataFrame(data)
ax = df.plot.scatter(x=[1], y=[2], s=[3], c='red')
ax.set_title('Speed vs Distance')
plt.show()

Drag options to blanks, or click blank then click option'

A'speed'

B'distance'

Cdf['weight']

D'weight'

Attempts:

3 left

💡 Hint

Common Mistakes

Passing column names as strings for size instead of Series.

Mixing up x and y axis names.

The x-axis is 'speed', y-axis is 'distance', and sizes come from the 'weight' column as a Series.

Practice

1. What does a scatter plot primarily show in a pandas DataFrame?

easy

A. The relationship between two numeric columns

B. The frequency of a single categorical column

C. The sum of all numeric columns

D. The average value of a column over time

Solution

1. Step 1: Understand scatter plot purpose

   A scatter plot is used to visualize how two numeric variables relate to each other by plotting points on an x and y axis.

2. Step 2: Match with options

   Only The relationship between two numeric columns describes this relationship between two numeric columns, while others describe different chart types or summaries.

3. Final Answer:

   The relationship between two numeric columns -> Option A

4. Quick Check:

   Scatter plot = relationship between two numeric columns [OK]

Hint: Scatter plots always compare two numeric columns [OK]

Common Mistakes:

• Confusing scatter plots with bar charts
• Thinking scatter plots show single column frequency
• Assuming scatter plots summarize data instead of showing relationships

2. Which of the following is the correct syntax to create a scatter plot in pandas for columns 'height' and 'weight'?

easy

A. df.plot.scatter('weight', 'height')

B. df.scatter_plot('height', 'weight')

C. df.plot.scatter(x='height', y='weight')

D. df.plot.scatter(x=height, y=weight)

Solution

1. Step 1: Recall pandas scatter plot syntax

   The correct method is df.plot.scatter with x and y as column names in quotes.

2. Step 2: Check each option

   df.plot.scatter(x='height', y='weight') uses correct method and argument format. df.scatter_plot('height', 'weight') is invalid method. df.plot.scatter('weight', 'height') swaps x and y but is still valid syntax, but question asks for 'height' as x and 'weight' as y. df.plot.scatter(x=height, y=weight) uses variables without quotes causing error.

3. Final Answer:

   df.plot.scatter(x='height', y='weight') -> Option C

4. Quick Check:

   Correct syntax uses df.plot.scatter with x and y as strings [OK]

Hint: Use df.plot.scatter(x='col1', y='col2') with quotes [OK]

Common Mistakes:

• Using method scatter_plot instead of plot.scatter
• Passing column names without quotes
• Swapping x and y columns unintentionally

3. Given the code:

import pandas as pd
import matplotlib.pyplot as plt

data = {'age': [25, 30, 35, 40], 'income': [50000, 60000, 65000, 70000]}
df = pd.DataFrame(data)
df.plot.scatter(x='age', y='income')
plt.show()

What will the scatter plot show?

medium

A. A bar chart of age vs income

B. An error because plt.show() is missing

C. A line plot connecting age and income

D. Points showing income increasing with age

Solution

1. Step 1: Understand the code

   The DataFrame has 'age' and 'income' columns. The scatter plot plots 'age' on x-axis and 'income' on y-axis.

2. Step 2: Interpret the plot type and data

   Scatter plot will show points representing each person's age and income. Income increases as age increases, so points trend upward.

3. Final Answer:

   Points showing income increasing with age -> Option D

4. Quick Check:

   Scatter plot shows points, not bars or lines [OK]

Hint: Scatter plots show points, not bars or lines [OK]

Common Mistakes:

• Confusing scatter plot with bar or line plot
• Thinking plt.show() is optional and causes error
• Misreading which column is x or y

4. What is wrong with this code snippet to create a scatter plot?

df.plot.scatter(x=age, y='income')

medium

A. Scatter plots require plt.scatter, not df.plot.scatter

B. The variable age is not defined or quoted

C. plot.scatter does not exist in pandas

D. The y parameter should be numeric, not string

Solution

1. Step 1: Check the x parameter

   The x parameter should be the column name as a string, but age is unquoted, treated as a variable.

2. Step 2: Verify other parameters and method

   y='income' is correct as a string. plot.scatter is valid pandas method. So only x parameter is wrong.

3. Final Answer:

   The variable age is not defined or quoted -> Option B

4. Quick Check:

   Column names must be strings in plot.scatter [OK]

Hint: Always quote column names in plot.scatter [OK]

Common Mistakes:

• Passing column names without quotes
• Confusing pandas plot.scatter with matplotlib scatter
• Thinking y must be numeric type, not string

5. You have a DataFrame with columns 'temperature', 'sales', and 'day'. You want to create a scatter plot showing sales vs temperature, but color points by day of the week. Which approach is correct?

hard

A. Use df.plot.scatter(x='temperature', y='sales', c=df['day'].astype('category').cat.codes)

B. Use df.plot.scatter(x='temperature', y='sales', color='day')

C. Use df.plot.scatter(x='temperature', y='sales', c='day')

D. Use df.plot.scatter(x='temperature', y='sales', c=df['day'])

Solution

1. Step 1: Understand color parameter in scatter plot

   The c parameter expects numeric values for colors. The 'day' column is categorical (strings), so it must be converted to numeric codes.

2. Step 2: Check each option's color argument

   Use df.plot.scatter(x='temperature', y='sales', c=df['day'].astype('category').cat.codes) converts 'day' to category codes, which is correct. Use df.plot.scatter(x='temperature', y='sales', color='day') uses color='day' which is invalid. Use df.plot.scatter(x='temperature', y='sales', c='day') passes string 'day' which is invalid. Use df.plot.scatter(x='temperature', y='sales', c=df['day']) passes categorical strings directly, causing error.

3. Final Answer:

   Use df.plot.scatter(x='temperature', y='sales', c=df['day'].astype('category').cat.codes) -> Option A

4. Quick Check:

   Color values must be numeric codes for categorical data [OK]

Hint: Convert categorical to numeric codes for color in scatter [OK]

Common Mistakes:

• Passing categorical strings directly to color parameter
• Using color='day' instead of numeric codes
• Not converting categories before coloring