Python | Pandas Series.clip()
Last Updated :
11 Oct, 2018
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.
Python Series.clip()
is used to clip value below and above to passed Least and Max value. This method comes in use when doing operations like Signal processing. As we know there are only two values in Digital signal, either High or Low. Pandas Series.clip()
can be used to restrict the value to a Specific Range.
Syntax: Series.clip(lower=None, upper=None, axis=None, inplace=False)
Parameters:
lower: Sets Least value of range. Any values below this are made equal to lower.
upper: Sets Max value of range. Any values above this are made equal to upper.
axis: 0 or ‘index’ to apply method by rows and 1 or ‘columns’ to apply by columns
inplace: Make changes in the caller series itself. (Overwrite with new values)
Return type: Series with updated values
To download the data set used in following example, 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
In this example, the .clip()
method is called on Age column of data. A minimum value of 22 is passed to lower parameter and 25 to upper parameter. The returned series is then stored in a new column ‘New Age’. Before doing any operations, Null rows were dropped using .dropna()
to avoid errors.
import pandas as pd
import re
data.dropna(inplace = True )
lower = 22
upper = 25
data[ "New Age" ] = data[ "Age" ].clip(lower = lower, upper = upper)
data
|
Output:
As shown in the output image, the New Age column has least value of 22 and max value of 25. All values are restricted to this range. Values below 22 were made equal to 22 and values above 25 were made equal to 25.
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...