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 an Index of formatted strings specified by date format
The DateTimeIndex.strftime() method in Pandas returns an Index of formatted strings based on a specified date format. This method is useful for converting datetime objects into human-readable string representations. Syntax DateTimeIndex.strftime(date_format) Parameters: date_format − A string specifying the format using strftime directives Creating a DateTimeIndex First, let's create a DateTimeIndex with timezone information − import pandas as pd # Create DatetimeIndex with period 7 and frequency as 2 days datetimeindex = pd.date_range('2021-10-30 02:30:50', periods=7, tz='Australia/Adelaide', freq='2D') print("DateTimeIndex...") print(datetimeindex) DateTimeIndex... DatetimeIndex(['2021-10-30 02:30:50+10:30', '2021-11-01 02:30:50+10:30', ...
Read MorePython Pandas - Convert times to midnight in DateTimeIndex
To convert times to midnight in DateTimeIndex, use the DateTimeIndex.normalize() method in Pandas. This method sets the time component of all datetime values to 00:00:00 while preserving the date and timezone information. What is normalize()? The normalize() method converts the time component of datetime values to midnight (00:00:00). This is useful when you want to work with dates only, ignoring the time portion. Creating a DateTimeIndex First, let's create a DateTimeIndex with various times ? import pandas as pd # Create DateTimeIndex with period 7 and frequency as 10H (10 hours) # The ...
Read MorePython Pandas - Return index locations of values between particular time of day including start time in DateTimeIndex
To return index locations of values between particular time of day in DateTimeIndex, use the DateTimeIndex.indexer_between_time() method. Set the include_start parameter to True for including the start time. Syntax DateTimeIndex.indexer_between_time(start_time, end_time, include_start=True, include_end=True) Parameters Parameter Description start_time Start time as string in format 'HH:MM:SS' end_time End time as string in format 'HH:MM:SS' include_start Whether to include start time (default: True) include_end Whether to include end time (default: True) Example Let's create a DatetimeIndex and find index locations between specific times ...
Read MoreProgram to find sum of the minimums of each sublist from a list in Python
Suppose we have a list of numbers called nums. We have to find the sum of minimum values for every possible sublist in nums. If the answer is too large, then mod the result by 10^9 + 7. So, if the input is like nums = [5, 10, 20, 10, 0], then the output will be 90 because the sublists are [[5], [10], [20], [10], [0], [5, 10], [10, 20], [20, 10], [10, 0], [5, 10, 20], [10, 20, 10], [20, 10, 0], [5, 10, 20, 10], [10, 20, 10, 0], [5, 10, 20, 10, 0]], and their minimum ...
Read MorePython Pandas - Return index locations of values between particular time of day in DateTimeIndex
To return index locations of values between particular time of day in DateTimeIndex, use the DateTimeIndex.indexer_between_time() method. This method is useful for filtering time-series data based on specific time ranges. Syntax DateTimeIndex.indexer_between_time(start_time, end_time, include_start=True, include_end=True) Parameters The method accepts the following parameters: start_time − The start time in 'HH:MM:SS' format end_time − The end time in 'HH:MM:SS' format include_start − Boolean to include start time (default: True) include_end − Boolean to include end time (default: True) Creating a DateTimeIndex First, let's create a DateTimeIndex with timezone information − ...
Read MorePython Pandas - Return index locations of values at particular time of day in DateTimeIndex
To return index locations of values at particular time of day in DateTimeIndex, use the DateTimeIndex.indexer_at_time() method. This method returns an array of integer positions where the time component matches the specified time. Syntax DateTimeIndex.indexer_at_time(time, asof=False) Parameters The key parameters are ? time ? Time as a time object or string asof ? Return the latest index location if exact time not found (default: False) Creating DateTimeIndex First, let's create a DateTimeIndex with timezone-aware timestamps ? import pandas as pd # Create DatetimeIndex with 20-minute intervals ...
Read MoreProgram to check every sublist in a list containing at least one unique element in Python
Suppose we have a list of elements called nums, we have to check whether every sublist has at least 1 element in it that occurs exactly once in the sublist or not. We have to solve this problem in linear time. So, if the input is like nums = [5, 10, 20, 10, 0], then the output will be True, because every sublist in nums has at least one element which has occurred only once. [[5], [10], [20], [10], [0], [5, 10], [10, 20], [20, 10], [10, 0], [5, 10, 20], [10, 20, 10], [20, 10, 0], [5, 10, ...
Read MorePython Pandas - Detect the frequency of the given DatetimeIndex object
To detect the frequency of a given DatetimeIndex object, use the DatetimeIndex.inferred_freq property. This property automatically infers the frequency pattern from the datetime values. Creating a DatetimeIndex First, let's create a DatetimeIndex with a specific frequency ? import pandas as pd # Create DatetimeIndex with 5 periods and 3-year frequency # Using Australia/Adelaide timezone datetimeindex = pd.date_range('2021-10-30 02:30:50', periods=5, tz='Australia/Adelaide', freq='3Y') print("DateTimeIndex...") print(datetimeindex) DateTimeIndex... DatetimeIndex(['2021-12-31 02:30:50+10:30', '2024-12-31 02:30:50+10:30', '2027-12-31 02:30:50+10:30', '2030-12-31 02:30:50+10:30', ...
Read MoreMinimum number of moves to escape maze matrix in Python
Suppose we have a binary matrix, where 0 represents an empty cell, and 1 is a wall. Starting from the top left corner (0, 0), we need to find the minimum number of cells to reach the bottom right corner (R-1, C-1), where R is the number of rows and C is the number of columns. If no path exists, return -1. This is a classic shortest path problem that can be solved using Breadth-First Search (BFS). Problem Example If the input matrix is like ? 00010 00110 00011 11000 Then the output ...
Read MorePython Pandas - Indicate whether the date in DateTimeIndex is the last day of the year
To check whether dates in a DateTimeIndex fall on the last day of the year (December 31st), use the DateTimeIndex.is_year_end property. This returns a boolean array indicating which dates are year-end dates. Syntax DateTimeIndex.is_year_end Creating a DateTimeIndex First, let's create a DateTimeIndex with dates around year-end ? import pandas as pd # Create DateTimeIndex with period 6 and frequency as 2 days datetimeindex = pd.date_range('2021-12-25 02:30:50', periods=6, tz='Australia/Adelaide', freq='2D') print("DateTimeIndex...") print(datetimeindex) DateTimeIndex... DatetimeIndex(['2021-12-25 02:30:50+10:30', '2021-12-27 02:30:50+10:30', ...
Read More