Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Python Pandas - Return unique values in the index
To return unique values in a Pandas index, use the index.unique() method. This method returns unique values in their order of first appearance without sorting them. Syntax index.unique() Creating a Pandas Index First, let's create a Pandas index with duplicate values ? import pandas as pd # Creating Pandas index with duplicates index = pd.Index([10, 50, 70, 10, 90, 50, 10, 30]) print("Original Index:") print(index) Original Index: Int64Index([10, 50, 70, 10, 90, 50, 10, 30], dtype='int64') Getting Unique Values Use the unique() method to extract ...
Read MorePython Pandas - Mask and replace NaNs with a specific value
To mask and replace NaNs with a specific value in a Pandas Index, use the putmask() method combined with isna(). This approach allows you to replace all NaN values with a specified replacement value. Syntax index.putmask(condition, value) Parameters: condition: Boolean array or condition to identify elements to replace value: The replacement value for masked elements Creating a Pandas Index with NaNs First, let's create a Pandas Index containing some NaN values ? import pandas as pd import numpy as np # Creating Pandas index with some NaNs index ...
Read MorePython Pandas - Return a new Index of the values set with the mask
To return a new Index of the values set with the mask, use the index.putmask() method in Pandas. This method creates a new Index where values meeting a specified condition are replaced with a new value. Syntax Index.putmask(mask, value) Parameters The putmask() method accepts the following parameters: mask − A boolean condition that determines which values to replace value − The replacement value for positions where mask is True Example Let's create a Pandas Index and demonstrate how putmask() works ? import pandas as pd # ...
Read MorePython Pandas - Return a new Timedelta ceiled to this resolution
To return a new Timedelta ceiled to this resolution, use the timedelta.ceil() method. The ceil() method rounds up to the nearest specified frequency unit, similar to the mathematical ceiling function. Syntax timedelta.ceil(freq) Parameters: freq − String representing the frequency to ceil to (e.g., 'D' for days, 'H' for hours, 'T' for minutes) Basic Example Let's create a Timedelta object and ceil it to days frequency ? import pandas as pd # Create a Timedelta object timedelta = pd.Timedelta('6 days 1 min 30 s') # Display the original ...
Read MorePython Pandas - Return a new Index of the values selected by the indices
To return a new Index of the values selected by the indices, use the index.take() method in Pandas. The take() method allows you to select elements from an Index using their positional indices. Creating a Pandas Index First, let's create a Pandas Index with some sample data − 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) Pandas Index... Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], dtype='object', name='Products') Using take() to Select Values by Index ...
Read MorePython Pandas - Get the seconds from Timedelta object using string input
To extract seconds from a Pandas Timedelta object, use the timedelta.seconds property. This property returns the total seconds component of the timedelta duration. Creating a Timedelta Object First, let's create a Timedelta object using string input ? import pandas as pd # Create a Timedelta object with string input timedelta = pd.Timedelta('1 min 30 s') print("Timedelta object:", timedelta) Timedelta object: 0 days 00:01:30 Extracting Seconds Use the seconds property to get the seconds component ? import pandas as pd # Create a Timedelta object timedelta = ...
Read MorePython Pandas - Get the seconds from Timedelta object using integer input
To return the seconds from a Timedelta object, use the timedelta.seconds property. The seconds property extracts the seconds component from a Timedelta object when given integer input. Creating a Timedelta Object First, let's create a Timedelta object using integer input with unit 's' for seconds ? import pandas as pd # Create a Timedelta object with 50 seconds timedelta = pd.Timedelta(50, unit='s') # Display the Timedelta print("Timedelta...") print(timedelta) Timedelta... 0 days 00:00:50 Extracting Seconds Value Use the .seconds property to extract the seconds component from the Timedelta object ...
Read MorePython Pandas - Return the seconds from Timedelta object
To return the seconds from a Timedelta object, use the timedelta.seconds property. This property extracts only the seconds component from a Timedelta object. Syntax timedelta.seconds Creating a Timedelta Object First, let's create a Timedelta object with various time components ? import pandas as pd # Create a Timedelta object with seconds, milliseconds, and nanoseconds timedelta = pd.Timedelta('10 s 15 ms 33 ns') print("Timedelta...") print(timedelta) Timedelta... 0 days 00:00:10.015000033 Extracting Seconds Use the seconds property to get only the seconds component ? import ...
Read MorePython Pandas - Replace index values where the condition is False
To replace index values where the condition is False, use the where() method combined with isin() in Pandas. This allows you to conditionally replace index values based on whether they meet specific criteria. Syntax index.where(condition, other) Parameters: condition − Boolean condition to evaluate other − Value to use where condition is False Creating a Pandas Index First, let's create a Pandas index with product categories ? import pandas as pd # Creating Pandas index index = pd.Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], name='Products') print("Original Pandas Index:") print(index) ...
Read MorePython Pandas - Return the microseconds from Timedelta object using string input
To return the microseconds from a Timedelta object, use the timedelta.microseconds property. This property extracts only the microseconds component from the timedelta. Creating a Timedelta with Microseconds First, import pandas and create a Timedelta object using string input with microseconds ? import pandas as pd # Create a Timedelta object with microseconds timedelta = pd.Timedelta('12 min 40 us') # Display the Timedelta print("Timedelta...") print(timedelta) Timedelta... 0 days 00:12:00.000040 Extracting Microseconds Use the microseconds property to get only the microseconds component ? import pandas as pd ...
Read More