Programming Articles - Page 986 of 3366

To indicate duplicate index values, use the index.duplicated() method.At first, import the required libraries −import pandas as pdCreating the indexwith some duplicates −index = pd.Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane']) Display the index −print("Pandas Index with duplicates...", index)Indicate duplicate index values as True, rest False. By default, it keeps the first occurrence of the duplicate value unmarked −print("Indicating duplicate values...", index.duplicated()) ExampleFollowing is the code −import pandas as pd # Creating the index with some duplicates index = pd.Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane']) # Display the index print("Pandas Index with duplicates...", index) # Return the dtype of the ... Read More

To return Index with duplicate values completely removed, use the index.drop_duplicates() method.At first, import the required libraries −import pandas as pdCreating the indexwith some duplicates −index = pd.Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane']) Display the index −print("Pandas Index with duplicates...", index)Return Index with duplicate values removed. The "keep" parameter with value "False" drops all occurrences for each set of duplicated entries −print("Index with duplicate values removed (drops all occurrences)...", index.drop_duplicates(keep = False))ExampleFollowing is the code −import pandas as pd # Creating the index with some duplicates index = pd.Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane']) # Display the index print("Pandas Index ... Read More

To return Index with duplicate values removed keeping the last occurrence, use the index.drop_duplicates() method. Use the keep parameter with value last.At first, import the required libraries −import pandas as pdCreating the index with some duplicates−index = pd.Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane']) Display the index −print("Pandas Index with duplicates...", index)Return Index with duplicate values removed. The "keep" parameter with value "last" keeps the last occurrence for each set of duplicated entries −print("Index with duplicate values removed (keeping the last occurrence)...", index.drop_duplicates(keep='last')) ExampleFollowing is the code −import pandas as pd # Creating the index with some duplicates index = pd.Index(['Car', ... Read More

To return Index with duplicate values removed except the first occurrence, use the index.drop_duplicates() method. Use the keep parameter with value first.At first, import the required libraries −import pandas as pdCreating the index with some duplicates −index = pd.Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane']) Display the index −print("Pandas Index with duplicates...", index)Return Index with duplicate values removed. The "keep" parameter with value "first" keeps the first occurrence for each set of duplicated entries −index.drop_duplicates(keep='first') ExampleFollowing is the code −import pandas as pd # Creating the index with some duplicates index = pd.Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane']) # Display the ... Read More

To make new Index with passed list of labels deleted, use the index.drop() method. Pass the list of labels in it.At first, import the required libraries −import pandas as pdCreating the index −index = pd.Index(['Car', 'Bike', 'Truck', 'Ship', 'Airplane']) Display the index −print("Pandas Index...", index)A list containing labels to be dropped are passed −print("Updated index after deleting labels...", index.drop(['Bike', 'Ship'])) ExampleFollowing is the code −import pandas as pd # Creating the index index = pd.Index(['Car', 'Bike', 'Truck', 'Ship', 'Airplane']) # Display the index print("Pandas Index...", index) # Return the dtype of the data print("The dtype object...", index.dtype) ... Read More

To make new Pandas Index with deleting multiple index elements, use the index.delete() method. Set the multiple index elements in it.At first, import the required libraries −import pandas as pdCreating the index −index = pd.Index([15, 25, 35, 45, 55, 75, 95])Display the index −print("Pandas Index...", index)Deleting multiple indexes at 3rd position i.e. index 2 and 5th position i.e. index 4 −print("Remaining Index after deleting multiple index elements...", index.delete([2, 4]))ExampleFollowing is the code −import pandas as pd # Creating the index index = pd.Index([15, 25, 35, 45, 55, 75, 95]) # Display the index print("Pandas Index...", index) # ... Read More

To make new Pandas Index with passed location deleted, use the index.delete() method.At first, import the required libraries −import pandas as pdCreating the index −index = pd.Index([15, 25, 35, 45, 55]) Display the index −print("Pandas Index...", index)Deleting a single index at 3rd position i.e. index 2 −print("Remaining Index after deleting an index at location 3rd (index 2)...", index.delete(2)) ExampleFollowing is the code −import pandas as pd # Creating the index index = pd.Index([15, 25, 35, 45, 55]) # Display the index print("Pandas Index...", index) # Return the number of elements in the Index print("Number of elements in ... Read More

To return the int position of the largest value in the Index, use the index.argmax() method.At first, import the required libraries −import pandas as pdCreating the index −index = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55]) Display the index −print("Pandas Index...", index)Get the int position of the largest value in the Index −print("Get the int position of the largest value in the Index...", index.argmax()) ExampleFollowing is the code −import pandas as pd # Creating the index index = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55]) # Display the index print("Pandas Index...", index) # ... Read More

To return the int position of the smallest value in the Index, use the index.argmin() method.At first, import the required libraries −import pandas as pdCreating the index −index = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55]) Display the index −print("Pandas Index...", index)Get the int position of the smallest value in the Index −print("Get the int position of the smallest value in the Index...", index.argmin()) ExampleFollowing is the code −import pandas as pd # Creating the index index = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55]) # Display the index print("Pandas Index...", index) # ... Read More

To return whether all elements in the index are True, use the index.any() method in Pandas.At first, import the required libraries −import pandas as pdCreating the index with some True (non-zero) and False (zero) elements −index = pd.Index([15, 25, 0, 0, 55]) Display the index −print("Pandas Index...", index)Return True if any element in the index is True: −print("Check whether any element in the index is True...", index.any()) ExampleFollowing is the code −import pandas as pd # Creating the index with some True (non-zero) and False (zero) elements index = pd.Index([15, 25, 0, 0, 55]) # Display the index ... Read More