refers to gaps (zero, undefined or nonexistent elements) in data structures and sequences.
Questions tagged [gaps-in-data]
75 questions
0
votes
1 answer
How to create random gaps in a time series with different lengths?
For my Masterthesis i have to check different gap-filling methods on an existing dataset. Therefore i have to add artificial gaps of different lengths (1h, 5h..) so i can gap fill them with different methods. Is there an easy function to do so?
here…
Benjamin Mabrouk
- 94
- 5
0
votes
3 answers
Limiting records by included/excluded/null date ranges
First, a description of my task. I need to identify customers that have placed orders within the past 2 years. However, I need a subset of those records.
There needs to be 1 or more orders placed between 12-24 months ago.
A gap where NO orders…
dougbert
- 3
- 3
0
votes
0 answers
How to find gaps in temporal data inside a big mysql table
I'm trying to find the gaps in temporal data, but the problem is my data is not a fixed interval sequence, so I think I cannot use this solution: How to find gaps in sequential numbering in mysql?
My temporal data is in milliseconds (bigint),…
Enrique
- 4,693
- 5
- 51
- 71
0
votes
1 answer
Problem with gaps in data with generate_series
I need a query that returns the cumulative sum of all paid bills per day in the current month.
I've tried a few codes, including this one:
SELECT DISTINCT
month.day,
sum(bills.value) OVER (ORDER BY month.day)
FROM…
matn
- 3
- 2
0
votes
0 answers
How do you account for gaps when using Min/Max in Access?
Good afternoon.
I work with parts application data for automobiles. Typically the data I work with will have the info listed individually by year. Sometimes I need to consolidate years using a query. Sometimes there will be year gaps and I do not…
EzGoingKev
- 13
- 3
0
votes
2 answers
Gaps in Date Ranges
I have some rental information that includes the date a rental started and a possible stop date (if no stop we assume still on rent). I also have invoice information about these items that includes the start and stop of the billing cycle for each…
Jennifer Wylie
- 13
- 3
0
votes
1 answer
Mysql update row to remove int secondary column gaps
That's how my table looks like with a couple of records.
+--ID--+--DESC--+--ORD--+
| 001 | lal1 | 003 |
| 002 | lal2 | 001 |
| 003 | lal3 | 002 |
| 005 | lal4 | 004 |
| 006 | lal5 | 006 |
| 007 | lal8 | 009 …
user10771503
0
votes
2 answers
Fill in date gaps for all groups
I'm trying to fill in a bunch of date gaps for each group.
I have no problem making this work if have only one group, but when there are more than one, my dates don't fill in as I'd like them to.
As an example, the first screenshot below shows the…
user1134307
- 218
- 2
- 5
- 16
0
votes
1 answer
Pandas data frames alignment with time gaps
I have a problem trying to align two different pandas dataframes.
Actually the time alignment works using:
import pandas as pd
import datetime
import numpy as np
import matplotlib.pyplot as plt
d1 = np.random.random_integers(0,7000,[4000,1])
d2 =…
MicheleDIncecco
- 109
- 1
- 6
0
votes
3 answers
Order rows in a sequence and fill gaps for missing rows
I got a problem regarding missing rows in a table that is giving me a headache.
As base data, I have the following table:
declare @table table
(
id1 int,
id2 int,
ch char(1) not null,
val int
)
insert into @table values (1112,…
beacon.jd
- 5
- 3
0
votes
1 answer
Finding time gaps
Coincidentally, I found that my first column, a vector structured as POSIXct, has time gaps in it. My data set comprises observed values for each minute, however, for instance between 10:04:00 until 10:07:00 2 values are missing:
Date_time …
Carolus Fridericus
- 154
- 9
0
votes
1 answer
PostgreSQL create intermediate stages by overlap
is it possible to create intermediate lines with postgresql over previous and next line ?
i have the result
rownumber from to with
1 1,303 2,88 A
2 2,88 5,65 A
3 5,65 8,659 A
4 8,659 10,342 A
5 10,33 24,188 B
6 …
v.montag
- 91
- 1
- 13
0
votes
0 answers
Force MATLAB to plot date gaps as zero (instead of a line gradually changing)
Everyone wants to get rid of time gaps in plot, I want them to be shown!
So I have a table in my workspace (tableM) with two variables (Date and Temperature).
Date is in the "datenum" format. I have done a lot of preprocessing on the data and had to…
PM0087
- 123
- 1
- 9
0
votes
2 answers
How generate gap rows between dates in postgresql
I have a table that store payments. I need to merge the days a payment was made and when not.
So I will have something like:
DeudaId Date Value
1 2016-01-01 $100 <- This come from a table
1 2016-01-02 $0 <- This was calculated
1 2016-01-03 $0 <-…
mamcx
- 15,916
- 26
- 101
- 189
0
votes
2 answers
MySql/Oracle Remove gaps of numeric column
First of all, I need a solution for Oracle and MySQL.
I Have a folder table :
id | name | parent_id | position
_________________________________
1 | root | null | 1
2 | a | 1 | 1
3 | b | 1 | 2
4 | b1 | 3 |…
Yoplaboom
- 554
- 3
- 13