Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To fill NaN values with the specified value in an Index object, use the index.fillna() method in Pandas. At first, import the required libraries −import pandas as pd import numpy as npCreating Pandas index with some NaN values as well −index = pd.Index([50, 10, 70, np.nan, 90, 50, np.nan, np.nan, 30]) Display the Pandas index −print("Pandas Index...", index)Fill the NaN with some specific value −print("Index object after filling NaN value...", index.fillna('Amit')) ExampleFollowing is the code −import pandas as pd import numpy as np # Creating Pandas index with some NaN values as well index = pd.Index([50, 10, 70, np.nan, ... Read More
To remove multiples levels using the level names and return the index, use the multiIndex.droplevel(). Set the level names as parameter.At first, import the required libraries -import pandas as pdCreate a multi-index. The names parameter sets the names for the levels in the indexmultiIndex = pd.MultiIndex.from_arrays([[5, 10], [15, 20], [25, 30], [35, 40]], names=['a', 'b', 'c', 'd']) Display the multi-index −print("Multi-index...", multiIndex)Dropping multiple levels using the level names. We have passed the names of the levels to be removed as a parameter −print("Dropping multiple level...", multiIndex.droplevel(['a', 'd'])) ExampleFollowing is the code −import pandas as pd # Create a multi-index ... Read More
To remove a level using the name of the level and return the index, use the multiIndex.droplevel() method in Pandas. Set the name of the level to be removed as parameter.At first, import the required libraries -import pandas as pdCreate a multi-index. The names parameter sets the names for the levels in the indexmultiIndex = pd.MultiIndex.from_arrays([[5, 10], [15, 20], [25, 30], [35, 40]], names=['a', 'b', 'c', 'd']) Display the multi-index −print("Multi-index...", multiIndex)Dropping a level using the level name. We have passed the name of the level to be removed as a parameter −print("Dropping a level...", multiIndex.droplevel('b')) ExampleFollowing is the code ... Read More
To return index with a specific level removed, use the multiIndex.droplevel() method in Pandas. At first, import the required libraries -import pandas as pdCreate a multi-index. The names parameter sets the names for the levels in the indexmultiIndex = pd.MultiIndex.from_arrays([[5, 10], [15, 20], [25, 30], [35, 40]], names=['a', 'b', 'c', 'd'])Dropping a level. We have passed the position of the level to be removed as a parameter −print("Dropping a level...", multiIndex.droplevel(3)) ExampleFollowing is the code −import pandas as pd # Create a multi-index # The names parameter sets the names for the levels in the index multiIndex = pd.MultiIndex.from_arrays([[5, ... Read More
To return index with a level removed, use the multiIndex.droplevel() method in Pandas. At first, import the required libraries −import pandas as pdCreate a multi-index. The names parameter sets the names for the levels in the index −multiIndex = pd.MultiIndex.from_arrays([[5, 10], [15, 20], [25, 30], [35, 40]], names=['a', 'b', 'c', 'd']) Dropping a level from the multiindex −print("Dropping a level...", multiIndex.droplevel())ExampleFollowing is the code −import pandas as pd # Create a multi-index # The names parameter sets the names for the levels in the index multiIndex = pd.MultiIndex.from_arrays([[5, 10], [15, 20], [25, 30], [35, 40]], names=['a', 'b', 'c', 'd']) ... Read More
To set index name for an already created Index object, use the index.set_names() method in Pandas. At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index(["Electronics", "Mobile Phones", "Accessories", "Home Decor", "Books"]) Display the Pandas index −print("Pandas Index...", index)Set the name of index −print("Set the index name...", index.set_names('Products')) ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index(["Electronics", "Mobile Phones", "Accessories", "Home Decor", "Books"]) # Display the Pandas index print("Pandas Index...", index) # Return the number of elements in the Index print("Number of elements in the index...", ... Read More
To return a Series containing counts of unique values from Index object considering NaN values as well with the index.value_counts() method. Set the parameter dropna with value False.At first, import the required libraries -import pandas as pd import numpy as npCreating Pandas index with some NaN values as well −index = pd.Index([50, 10, 70, np.nan, 90, 50, np.nan, np.nan, 30]) Display the Pandas index −print("Pandas Index...", index)Count of unique values using value_counts(). Considering NaN as well using the "False" value of the "dropna" parameter −index.value_counts(dropna=False) ExampleFollowing is the code −import pandas as pd import numpy as np # Creating ... Read More
To return the relative frequency from Index object, use the index.value_counts() method with parameter normalize as True.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 count of unique values using value_counts(). Set the parameter "normalize" to True to get the relative frequency −print("Get the relative frequency by dividing all values by the sum of values...", index.value_counts(normalize=True))ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = pd.Index([50, 10, 70, 110, 90, 50, 110, 90, ... Read More
To return a Series containing counts of unique values from Index object sorted in Ascending Order, use the index.value_counts() method with parameter ascending as True.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)Count of unique values sorted in ascending order −print("Get the count of unique values sorted in ascending order..." "", index.value_counts(ascending=True))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 ... Read More
To return a Series containing counts of unique values from Index object, use the index.value_counts() 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)Count of unique values −print("Get the count of unique values...", index.value_counts()) 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 the Index ... Read More