Python | Pandas series.str.get()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.

Pandas str.get() method is used to get element at the passed position. This method works for string, numeric values and even lists throughout the series. .str has to be prefixed every time to differentiate it from Python’s default get() method.

Syntax: Series.str.get(i)

Parameters:
i : Position of element to be extracted, Integer values only.

Return type: Series with element/character at passed position

To download the CSV used in code, click here.

In the following examples, the data frame used contains data of some NBA players. The image of data frame before any operations is attached below.

Example #1: Getting character from string value

In this example, str.get() method is used to get a single character from the Name column. The null values have been removed using dropna() method and the series is converted to string type series using .astype() before applying this method. This method can be used to get one character instead of whole string. For example, getting M from Male and F from Female since there can be two inputs only, so doing this can save data.

# importing pandas module
import pandas as pd

# reading csv file from url
data = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv")

# dropping null value columns to avoid errors
data.dropna(inplace = True)

# converting to string series
data["Name"]= data["Name"].astype(str)

# creating new column with element at 0th position in data["Team"]
data["New"]= data["Name"].str.get(0)

data
# display

Output:
As shown in the output image, the New column is having first letter of the string in Name column.

Example #2: Getting elements from series of List

In this example, the Team column has been split at every occurrence of ” ” (Whitespace), into a list using str.split() method. Then the same column is overwritten with it. After that str.get() method is used to get elements in list at passed index.

# importing pandas module
import pandas as pd

# reading csv file from url
data = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv")

# dropping null value columns to avoid errors
data.dropna(inplace = True)

# converting to string series
data["Team"]= data["Team"].astype(str)

# splitting at occurrence of whitespace
data["Team"]= data["Team"].str.split(" ", 1)

# displaying first element from list
data["Team"].str.get(0)

# displaying second element from list
data["Team"].str.get(1)

Output:
As shown in the output images, The first image is of Elements at 0th position in series and the second image is of elements at 1st position in the series.

Output 1: data["Team"].str.get(0)


Output 2: data["Team"].str.get(1)