Python iloc, loc, ix Data Retrieving Selection Functions

that returns a pandas series object

Lets get multiple columns by passing a list

We can also specify a range

We can also combine the row and column selections

We can also simply drop the time column to achieve the same result

You can also select data using boolean statemet. example lets select where city = OAKLAND

We can do same with loc

We can also select specific rows with the boolean expression

Now lets tate a look at it ‘iloc’
iloc is for selecting rows and columns by integer position. that is what the ‘i’ stands for

Lets select all rows and columns in integer positions 0 and 3

We can also do a slice range of numbers. When you do a slice range of numbers, the selected data does not include the last number
in the slice

the returned data does not include the data at integer number 4, so it only returns 0,1,2,3 integer positions

lets select a set of rows and all columns

Now lets take a look at ix. it allows you to mix labels and integers. Tis kind of blend between loc and iloc

lets grab some new public data

Lets select the first figure under beer servings for albania

we can also do the same thing like this way

lets select with slice range

important thing about ix. if you pass it slice range numbers and you have integer indexes or integer columns it will treat the passed
slice range as integers positions and returns all data inclusive of the both numbers in the slice. However if your columns or index has
labels instead of numbers and you pass a slice range number, ix will treat it as labels and we will return data not including the last number
in the slice

we have labels in our columns so ix treated the slice range as labels and returned index positions 0,1
but we had numbers in our index and ix treated them as integer positions and returns all data from 0,1 and 2