From the course: Python Data Analysis

Unlock the full course today

Join today to access over 24,500 courses taught by industry experts.

Database operations in pandas

Database operations in pandas - Python Tutorial

From the course: Python Data Analysis

Start my 1-month free trial Buy for my team

Database operations in pandas

“

- [Instructor] Pandas is not a database. It's a library to manipulate structured data and, specifically, tables in memory. Unlike a database, it does not provide persistent storage, and it does not support concurrency and access control. However, it does implement some of the functions of a database. As we have seen, we can select records by imposing conditions on the index or on the fields. For a database, this will be called a query. In this video, we'll show you how Pandas performs another operation typical of databases, merging tables by matching indices or fields. For a database, that's called a join. We are going to experiment with the dataset from kaggle.com containing all the Oscars awarded since the inception of the Academy Awards in 1928. Since we want to explore merging tables, I have split the data set into a few pieces. We'll put them back together. The first two pieces are tables of actors and actresses that have been nominated for a movie. We see that we have fields for…

Contents