Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To return number of unique elements in the Index object, use the index.nunique() method in Pandas. At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index([50, 10, 70, 110, 90, 50, 110, 90, 30]) Display the Pandas index −print("Pandas Index...", index)Get the number of unique values in the index −print("Count of unique values...", index.nunique()) ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index([50, 10, 70, 110, 90, 50, 110, 90, 30]) # Display the Pandas index print("Pandas Index...", index) # Return the number of elements in ... Read More
To return unique values in the index, use the index.unique() method in Pandas. At first, import the required libraries -import pandas as pdCreating Pandas index −index = pd.Index([10, 50, 70, 10, 90, 50, 10, 30]) Display the Pandas index −print("Pandas Index...", index)Get the unique values from the index. Unique values are returned in order of appearance, this does NOT sort −index.unique() ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index([10, 50, 70, 10, 90, 50, 10, 30]) # Display the Pandas index print("Pandas Index...", index) # Return the number of elements ... Read More
To mask and replace NaNs with a specific value, use the index.putmask() method. Within that, set the index.isna() method.At first, import the required libraries -import pandas as pd import numpy as npCreating Pandas index with some NaNs −index = pd.Index([5, 65, 10, np.nan, 75, np.nan]) Display the Pandas index −print("Pandas Index...", index)Mask and replace NaN index values with a specific value −print("Mask...", index.putmask(index.isna(), 111)) ExampleFollowing is the code −import pandas as pd import numpy as np # Creating Pandas index with some NaNs index = pd.Index([5, 65, 10, np.nan, 75, np.nan]) # Display the Pandas index print("Pandas Index...", ... Read More
To return a new Index of the values set with the mask, use the index.putmask() method in Pandas. At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index([5, 65, 10, 17, 75, 40]) Display the Pandas index −print("Pandas Index...", index)Mask and place index values less than 3 with a value 111 −print("Mask...", index.putmask(index < 30, 111)) ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index([5, 65, 10, 17, 75, 40]) # Display the Pandas index print("Pandas Index...", index) # Return the number of elements in the ... Read More
To return a new Timedelta ceiled to this resolution, use the timedelta.ceil() method. With that, set the resolution using the freq parameter.At first, import the required libraries −import pandas as pdTimeDeltas is Python’s standard datetime library uses a different representation timedelta’s. Create a Timedelta objecttimedelta = pd.Timedelta('6 days 1 min 30 s') Display the Timedeltaprint("Timedelta...", timedelta)Return the ceiled Timestamp ceiled to days frequencyres = timedelta.ceil(freq='D') ExampleFollowing is the code import pandas as pd # TimeDeltas is Python’s standard datetime library uses a different representation timedelta’s # create a Timedelta object timedelta = pd.Timedelta('6 days 1 min 30 s') # ... Read More
To return a new Index of the values selected by the indices, use the index.take() method in Pandas. At first, import the required libraries -import pandas as pdCreating Pandas index −index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products') Display the Pandas index −print("Pandas Index...", index)Getting a new index of the values selected by indices −print("A new Index of the values selected by the indices...", index.take([1, 2]))ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products') # Display the Pandas index print("Pandas Index...", index) # Return ... Read More
To return the seconds from Timedelta object, use the timedelta.seconds property. At first, import the required libraries −import pandas as pdTimeDeltas is Python’s standard datetime library uses a different representation timedelta’s. Set string input for seconds using unit 's'. Create a Timedelta objecttimedelta = pd.Timedelta('1 min 30 s') Display the Timedeltaprint("Timedelta...", timedelta)Return the seconds valuetimedelta.seconds ExampleFollowing is the code import pandas as pd # TimeDeltas is Python’s standard datetime library uses a different representation timedelta’s # set string input for seconds using unit 's' # create a Timedelta object timedelta = pd.Timedelta('1 min 30 s') # display the ... Read More
To return the seconds from Timedelta object, use the timedelta.seconds property. At first, import the required libraries −import pandas as pdTimeDeltas is Python’s standard datetime library uses a different representation timedelta’s. Set integer input for seconds using unit 's'. Create a Timedelta objecttimedelta = pd.Timedelta(50, unit ='s') Display the Timedeltaprint("Timedelta...", timedelta)Return the seconds valuetimedelta.seconds ExampleFollowing is the code import pandas as pd # TimeDeltas is Python’s standard datetime library uses a different representation timedelta’s # set integer input for seconds using unit 's' # create a Timedelta object timedelta = pd.Timedelta(50, unit ='s') # display the Timedelta print("Timedelta...", ... Read More
To replace index values where the condition is False, use the index.isin() method in Pandas. At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products') Display the Pandas index −print("Pandas Index...", index)Replace values where condition is False. Here, except the 'Decor', every other element gets replaced −print("Replace index vales where condition is False...", index.where(index.isin(['Decor']), 'Miscellaneous'))ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name ='Products') # Display the Pandas index print("Pandas Index...", index) # Return the ... Read More
To return the seconds from Timedelta object, use the timedelta.seconds property. At first, import the required libraries −import pandas as pdTimeDeltas is Python’s standard datetime library uses a different representation timedelta’s. Create a Timedelta objecttimedelta = pd.Timedelta('10 s 15 ms 33 ns') Display the Timedeltaprint("Timedelta...", timedelta)Return the seconds valuetimedelta.seconds ExampleFollowing is the code import pandas as pd # TimeDeltas is Python’s standard datetime library uses a different representation timedelta’s # create a Timedelta object timedelta = pd.Timedelta('10 s 15 ms 33 ns') # display the Timedelta print("Timedelta...", timedelta) # return the seconds value res = timedelta.seconds ... Read More