• Post author:
  • Post category:Pandas
  • Post last modified:March 27, 2024
  • Reading time:14 mins read
You are currently viewing Pandas Series loc[] Function

Pandas Series.loc[] function is used to access a group of rows and columns by labels or a boolean array in the given Series object. We can select some values from the given Pandas Series object based on the labels using loc[] function. In this article, I will explain Series.loc[] to select Series object values by index labels.

Advertisements

Key Points –

  • Pandas Series loc[] function allows for label-based indexing, enabling access to data based on the index labels.
  • It provides a powerful way to retrieve specific elements or slices of data from a Pandas Series using label-based indexing.
  • loc[] function supports various inputs including single labels, lists of labels, or label slices to fetch desired data.
  • It is essential for selecting specific rows or columns from a Pandas Series based on their index labels.
  • Proper usage of loc[] function ensures efficient data retrieval and manipulation in Pandas Series, contributing to streamlined data analysis workflows.

Quick Examples of Series loc[] Function

If you are in hurry below are some quick examples of the Pandas Series loc[] function.


# Quick examples of series loc[] function

# Examples 1: Use Series.loc[] function 
# To selected labels
ser2 = ser.loc[['Pandas', 'Spark', 'Python']]

# Examples 2: Select Rows Between two Index Labels
# Includes both Spark and Python rows
ser2 = ser.loc['Spark':'Python']

# Examples 3: Select Alternate rows by indeces
ser2 = ser.loc['Spark':'Pandas':2]

# Examples 4: Use loc[] and lambda
ser2 = ser.loc[lambda x : x == 28000]

# Examples 5: Use loc[] property & OR condition
ser2 = ser.loc[lambda x : (x  28000)]

Create Pandas Series

Pandas Series is a one-dimensional, Index-labeled data structure available only in the Pandas library. It can store all the datatypes such as strings, integers, float, and other python objects. We can access each element in the Series with the help of corresponding default indices.

Now, let’s create pandas series using list of values.


import pandas as pd
  
# Create the Series
ser = pd.Series([20000,25000,23000,28000,55000,23000,28000])
  
# Create the Index
index = ['Java','Spark','PySpark','Pandas','python NumPy','Python',"Oracle"]
  
# Set the index
ser.index = index
print(ser)

Yields below output.


# Output:
Java            20000
Spark           25000
PySpark         23000
Pandas          28000
python NumPy    55000
Python          23000
Oracle          28000
dtype: int64

Use Series.loc[] to Select Values from Series

You can use the Pandas Series.loc[] function to get or select the single value by Index or multiple values by index by specifying the index labels (in a list) from the Series object.


# Use Series.loc[] function to selected labels
ser2 = ser.loc[['Pandas', 'Spark', 'Python']]
print(ser2)

Yields below output.


# Output:
Pandas    28000
Spark     25000
Python    23000
dtype: int64

Select Rows Between Two Index Labels

loc[] also supports selecting rows or values between two index labels by range in pandas Series. For instance, all items between starting and ending index. The below example selects rows between Spark and Python.


# Select Rows Between two Index Labels
# Includes both Spark and Python rows
ser2 = ser.loc['Spark':'Python']
print(ser2)

Yields below output.


# Output:
Spark           25000
PySpark         23000
Pandas          28000
python NumPy    55000
Python          23000
dtype: int64

Select Alternate Rows By Indices

Similarly, by using ranges you can also select every alternate row from Series. In order to do so, you need to provide the third value as a step.


# Select Alternate rows by indeces
ser2 = ser.loc['Spark':'Pandas':2]
print(ser2)

Yields below output.


# Output:
Spark     25000
Pandas    28000
dtype: int64

Use Series.loc[] and Lambda

You can also use Pandas Series.loc[] along with lambda function. The following example returns values from a series where values are equal to 28000.


# Use loc[] and lambda
ser2 = ser.loc[lambda x : x == 28000]
print(ser2)

Yields below output.


# Output:
Pandas    28000
Oracle    28000
dtype: int64

Use Series.loc[] & OR Condition

You can also apply a “OR” condition with the “loc[]” property. The following example returns the values that are less than 25000 or values greater than 28000. For examples.


# Use loc[] property & OR condition
ser2 = ser.loc[lambda x : (x  28000)]
print(ser2))

Yields below output.


# Output:
Java            20000
PySpark         23000
python NumPy    55000
Python          23000
dtype: int64

Complete Examples of Pandas Series loc


import pandas as pd
  
# Create the Series
ser = pd.Series([20000,25000,23000,28000,55000,23000,28000])
  
# Create the Index
index = ['Java','Spark','PySpark','Pandas','python NumPy','Python',"Oracle"]
  
# Set the index
ser.index = index
print(ser)

# Use Series.loc[] function to selected labels
ser2 = ser.loc[['Pandas', 'Spark', 'Python']]
print(ser2)

# Select Rows Between two Index Labels
# Includes both Spark and Python rows
ser2 = ser.loc['Spark':'Python']
print(ser2)

# Select Alternate rows by indeces
ser2 = ser.loc['Spark':'Pandas':2]
print(ser2)

# Use loc[] and lambda
ser2 = ser.loc[lambda x : x == 28000]
print(ser2)

# Use loc[] property & OR condition
ser2 = ser.loc[lambda x : (x  28000)]
print(ser2)

Frequently Asked Questions on Pandas Series loc[] Function

What is the purpose of the Pandas Series loc[] function?

The loc[] function in Pandas Series facilitates label-based indexing, allowing users to access specific elements or slices of data based on their index labels.

What are the key inputs supported by the loc[] function?

The loc[] function supports inputs such as single labels, lists of labels, or label slices, providing flexibility in fetching desired data from a Pandas Series.

How does the loc[] function contribute to data manipulation?

By enabling precise selection of rows or columns based on their index labels, the loc[] function streamlines data manipulation tasks in Pandas Series, enhancing the efficiency of data analysis workflows.

Is the loc[] function essential for data retrieval in Pandas Series?

The loc[] function plays a crucial role in retrieving specific data points or subsets from a Pandas Series based on label-based indexing, ensuring accurate and efficient data retrieval.

Can you provide an example of using the loc[] function?

Suppose we have a Pandas Series named data with index labels ‘A’, ‘B’, ‘C’, ‘D’, and ‘E’. Using data.loc['B'] would retrieve the value corresponding to the label ‘B’ in the Series.

Conclusion

In this article, you have learned about pandas Series loc property. Series.loc[] is label-based to select some values from the given Series object in pandas with examples.

Happy Learning !!

References