Review · Prepare responsibly

A responsible finish · WR5 · 12 MIN

Review · Prepare responsibly

Task 1 · Retrieve and combine

Exercises within this concept

Task 1Retrieve and combineCurrent exercise
Task 2Retrieve and combine
Task 3Retrieve and combine
Task 4Retrieve and combine

Task 1 · Pet adoption

Combine supplied first and second, then keep records with age above 2.

The editable setup on the right creates df and the additional inputs shown below. Run executes the setup and your work from top to bottom.

Your requirements

Display them sorted by age, largest first, with a fresh consecutive index.

Your inputs

Pet adoption · 6 synthetic rows
name	species	age	weight	room
Milo	Cat	3	4.2	A
Pepper	Dog	7	18.5	B
Luna	Cat	2	3.6	A
Bean	Rabbit	4	2.4	B
Rex	Dog	5	22	A
Nori	Rabbit	1	1.8	B

first · first three rows
name	species	age	weight	room
Milo	Cat	3	4.2	A
Pepper	Dog	7	18.5	B
Luna	Cat	2	3.6	A

second · remaining rows
name	species	age	weight	room
Bean	Rabbit	4	2.4	B
Rex	Dog	5	22	A
Nori	Rabbit	1	1.8	B

Revisit the concept lesson →

Remember the idea

concat appends tables in the order listed. It matches column names, rather than looking for matching records.

A small example

Batches with indices [0, 1] and [0, 1] produce [0, 1, 0, 1], or [0, 1, 2, 3] with ignore_index=True.

What each choice does
Code or choice	Meaning
`pd.concat([first, second])`	Append second below first and retain existing row labels.
`ignore_index=True`	Number the combined rows consecutively from zero.

Hint

Finish filtering and sorting before assigning presentation indices.

Reveal solution

One way to do it. Keep any supplied setup in the editor and use this in the Your work section.

combined = pd.concat([first, second], ignore_index=True)
combined[combined["age"] > 2].sort_values("age", ascending=False).reset_index(drop=True)

Your task · Task 1

Combine supplied first and second, then keep records with age above 2.
Display them sorted by age, largest first, with a fresh consecutive index.

YOUR PYTHON

Tab: indent · Shift+Tab: outdent · Esc, then Tab: leave editor

# Supplied setup — editable
import pandas as pd

data = {
    "name": ["Milo", "Pepper", "Luna", "Bean", "Rex", "Nori"],
    "species": ["Cat", "Dog", "Cat", "Rabbit", "Dog", "Rabbit"],
    "age": [3, 7, 2, 4, 5, 1],
    "weight": [4.2, 18.5, 3.6, 2.4, 22, 1.8],
    "room": ["A", "B", "A", "B", "A", "B"],
}

df = pd.DataFrame(data)

first = df.iloc[:3].copy()
second = df.iloc[3:].copy()

# Your work
# Retrieve the earlier skill

Each run executes all editor code in a fresh Python session. Display a value by leaving it on the final line.

Python starts when you open a lesson.

Output

Run your code to see what Python returns.