Start Here
Learn Python

Start Learning
Your Learning Plan →Your personalized Python learning plan Python Tutorials →In-depth articles and video courses Learning Paths →Guided study plans for accelerated learning

Practice
Quizzes & Exercises →Check your learning progress Browse Topics →Focus on a specific area or skill level Reference →Concise definitions for common Python terms

Get Help
Mentor AI →NewYour personal Python mentor Office Hours →Live Q&A calls with Python experts Community Chat →Learn with other Pythonistas

Go Deeper
Live Courses →Live, instructor-led Python courses Books →Round out your knowledge and learn offline Podcast →Hear what’s new in the world of Python

Unlock All Content and Become a Python Expert →Get unlimited access to all Real Python has to offer

Unlock All Content →Become a Python Expert
More
Learner Stories Python Newsletter Python Job Board Meet the Team Become a Contributor

Search

/

Join
Sign‑In

Loading exercise...

Exercise: Add Colors to the Fruit Basket

Martin Breuss

Combining Data in pandas With concat() and merge() Martin Breuss 08:00

Recommended Tutorial Course Slides (.pdf) Sample Code (.zip)

Ask a Question

Contents
Discussion

Become a Member to join the conversation.

Course Contents

Overview

77%

Getting Started

Combining Data in pandas with concat() and merge() (Overview) 03:22

Set Up Your Environment 02:49

Create the Dataset 03:09

Combining Data Using concat()

Concatenate Along the Row Axis 03:33

Concatenate Along the Column Axis 05:44

Mark Your DataFrames With Keys 03:33

Access Data in a Multi-Index DataFrame 04:45

Exercise: Stack Harvests With Source Labels 08:00

Re-create a New Index After Concatenation 03:47

Join Columns When Concatenating on Rows 04:45

Exercise: Stack Only Shared Columns 08:00

Join Rows When Concatenating on Columns 02:35

Revisit Combining Data Using concat() 02:32

Combining Data Using merge()

Perform an Inner Join Using merge() 07:00

Perform an Outer Join Using merge() 06:18

Understand the Differences Between Left and Right Joins 07:34

Exercise: Add Colors to the Fruit Basket 08:00

Specify the Join Columns Explicitly 06:07

Join DataFrames Using Index Columns 06:47

Exercise: Look Up Produce Prices 08:00

Customize Column Suffixes and Perform a Cross Join 04:11

Exercise: Pair Every Fruit With a Veggie 08:00

Practice Your Intuition With Some Peculiarities 07:10

Revisit Combining Data Using merge() 03:22

Combining Data in pandas With concat() and merge() (Summary) 04:51

© 2012–2026 Real Python ⋅ Privacy Policy