Data selection

The last topic on pandas that we'll focus on is data selection. Let's start with an example. We might come across a situation where the dataset contains an index column. How do we properly import it with pandas? And then, can we actively exploit it to make our job simpler?

We will use a very simple dataset that contains an index column (this is just a counter and not a feature). To make the example very generic, let's start the index from 100. So, the index of row number 0 is 100:

n,val1,val2,val3100,10,10,C101,10,20,C102,10,30,B103,10,40,B104,10,50,A  

When trying to load a file the classic way, you'll find yourself in a situation where you have got n as a feature (or a column). Nothing is practically incorrect, but an index ...

Get Python Data Science Essentials - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.