On: A Gentle Visual Intro to Data Analysis in Python U...

[jalammar]

Thanks for the heads up! Indeed it's df.loc[1:3] that would return three rows, not straight-up df[1:3] which indeed returns two rows.

Edit: Corrected in the post. Thanks again!

[rapfaria → jalammar]

Genuine question, did you run the original before publishing it on the website?

[yufeng66 → jalammar]

But why design it that way? Seems to be a sure way to confuse new user.

[EForEndeavour → yufeng66]

I'd say that's because df[start:stop] mimics python's builtin list slicing, which includes start but excludes end, so this dictates the behaviour of indexing without .loc. By contrast, df.loc[start:stop] is a label-based indexer, and labels can be anything (integers, strings, datetimes, categories, etc.), so it doesn't always make sense to exclude the right endpoint of the interval.

[happy-go-lucky → jalammar]

(＾＾)ｂ