Questions tagged [period]

A period of time is an interval, a span of time. You can also use it for questions related to the actual punctuation mark.

508 questions
0
votes
1 answer

Cut a period out of another period

I am having difficulties accomplishing a task with MSSQL. I have two tables with periods (begin and end). For example: Table 1 (ID, begin, end): A - 01/01/2023 - 31/10/2023 B - 01/01/2023 - 31/03/2023 Table 2 (ID, begin, end): A - 01/02/2023 -…
chaot
  • 3
  • 2
0
votes
1 answer

Splitting overlapping date periods and add them as new periods

I have an array of objects with a start date and an end date. Example: var periods = [ { id: "Period1", startDate: new Date("2022-08-29"), endDate: new Date("2022-12-23") }, { id: "Period2", startDate: new…
Jasper De Smet
  • 77
  • 1
  • 11
0
votes
0 answers

Recurring periods in java

In java application i have to specify recurring periods just like we schedule recurring meetings in outlook. Some examples are Recurring every Monday from 10:30 to 12:00 Recurring every Sunday from 23:00 to 05:00. Is there any library to specify…
Jomy
  • 23
  • 6
0
votes
1 answer

Getting data from current date and same date last year

I spent some hours searching and coding but i am not able to find a solution. I have a table with dates (format yyyy-mm-dd) and payment value. Each row after agregating has only one date e related values. I need generate a resultset with the…
Alex
  • 1
  • 2
0
votes
0 answers

Timeseries spectral analysis with lsp

I need to cut the information about weekly period because I think that it is polluting the graph. I would like to get a graph between peaks concentrated on 50-150 days. I am using Lomb-Scargle Periodogram by lsp package in R, with this…
0
votes
1 answer

Find all specified periods that fit into a certain date range

Suppose I have a certain defined range of dates, e.g. 2022-12-25 to 2023-02-05. I want to find all fully closed periods (specified by the user) that fit into this date range. For example, if the user specifies months and decades, the method should…
Droid
  • 441
  • 1
  • 3
  • 18
0
votes
1 answer

How can I determine during which period of the day my record was made?

In my dataset I have a parameter called visit_datetime. This parameter determines during which period the participant visited the researcher. This can be at any time a day. I want to give a value "1" if the visit was between 08.00 and 20.00, and…
0
votes
0 answers

How to identify a simple periodic pattern in a data set?

I have a data set similar to the given image: Here, Device 1 is sends a signal (i.e., active) at every 2 minutes (periodically) while the devices 2 and 3 sends a signal sporadically. My question: How can I find that Device 1 sends a periodic…
Nht_e0
  • 140
  • 4
  • 15
0
votes
1 answer

Creating averages across time periods

I'm a beginner to R, but I have the below dataframe with more observations in which I have at max each 'id' observation for three years 91, 99, 07. I want to create a variable avg_ln_rd by 'id' that takes the average of 'ln_rd' and 'ln_rd' from year…
lex_022
  • 3
  • 2
0
votes
3 answers

t-sql get all period of date from a date, a periods and a number of periods

I have a SQLServer table with the columns : a date, a period, and the number of period. And i want to get the dates in every period of month. Sample in my first line i have : Date : 25/01/2020 Period of month (always in month) : 3 Number of Periods…
MoonLightFlower
  • 173
  • 1
  • 14
0
votes
2 answers

Display Data between Dec Y-1 and Dec current Y in PowerBI

I am new in powerBI, I loonking to display data in during a closing period and in my case it is from : 31/12/Y-1 to 31/12/Y my issue it is with slicer the year filter all date in the current year and not taking into account the value in…
Aarcko
  • 11
  • 2
0
votes
2 answers

Creating a time period of top values from a python dataframe

I have this dataframe: Date Name Sum 2022-12-01 James 10 2022-12-01 Tom 4 2022-12-03 James 5 2022-12-04 Adam 8 where i want to group the top names by their sum during a 7 day period (every week from Monday to Sunday) Expected…
Mash
  • 5
  • 2
0
votes
2 answers

TSQL, break period by Month only for given year

I'm trying to break membership periods by month, but only for given year, in our example it 2022 Self inclusive code below works fine but it breaks all period, I only trying to process by month for 2022. Code below also holds definition for test…
Mario Trento
  • 513
  • 1
  • 4
  • 14
0
votes
1 answer

How to set retention period in AWS S3

I am trying to set retention period in S3 storage, in a shell script: curl -k -X PUT $ENDPOINT -H "Content-Type: application/xml" -H "Accept: application/xml" -d…
Anders
  • 21
  • 1
  • 4
0
votes
1 answer

Problem about using talib to generate MACD dataframe using different period sets

import yfinance as yf import pandas as pd import talib code = '2800' para_dict = { 'sample_period_list': [200], 'fastperiod_list': [12, 16], 'slowperiod_list': [26, 30], 'signalperiod_list': [8, 12], 'higher_percentile_list':…