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
Server Side Programming Articles
Page 249 of 2109
Python 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 MorePython Pandas - Indicate whether the date in DateTimeIndex is the first day of the year
To check whether the date in DateTimeIndex is the first day of the year, use the DateTimeIndex.is_year_start property. This property returns a boolean array indicating which dates are January 1st. Syntax DateTimeIndex.is_year_start Creating a DateTimeIndex First, let's create a DateTimeIndex that spans across a year boundary to demonstrate the property ? import pandas as pd # Create DateTimeIndex spanning year boundary datetimeindex = pd.date_range('2021-12-30 02:30:50', periods=6, tz='Australia/Adelaide', freq='1D') print("DateTimeIndex...") print(datetimeindex) DateTimeIndex... DatetimeIndex(['2021-12-30 02:30:50+10:30', '2021-12-31 02:30:50+10:30', ...
Read MoreProgram to find number of quadruples for which product of first and last pairs are same in Python
Suppose we have a list of numbers called nums, with unique positive numbers. We have to find the number of quadruples like (a, b, c, d) from nums such that a*b = c*d, where a, b, c and d are all distinct elements of nums. So, if the input is like nums = [3, 6, 4, 8], then the output will be 8, because the quadruples are [[3, 8, 6, 4], [3, 8, 4, 6], [8, 3, 6, 4], [8, 3, 4, 6], [6, 4, 3, 8], [4, 6, 3, 8], [6, 4, 8, 3], [4, 6, 8, 3]]. ...
Read More