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

R create multiple ranges of dates in tidyverse

I'm trying to find a way to separate out the various intervals in my data so that each row associated with an ID has it's min and max duration, broken up by the months that are NA. I have data that looks like this, but with 9 columns and 275 rows df…
0
votes
0 answers

While trying to run through effiicient age calculation I got this error in R

I tried following this R example for calculating age using three different methods: Efficient and accurate age calculation...LINK Here's a sample of my script: date_conversion_test <- copy(RawData[, dob := dob]) date_conversion_test[, givendate :=…
olabs
  • 3
  • 2
0
votes
1 answer

How to compare temperature data over a period of time

My aim is to evaluate the effect of a treatment (on microclimate data) applied to a canopy compared to a control. Therefore I put three data logger in the canopy at 5 sites and each variant ("treatment applied" vs. "control"). Data is averaged every…
Timo
  • 15
  • 6
0
votes
1 answer

How to define periods of time in hours when I have merged dates and time in R?

I have obtained a data set of several columns with different type of data from an experiment and I needed to start the counting exactly at a specific date and grouping data every 24h. The drawback is that I have the date and the time together (i.e.,…
EyreElena
  • 3
  • 4
0
votes
4 answers

oracle SQL determine consecutive periods in months

Good morning, Every 1st month I collect data for my data warehouse. Now I want to determine what the consecutive period over the months is with oracle sql. If there is an interruption in the month, I want to start a new period. The example I have is…
Marcel
  • 3
  • 2
0
votes
1 answer

PeriodFormmater in joda time

Is it possible that a duration is formatted like following. 8 hours will be considered as a day. 5 days considered as a week so 28800*1000 seconds duration will give output as 1d on periodformatting
GJoshi
  • 141
  • 2
  • 9
0
votes
0 answers

PHP add days to current Date and Exclude holiday days

I'm trying to exclude a specific period from the date I'm going to print. I tried but without success. The code I'm trying is this but not print anything and give me blank page: $get_st_date = "2020-08-01"; $get_end_date =…
Jackom
  • 384
  • 3
  • 16
0
votes
1 answer

FloPy/Python warning when running river package MODFLOW?

I'm trying to add rivers to my model but this warning happens to be there when after I run it: WARNING: Unable to resolve dimension of ('gwf6', 'riv', 'period', 'stress_period_data', 'cellid') based on shape "ncelldim" What I'm doing is I get the…
Supernova
  • 87
  • 5
0
votes
1 answer

How to sum event durations in period buckets?

Sample data data = [('2020-06-23 13:43', '2020-06-24 06:43'), ('2020-06-23 18:30', '2020-06-24 11:30'), ('2020-06-23 14:57', '2020-06-24 07:07'), ('2020-06-23 16:37', '2020-06-24 09:03'), ('2020-06-23 21:25',…
Redoute
  • 208
  • 1
  • 8
0
votes
1 answer

Single SQL Server query to get the total score by hourly, daily, weekly, monthly, and annual

I have the following requirement : single SQL Server query to get the total score by hourly, daily, weekly, monthly, and annual data. this is how the result should be: thisperiodtotalscore previousperiodtotalscore sumtotalscore periodType which…
0
votes
1 answer

set textview value after another two textview get value

i create a booking hotels apps and it hase 3 textview and 2 button to choose the date. if button click it display a date and selected date will displayed to 2 textview. how to display the day between dates in the third textview?? here's my code (…
Sitgmag
  • 1
  • 1
0
votes
1 answer

Python Datetime - find semi-months periods for a date or 2-weeks period for a date

Similarly to checking which week is a date I want to check which semi-month period is a date using datetime in python? I know we can use pd.offsets.SemiMonthEnd() but that's not what I am looking for. Is there a function similarly to dt.week that…
KBS
  • 1
  • 1
0
votes
1 answer

How to get date from year and semeter format ('YYYY-SX') using pandas

I have a pandas column called time and it contains the year and semester. For instance in format ('YYYYSX') 2018S1. I want to convert the time format in YYYYSX into date Input time 1 2019S2 2 2019S2 3 2020S1 output time 1 2019-09-30 2…
free_123
  • 79
  • 1
  • 1
  • 3
0
votes
1 answer

Mongodb Query - cumulative sum

In my database I have activities performed in different periods (start in a day and finish another day). This is an example of a document: { "activity" : "test", "period" : [ ISODate("2020-01-01T00:00:00Z"),…
pittuzzo
  • 493
  • 8
  • 29
0
votes
1 answer

Convert list of Lubridate periods to vector of periods

I have a list of periods that I would like to convert it to behave like a vector (eventually to add as a column in a data frame). library(lubridate) x <- list(ms("09:10"), ms("09:02"), ms("1:10")) # some_function(x) # with output ms(c("09:10",…
lioumens
  • 110
  • 4