AmitDiwan has Published 10744 Articles

Python Pandas - Drop the value when any level is NaN in a Multi-index

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:27:52

792 Views

To drop the value when any level is NaN in a Multi-index, use the multiIndex.dropna() method. Set the parameter how with value any.At first, import the required libraries -import pandas as pd import numpy as npCreate a multi-index with some NaN values. The names parameter sets the names for the ... Read More

Python Pandas - Return Index without NaN values

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:22:41

413 Views

To return Index without NaN values, use the index.dropna() 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 ... Read More

Python Pandas - Fill NaN values with the specified value in an Index object

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:20:47

637 Views

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, ... Read More

Python – Remove multiples levels using the level names and return the index

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:18:27

142 Views

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, ... Read More

Python – Remove a level using the name of the level and return the index

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:15:09

749 Views

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 ... Read More

Python - Return index with a specific level removed

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:08:59

134 Views

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', ... Read More

Python – Return index with a level removed

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:04:36

109 Views

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', ... Read More

Python Pandas - Set index name for an already created Index object

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 09:00:52

268 Views

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 ... Read More

Python Pandas - Return a Series containing counts of unique values from Index object considering NaN values as well

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 08:58:55

181 Views

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 ... Read More

Python Pandas - Return the relative frequency from Index object

AmitDiwan

AmitDiwan

Updated on 13-Oct-2021 08:56:37

192 Views

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 ... Read More

Advertisements