Filtering Sorting Exercise—Fictional Army—Python pandas

Sometimes we learn best by doing. Unlike my other videos, I’ll be going through these exercises cold. Sometimes we’ll encounter ambiguous questions, and sometimes I'll be wrong. Learning from our mistakes can be a powerful teacher. So, it’s OK to be wrong now, because we’ll know how to avoid it next time when it counts. My hope is that you will learn by doing. Why don’t you proceed through the linked exercises before we walk through them together? This series can be viewed in tandem with my “An Opinionated Guide to pandas“ video series (links below), but it’s not required. This series is beginner-friendly but aimed most directly at intermediate users.

This Learning by Doing is part of the pandas indexing and selecting:

[thatkidavid]

Really digging this style of presenting. I was completely engaged the whole time and it shows the mental process going on.

[Any_key]

I was just looking for Pandas exercises to brush up my slightly outdated skills, but eleven videos later I’m still here.

[InfoJunky]

what is the thing that gives you hints and possible arguments for a function? is that pylint or intellisense or something?

[arhataria]

Things to remember :
df.loc[ [indices], [columns] ]
army.loc[['Maine', 'Alaska'], ['deaths', 'size', 'deserters']]

[DrFlox]

Great explanation. But there has to be a better solution for 17 and 18...

[kos]

s 17
army.iat[army.index.get_loc('Arizona'), 2]

s 18
army.iat[2,