Python | Pandas Series.str.repeat()
Last Updated : 27 Oct, 2021
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.repeat() method is used to repeat string values in the same position of passed series itself. An array can also be passed in case to define the number of times each element should be repeated in series. For that case, length of array must be same as length of Series.
.str has to be prefixed everytime before calling this function as it's a string method and also to differentiate it from the python's default repeat method.
Syntax: Series.str.repeat(repeats)
Parameters:
repeats: int or List of int to define number of times string has to be repeated. (Size of list must be equal to series)
Return type: Series with repeated values
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: Repeating same number of times
In this example, a single integer is passed as repeats parameter and hence every string value in the series will be repeated same number of times. Before applying any operation, null values must be removed to avoid errors. Hence dropna() method is used to remove null values.
Python3 # importing pandas module import pandas as pd # making data frame data = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv") # removing null values to avoid errors data.dropna(how ='all', inplace = True) # overwriting with repeated value data["Team"]= data["Team"].str.repeat(2) # display data Output:
As shown in the output image, every string in the series was repeated twice.
Example #2: Different values for each string
In this example, a sample data frame of 10 rows is created using .head() method. After that a list of 10 integers is created and passed to the repeat() function to repeat each string different number of times.
Python3 # importing pandas module import pandas as pd # making data frame data = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv") # removing null values to avoid errors data.dropna(how ='all', inplace = True) # creating data of 10 rows sample_data = data.head(10).copy() # creating list of 10 int repeat_list =[2, 1, 3, 4, 1, 5, 0, 6, 1, 2] # calling repeat function sample_data["Name"]= sample_data["Name"].str.repeat(repeat_list) # displaying data sample_data Output:
As shown in the output image, the string is repeated according to the integer present at the same index in the repeat_list.
Note: One of the values in list is set to 0 and hence the string was repeated 0 times in final series (The older string value also got deleted and stored blank instead)
