Skip to content
Related Articles

Related Articles

Python | Pandas series.str.get()
  • Difficulty Level : Easy
  • Last Updated : 20 Nov, 2019

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.

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing pandas module 
import pandas as pd
  
# reading csv file from url 
   
# 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

chevron_right


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.

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing pandas module 
import pandas as pd
  
# reading csv file from url 
   
# 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)

chevron_right


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)

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :