O'Reilly logo

Learning pandas - Second Edition by Michael Heydt

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Merging data from multiple pandas objects

A practical example of merges would be that of looking up customer names from orders. To demonstrate this in pandas, we will use the following two DataFrame objects. One represents a list of customer details and the other represents the orders made by the customers and what day the order was made. They will be related to each other using the CustomerID columns in each.

Now suppose we would like to ship the orders to the customers. We would need to merge the orders data with the customers detail data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required