Tuesday Tip #36: Deciphering the pandas index 🕵️‍♂️


Hi Reader,

Do you have a topic you'd like me to cover in a future tip? Reply and let me know! 💌


🔗 Link of the week

​Deep Learning Fundamentals (free course)

Are you interested in getting started with Deep Learning in Python? I haven't taken this course, but it looks promising!

I was thinking of starting a YouTube series in which I work through this course and share some of my learnings (and questions), and then you could follow along at home. Would that be of interest to you?


👉 Tip #36: Eight things you need to know about the pandas index

One aspect of Python's pandas library that can be confusing to newcomers is the concept of the "index". Every pandas DataFrame or Series has an index, and it's used for identification, selection, and alignment.

Here are some key facts about the index that will help you to work with pandas objects more effectively:

1️⃣ The index is on the left

The sequence of numbers on the left side is called the index, and they're used to identify the DataFrame rows. Sometimes they're called the "row labels".

2️⃣ By default, the index is a sequence of integers

Because I didn't define an index when creating the DataFrame, it assigned the numbers 0 through 192 as the index. They're stored in a special object called the "RangeIndex".

3️⃣ The column names are stored in an "Index" object

When people talk about "the index", they're talking about the row labels. But it turns out that the column names are stored in a special type of object called an "Index"!

That being said, you should never refer to the column names as "the index"... just call them "the columns" or "the column names".

4️⃣ The labels are not included in the shape

You should think of the index and columns as labels for the DataFrame. They're not part of the DataFrame "contents", and thus they're not included in its shape.

5️⃣ The index remains with each row

If you filter the DataFrame, the index remains with each row to identify it.

6️⃣ The index can be used for selection

You can use the loc accessor to select one or more rows or columns by label.

7️⃣ You can set a different column as the index

Notice that the default integer index no longer exists.

8️⃣ Setting a meaningful index allows for easier selection

Rather than referring to Brazil as "23" (its previous row label), you can refer to it as "Brazil".


Going further

If you want to learn more about the pandas index, check out these Data School videos:

🔗 What do I need to know about the pandas index? (Part 1)​

🔗 What do I need to know about the pandas index? (Part 2)​

Are you new to pandas? Stay tuned for my upcoming course, pandas in 30 days! Coming February 2024 🚀


🐊 See you later, alligator!

Did you like this week’s tip? Please forward it to a friend, or share this link in your favorite Slack group. It really helps me out! 🙌

See you next Tuesday!

- Kevin

P.S. AI murder mystery​

Did someone AWESOME forward you this email? Sign up here to receive Data Science tips every week!

Learn Artificial Intelligence from Data School 🤖

Join 25,000+ intelligent readers and receive AI tips every Tuesday!

Read more from Learn Artificial Intelligence from Data School 🤖

Hi Reader, I'm excited to announce an "early Black Friday" sale of Data School's All-Access Pass 🎟 It's simple: You pay $99, and you get access to ALL of my courses for a year. The sale starts Monday, November 23, and ends on Cyber Monday, November 30. More info is below. Let me know if you have any questions! 💬 - Kevin All-Access Pass FAQ Which courses will I be able to access? While your subscription is active, you'll have access to ALL of Data School's paid courses: Build an AI chatbot...

Hi Reader, For 12 years, I've been teaching scikit-learn. It's the ideal tool for Machine Learning in Python, given its broad functionality, community support, and high-quality documentation. But there's a HUGE difference between documentation and an effective user manual. That's why I published Master Machine Learning with scikit-learn: I wanted to provide battle-tested guidance for achieving superior Machine Learning results. (Side note: Amazon US is currently offering a 34% discount on my...

Hi Reader, I hope you're having a great September! 🍂 Two quick announcements for you: 1️⃣ I'm working on two mystery courses right now: The first is an ML course, and the second has nothing to do with Data Science! 🤯 Can you guess what the second course is about? 2️⃣ On Monday, I'm raising the price of my Master Machine Learning book from $19 to $29. But until Monday, you can still snag a paperback copy for $19! The ebook will continue to be priced at $19, and you can still read the book...