Python | Pandas Index.where

Last Updated : 20 Feb, 2019

Pandas Index is an immutable ndarray implementing an ordered, sliceable set. It is the basic object which stores the axis labels for all pandas objects. Pandas Index.where function return an Index of same shape as self and whose corresponding entries are from self where cond is True and otherwise are from other.

Syntax: Index.where(cond, other=None) Parameter : cond : boolean array-like with the same length as self other : scalar, or array-like Returns : Index

Example #1: Use Index.where function to return an Index, in which we select the value from the other Index if value of this Index is not smaller than 100.

Python3

# importing pandas as pd import pandas as pd  # Creating the first index idx1 = pd.Index([900, 45, 21, 145, 38, 422])  # Creating the second index idx2 = pd.Index([1100, 1200, 1300, 1400, 1500, 1600])  # Print the first index print(idx1)  # Print the second index print(idx2)

Output :

Now we will use Index.where function to return an Index, in which we select the value from the other Index if value of this Index is not smaller than 100.

Python3 1==

# return the new index based on the condition result = idx1.where(idx1 < 100, idx2) # Print the result print(result)

Output :

As we can see in the output, the Index.where function has successfully returned an Index object satisfying the passed condition. Example #2 : Use Index.where function to return an Index, which satisfy the passed condition.

Python3

# importing pandas as pd import pandas as pd  # Creating the first index idx1 = pd.Index([900, 45, 21, 145, 38, 422])  # Creating the second index idx2 = pd.Index([1100, 1200, 1300, 1400, 1500, 1600])  # Print the first index print(idx1)  # Print the second index print(idx2)

Output :

Now we will use Index.where function to return an Index, in which we select the value from the other Index if value of other Index minus 1200 is not smaller than idx1.

Python3 1==

# return the new index based on the condition result = idx1.where((idx2 - 1200) < idx1, idx2)  # Print the result print(result)

Output :

As we can see in the output, the Index.where function has successfully returned an Index object satisfying the passed condition.

Python | Pandas Index.strides

Shubham__Ranjan

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Python | Pandas Index.shape

Pandas Index is an immutable ndarray implementing an ordered, sliceable set. It is the basic object which stores the axis labels for all pandas objects. Pandas Index.shape attribute return a tuple of the shape of the underlying data in the given Index object. Syntax: Index.shape Parameter : None Ret

2 min read

Python | Pandas Index.size

Pandas Index is an immutable ndarray implementing an ordered, sliceable set. It is the basic object which stores the axis labels for all pandas objects. Pandas Index.size attribute return the number of elements in the underlying data of the given Index object. Syntax: Index.size Parameter : None Ret

2 min read

Python | Pandas Index.to_series()

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 Index.to_series() function create a Series with both index and values equal to

2 min read

Python | Pandas Index.strides

Pandas Index is an immutable ndarray implementing an ordered, sliceable set. It is the basic object which stores the axis labels for all pandas objects. Pandas Index.strides attribute return the strides of the underlying data of the given Index object. It basically return a tuple of bytes to step in

2 min read

Python | Pandas Series.str.index()

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.index() method is used to search and return lowest index of a substring in

3 min read

Python | Pandas Index.shift()

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 Index.shift() function shift index by desired number of time frequency incremen

2 min read

Python | Pandas Series.ix

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 series is a One-dimensional ndarray with axis labels. The labels need not be un

2 min read

Python | Pandas Index.values

Pandas Index is an immutable ndarray implementing an ordered, sliceable set. It is the basic object which stores the axis labels for all pandas objects. Pandas Index.values attribute return an array representing the data in the given Index object. Syntax: Index.values Parameter : None Returns : an a

2 min read

Python | Pandas Index.unique()

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 Index.unique() function return unique values in the index. Uniques are returned

2 min read

Python | Pandas Index.summary()

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 Index.summary() function return a summarized representation of the Index. This

2 min read