python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sequence

Creating high and low balance calculations from a dataset

I have a list of currency trades, and from this I need to calculate the high and low points of the balance of each currency. I have created a simple example in the Sheet below: https://docs.google.com...
test-img

Dan

if-statement

google-sheets

google-sheets-formula

sequence

flatten

Votes: 0

Answers: 1

Latest Answer

try: =INDEX(QUERY({QUERY(FLATTEN({B2:B, D2:D}), "where Col1 is not null", ), MMULT(--TRANSPOSE(IF((SEQUENCE(1, COUNTA(A2:A)*2)>=SEQUENCE(COUNTA(A2:A)*2))*( QUERY(FLATTEN({B2:B, D2:D}),...
test-img

player0

Generate sequence in Oracle based on length of column

I need to generate sequence in Oracle based on length of column and incremental of 2. For example: Select comp_name from table_a Output: COGNIZANT So I need to generate sequence: Generate_sequence ( ...
test-img

Santhosh reddy

oracle

function

output

sequence

Votes: 0

Answers: 1

Latest Answer

You can create the user-defined function: CREATE FUNCTION generate_series( i_start IN NUMBER, i_end IN NUMBER, i_step IN NUMBER DEFAULT 1 ) RETURN SYS.ODCINUMBERLIST PIPELINED DETERMINISTIC I...
test-img

MT0

How to determine if sequence is within the list of ints?

I am having trouble when running a python program. The purpose is to determine whether the sequence 1, 2, 3 is within a given list of ints. When it runs two of the tests, the code works. However, the ...
test-img

anthonyvn

python

list

sequence

traversal

Votes: 0

Answers: 3

Latest Answer

Remove sorted() from s = ''.join(str(i) for i in sorted(nums)) sorted() sorts the list and puts in ascending order So in your case [1, 1, 2, 1, 2, 3] is converted to '111223' when used sorted(), there...
test-img

Polymath

R: short and effective code for a sequence of lm models from DOE factors

Background: I have several responses as output from an DOE and want to model each one. First and of course successfull try was to simply write a long code for each model. formula<- y~a+b+c+d+a:b+a:...
test-img

Marcel

r

sequence

paste

Votes: 0

Answers: 1

Latest Answer

This would be one way: # Define formula formula<- y~a+b+c+d+a:b+a:c+a:d+b:c+b:d+c:d+I(a^2)+I(b^2)+I(c^2)+I(d^2) # Define a function that takes the x:th variable my_reg <- function(x, formula, da...
test-img

Baraliuh

Posts

Questions

Blogs

Jobs