Pandas DataFrame is a two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns). Arithmetic operations align on both row and column labels. It can be thought of as a dict-like container for Series objects. This is the primary data structure of the Pandas.
Pandas DataFrame loc[] Syntax
Pandas DataFrame.loc attribute access a group of rows and columns by label(s) or a boolean array in the given Pandas DataFrame.
Syntax: DataFrame.loc
Parameter : None
Returns : Scalar, Series, DataFrame
Pandas DataFrame loc Property
Example 1: Use DataFrame.loc attribute to access a particular cell in the given Pandas Dataframe using the index and column labels.
Python3
# importing pandas as pdimport pandas as pd# Creating the DataFramedf = pd.DataFrame({'Weight':[45, 88, 56, 15, 71], 'Name':['Sam', 'Andrea', 'Alex', 'Robin', 'Kia'], 'Age':[14, 25, 55, 8, 21]})# Create the indexindex_ = ['Row_1', 'Row_2', 'Row_3', 'Row_4', 'Row_5']# Set the indexdf.index = index_# Print the DataFrameprint(df) |
Output:
Now we will use DataFrame.loc attribute to return the value present in the ‘Name’ column corresponding to the ‘Row_2’ label.
Python3
# return the valueresult = df.loc['Row_2', 'Name']# Print the resultprint(result) |
Output:
Here, the DataFrame.loc attribute has successfully returned the value present at the desired location in the given DataFrame.
Example 2: Use DataFrame.loc attribute to return two of the column in the given Dataframe.
Python3
# importing pandas as pdimport pandas as pd# Creating the DataFramedf = pd.DataFrame({"A":[12, 4, 5, None, 1], "B":[7, 2, 54, 3, None], "C":[20, 16, 11, 3, 8], "D":[14, 3, None, 2, 6]})# Create the indexindex_ = ['Row_1', 'Row_2', 'Row_3', 'Row_4', 'Row_5']# Set the indexdf.index = index_# Print the DataFrameprint(df) |
Output:
Now we will use DataFrame.loc attribute to return the values present in the ‘A’ and ‘D’ columns of the Dataframe.
Python3
# return the values.result = df.loc[:, ['A', 'D']]# Print the resultprint(result) |
Output :
As we can see in the output, the DataFrame.loc attribute has successfully returned the desired columns of the Dataframe.
