Questions tagged [sliding-window]

In data analysis, sliding windows are advancing sub-lists inside lists which allow, e.g., computation of a record's change from the previous record or next record. In networking, a sliding window may refer to a flow control technique that maintains windows of sequential frames sent or received without a corresponding acknowledgement.

In data analysis, sliding windows are advancing sub-lists inside lists which allow, e.g., computation of a record's change from the previous record or next record. In SQL in particular, the analytic functions LEAD(), LAG(), and computations OVER() a changing subset of query results involve sliding windows.

In networking, a sliding window may refer to a flow control technique that maintains windows of sequential frames sent or received without a corresponding acknowledgement.

583 questions
0
votes
1 answer

Efficient image 2d sliding window max algorithm with hop > 1

The problem is similar to applying a sliding 2D window max filter over an M x N image. However, in contrast to the normal case, the sliding window does not simply slide over 1 pixel but instead by a k-pixel hop. So for example, if k = 2, the…
user1715925
  • 607
  • 9
  • 26
0
votes
1 answer

Date difference between records on the same table

I have this: SELECT journals.id, issues.created_on, user_id, journalized_id, journals.created_on FROM journals, issues where issues.id=journals.journalized_id and journalized_id=23363 It shows next result: id user_id journalized_id…
Newbie
  • 1
0
votes
2 answers

Can someone teach me how to show that these two time series correlate?

I have the following two time series : The x-axis is over 10000 values. Now, if I break them up into sliding windows, then I don't get a correlation since well, individually they aren't correlating. However, you can see that in the larger picture,…
gran_profaci
  • 8,087
  • 15
  • 66
  • 99
0
votes
1 answer

SQL Lag or Lead - How to select records based on row with a difference in a date/time field

I have a table with millions of records containing a date/time stamp - I am trying to return records that have a difference > a given number of seconds. The table contains a date/time stamp, but I am unable to use the where and the calculated…
Tanton
  • 1
  • 2
  • 2
0
votes
1 answer

popup sliding inwords from bottom right on page scroll down

I would like to have a popup emerging from bottom right once user has scrolled down the page completely. The popup can have read more links or related content links. I am using jquery framework library and php. I want the popup to have dynamic…
user1325759
0
votes
2 answers

Sliding Window on two image(main image and sub image) matrices

I'm new to matlab and am stuck with some stuff. it would be grateful if you can help me with it. i have to proceed with the sliding window technique. the main window is supposed to be a 40x40 matrix and the sub matrix i would want to slide through…
0
votes
1 answer

Creating a Go-back-N sliding window Client on java

I´m trying to create a Client in java to transfer files over UDP using a Go-back-N sliding window. I'm using a TftpPacket, but that's not relevant for the question. My problem its how am I able to make the acknowledge control. Example: Have a file…
Vitor Mexia
  • 69
  • 2
  • 10
0
votes
2 answers

Receive an unknown number of UDP messages

Let's say a source A is sending me an unknown number of messages using UDP. How can I intercept all those messages? This is the complete scenario: Send 7 messages Wait for their ACKs Process ACKs Send another batch Repeat... Problems: (1) I don't…
ToniAz
  • 430
  • 1
  • 6
  • 24
0
votes
1 answer

c - Extracting comments and strings - edited

This is an edited, corrected, more specific version of a previous question of mine. So I'm doing a homework assignment where we have to use a sliding window to print the comments and strings from an input file coming from the stdin. I am very close…
Mike Weber
  • 179
  • 1
  • 1
  • 10
0
votes
1 answer

How to use lead() and lag() on varchar2 fields?

Oracle 11g My work so far on SQL Fiddle I'm using lead() and lag() functions on varchar2 columns. Using the following rules, I'd like to generate the desired results. If lag_val is null then '(' If lag_val is same as set_a then 'and' If lag_val…
zundarz
  • 1,540
  • 3
  • 24
  • 40
0
votes
2 answers

Taking the sum of a sliding window of indices in python

I have looked around but have been unable to find out why my code is failing, and how to do it right. I'm new (3 days) to coding, so forgive my noobishness. I start with a list of integers, and essentially I want to make a new or updated list…
0
votes
2 answers

Reuse an XML layout file to show different information (Android Application)

I’m new to Android and have a simple question. Currently I’m working on a products application that allows users to add, remove and browse variety of products. The application uses a predefined XML-based layout file as a template that fills the…
0
votes
0 answers

Sliding "cards" effect -- slides out, but not in

I'm using the following code to create a sliding card effect where each "card" is a list element and they slide across the screen. They are only visible within the "stage" I've set with specific height and width. It's working great -- except that,…
-1
votes
2 answers

sliding window on a vector, and multiplying matrix (python)

I would like to multiply sections of a 1D array by a matrix. lets assume a large 1D array size 1xN, and a nxn matrix (such as n
Rana
  • 1
  • 1
-1
votes
1 answer

Count Subarrays with Target Sum

Can anyone help me understand what this piece of code does? His logic, what is the output etc // currsum exceeds given sum by currsum // - sum. Find number of subarrays having // this sum and exclude those subarrays // from currsum by increasing…