Pandas Dataframe Index & Selecting Data | Python Pandas Tutorial #2 | iloc loc isin Pandas Function

In Video #2 of this Python Pandas Tutorial Series, you'll learn what all about the Pandas Dataframe index and how to select data in Pandas.

0:00 Introduction
0:30 Recap of Video 1
1:28 Pandas Index Overview
2:00 Set Index Function in Pandas
2:54 Setting Index in Place
4:07 Selecting a Single Column in Pandas
5:15 Iloc and loc functions in Pandas
7:48 Accessing Slices of Data with iloc
9:36 Selecting Data based on Text
11:08 Selecting Conditionally
11:29 And and Or Selections Pandas
12:55 Pandas .isin to Select a List of Values
14:35 Challenge for the Video

Learn Python programming the right way!

----------------------------------------------------------

✅ Follow me on other platforms:

[aliefe]

I have to admit it was way beyond what I expected... Thanks...

[levon]

Really helpful, I find the indexing operations in Pandas very confusing - this helps. I was confused by your use of Boolean operators near minute 13 when you used & and | .. Python uses 'and' 'or'. I've seen && and || used in Java - so are these Boolean operators part of Pandas? It doesn't seem to be Python (or did Python add these operators in the last few years?)

I'll be checking out your other videos based on how clear this one was - thanks again.

[jonathanfriz]

Hey very good video, thanks you. One question the isin is use for exact matches is there a way for match partial coincidences? using your example you put 'Health', Biology', 'Life Science', suppose the data frame contains some bad words like 'Life.Science' or two category that contains 'Life' in it how would you do that? like the filter option in excel. Thanks!

[Roma_Wasilenko]

Chalenge answer is and Science", "Health")) & (df["WomenShare"] > 0.5) ]. Right?

[MrBabcast]

The content is great, the vocal fry on the other hand, just keep me distracted...