.loc is label based, so you must use the row or column labels to access the data.


Given the pictured dataframe, 


If you want to access all of the “viper” values you would run... 
```python
df.loc["viper"]
```
This returns a Pandas Series of the “viper” row. 


If you want to extract multiple rows, you can include all of the row names in a list like... 
```python
df.loc[["cobra", "viper"]]
```
This returns a Pandas DataFrame of all of the values from both the “cobra” and “viper” rows. 


To get a single value such as the max_speed of a sidewinder, you can use...
```python
df.loc["sidewinder", "max_speed"]
```
This would return a single integer value of 7. 


The syntax for the above example is... 
```python
df.loc[row_name, column_name]
```


University of Michigan - Ann Arbor

To extract data from a Pandas DataFrame you can use slicing. Two of the most popular and useful slicing techniques are the .loc and .iloc features of Pandas. The main difference between .loc and .iloc is that .loc is label based while .iloc is integer position based. 

Pandas DataFrame Slicing

https://pandas.pydata.org/docs/index.html

Pandas documentation

Pandas DataFrame .loc Slicing

.iloc is integer position based, so you must use the row or column integer position to access the data.


Given the pictured dataframe, 


If you want to access all of the “viper” values you would run... 
```python
df.iloc[1]
```
This would return a Pandas Series of the “viper” row.


If you want to extract multiple rows, you can include the integer values in a list like... 
```python
df.iloc[[0,1]]
```
This returns a Pandas Dataframe of all of the values from both the “cobra” and “viper” rows.


To get a single value such as the max_speed of a sidewinder, you can use...
```python
df.iloc[2,0]
```
This would return a single integer value of 7. 


The syntax for the above example is... 
```python
df.iloc[row_number, column_number]
``` 

Remember that Python is a zero-based indexing language so a row or column in the first position has a row or column number of 0 and not 1.


Learn Before

Related