Skip to main content
517 questions
Newest Active Bountied Unanswered
1 vote
2 answers
78 views

I'm trying to get the period start of a given month period (2 for bimester, 3 for trimester, 4 for quarter, and 6 for semester). Here's what I've tried: DECLARE @param_MONTH_PERIOD TINYINT = 2; ...
Laura Lobo's user avatar
  • 33
1 vote
1 answer
65 views

In pandas, there are two obvious ways to represent timespans: Interval[datetime64] and Period. When do I use which? Is there a prefered one in all cases? I couldn't find this in the documentation - ...
chichak's user avatar
  • 717
0 votes
1 answer
84 views

I want to divide a large dataset into 12-hour periods of data starting/ending at midnight and noon each day. I was planning to use Pandas.Period for this but I noticed that it converts an arbitrary ...
Bill's user avatar
  • 11.8k
0 votes
1 answer
53 views

A disclaimer at the start: I am not really a programmer but do have some ability to hack some things together and get a reasonable result. But my knowledge is very much a case of— get a solution to ...
J H's user avatar
  • 11
0 votes
2 answers
204 views

I have to find next open accounting period for certain period. Suppose, on invoice, accounting period is Feb 2022, then first check if accounting period has closed. If closed, I have to find next open ...
Maira S's user avatar
  • 121
0 votes
2 answers
75 views

I have a column of strings which represent quarters (format '%Y%q') which I want to convert to PeriodIndex. How to do this? Nothing is working, can't find a strptime function that takes a format ...
Faraz Masroor's user avatar
  • 270
0 votes
1 answer
152 views

I have a CloudWatch dashboard that is designed to collect logs from a log group associated with a Lambda function. The widgets type is "number", and the Statistic is "Sample count"....
E. Wex's user avatar
  • 11
1 vote
2 answers
102 views

I have two datasets: one consisting time periods when persons worked second consisting time periods when persons were on vacation I need to remove these vacation periods from working periods as ...
st4co4's user avatar
  • 477
0 votes
1 answer
161 views

I work on Visual studio 2022 (Microsoft Visual Studio Enterprise 2022 (64-bit) - Current Version 17.10.3 ) and intellisense autocomplete erases the period. How can i have it not erase the period (or ...
Alaster's user avatar
  • 1
1 vote
1 answer
165 views

I have a weekday vs previous year weekday requirement that does not seem to be common in the Retail industry. I have found no articles or videos that happens to address this issue. My employer wants ...
Lee M's user avatar
  • 11
3 votes
1 answer
79 views

With a dataframe that has a datetime index, I am used to getting data for quarters with the syntax eg. df.loc["2014-Q1"] to grab the data for the first quarter of 2014 (Jan, Feb, Mar). This ...
Someone1348's user avatar
  • 73
0 votes
3 answers
126 views

I have the next example import pandas as pd data = { 'id_number': ['000001000', '000009795', '000011722'], 'first_date': ['2022-01-08 13:41:00', '2022-11-07 09:16:00', '2022-02-15 12:46:...
danny's user avatar
  • 67
1 vote
1 answer
156 views

Period period = new Period(startDate, endDate, PeriodType.yearMonthDay()); int years = period.getYears(); int months = period.getMonths(); int days = period.getDays(); if startDate = May 1, 1975 and ...
user414243's user avatar
  • 23
0 votes
0 answers
10 views

I have two lists of x and y values, respectively (~200k coordinate pairs total) representative of a sinusoidal wave. It's period ends at the 300th coordinate point; I've been tasked with dividing the ...
user23849637's user avatar
  • 1
1 vote
2 answers
232 views

I have a dataframe with a column "Period" which should have a dtype of pandas.Period. I would like to validate this, using a Pandera Schema (either DataFrameModel or DataFrameSchema). My ...
Andy's user avatar
  • 41

15 30 50 per page
1
2 3 4 5
…
35