Questions tagged [gaps-in-data]

refers to gaps (zero, undefined or nonexistent elements) in data structures and sequences.

75 questions

vote

4 answers

Fill in rows per group for pivoting

I have an Oracle 18c table called LOGS: create table logs (id number, log_tags varchar2(4000)); insert into logs (id, log_tags) values ( 1,'

asked Apr 15 '23 at 20:43

User1974

vote

2 answers

How to have ClearCase diagnose opslog gaps in Multisite

Can ClearCase's multitool help me fix an opslog gap in a multisite environment? I can't find anything in the man page.

clearcase gaps-in-data

asked Dec 08 '22 at 15:32

Juan Jimenez

vote

2 answers

Fill month gaps based on multiple columns and aggregate data

I need to aggregate data on a monthly basis and also fill the gaps of months for the whole year with 0 Amounts. The problem is that the aggregation must happen on multiple columns and this makes it tricky (i.e. using date table and left join does…

sql sql-server aggregate period gaps-in-data

asked Jun 07 '22 at 11:47

nesisekasi

vote

1 answer

Filling gaps with next not null value

I've been trying to find a solution to this since some days ago. I have the following dataset. |id|order|certain_event|order_of_occurrence| |--|-----|-------------|-------------------| |a |1 |NULL |NULL | |a |2 |NULL …

sql teradata gaps-and-islands ansi-sql gaps-in-data

asked Aug 12 '21 at 03:33

left_

vote

2 answers

Adding Missing Dates To Each Location - MySQL 5.7

So my SQL output is: DUNF 2021-04-01 18 DUNF 2021-04-02 17 DUNF 2021-04-03 7 DUNF 2021-04-04 10 DUNF 2021-04-05 18 DUNF 2021-04-06 20 DUNF 2021-04-07 17 DUNF 2021-04-08 14 LEEDS 2021-04-01 4 LEEDS 2021-04-02 …

mysql date join calendar gaps-in-data

asked Apr 21 '21 at 10:15

JohnFellows

vote

2 answers

SQL Server filling gaps in time series

I'm having trouble with a request in SQL. I have two tables, one representing a vector of dates and another timeseries of prices for different…

sql sql-server join gaps-in-data

asked Mar 10 '21 at 15:19

Fede

vote

1 answer

Find data gaps and split in more tracks

I have tracking data for some animals and I want to know if I have tracks with more than 1 day gaps in the satellite transmission for each id. And, if any, I need to split the tracks into 2 or more sub-tracks for the same id. So, some individuals…

r split gaps-in-data

asked Oct 27 '20 at 19:05

Anne Elise

vote

1 answer

Getting a count of missing timestamps in a dataset based on expected interval

I have a dataset that is made up of timestamp readings for pressure that should be recorded and returned every 15 minutes. The example data below shows that there are gaps greater than 15 minutes in the data set I have been trying to find a way to…

python pandas dataframe time-series gaps-in-data

asked Jun 24 '20 at 13:18

TrevP

vote

1 answer

How can I find gaps in timestamps in SQL (for a data scraper)

I'm very new to working with DBs/SQL and doing my best to get adjusted I'm using SQLAlchemy/Postgres to write data from a Python API that I write market data from every 10 minutes (inserted into DB). This scraper is intended to get stock minute…

python sql database postgresql gaps-in-data

asked Feb 25 '19 at 19:55

Michael W

vote

0 answers

How to fill blank cells with linear values in R?

I am trying to fill in blank values using R just as I would using excel to fill blank cells in a series with linear values. I am trying to get R to fill in the med_age for the dates between 1940 and 1950, 1950 and 1960 in a linear fashion based on…

gaps-in-data

asked May 18 '18 at 06:21

Ben

vote

1 answer

Subtract Rows in Postgresql using WINDOW functions

I have following table called "Projects": CREATE TABLE Projects (Task_ID integer, Start_Date date, End_Date date) INSERT INTO Projects VALUES (1, '2015-10-01', '2015-10-02'), (2, '2015-10-02', '2015-10-03'), (3, '2015-10-03', '2015-10-04'), (4,…

postgresql gaps-and-islands gaps-in-data

asked Oct 11 '17 at 16:25

Ms workaholic

vote

1 answer

Determining continuity length of a sequence of dates in postgres

Is there a straightforward way to determine the length of continuity in a sequence of dates in Postgres? For simplicity, lets say I have a table of dates, like so: 2017-01-01 2017-01-02 2017-01-03 2017-01-04 2017-01-06 2017-01-08 2017-01-09 For…

sql postgresql date gaps-and-islands gaps-in-data

asked Feb 24 '17 at 17:44

zambo

vote

0 answers

MySQL - Find gaps in time series table

I have a time series table with values every 5 minute, with the following table structure: DATETIME VALUE 2000-01-01 00:00:00 4 2000-01-01 00:05:00 33 2000-01-01 00:10:00 8 2000-01-01 00:15:00 9 2000-01-01 00:25:00 …

mysql time-series gaps-in-data

asked Jan 09 '17 at 00:34

Vincent L

vote

1 answer

MySQL finding gaps in column with multiple ID

I would like to find gaps in following table: create table sequence ( `Id` int, `Value` int not null, PRIMARY KEY (`Id`,`Value`) ); insert into sequence ( `Id`, `Value` ) values (10, 0 ), (10, 1 ), (10, 4 ), (10, 5…

mysql sql database gaps-in-data

asked Apr 30 '16 at 14:35

Krivers

1,986
2
22
45

vote

2 answers

R - combine vectors in data frame filling gaps in date

I have monthly observed and modeled data organized as vectors: obs <- structure(c(68.72228685137, 68.4565130874024, 68.3237563140977, 66.1789683147099, 63.7162100107148, 59.9698454002755), .Names = c("X1901.01.01", "X1901.02.01", "X1901.03.01",…

r vector merge dataframe gaps-in-data

asked May 05 '15 at 21:20

thiagoveloso

2,537
3
28
57

Prev 1

3 4 5 Next