Advertisements Let say I have a Sequence<Int> of unknown origin (not necessarily from a collection) and unknown but finite size: val seq = sequenceOf(1, 2, -3, 4, 5, /* … */) Assume the sequence is large enough to make it undesirable to turn the whole sequence into a List. I want to get the last… Read More Last element of sequence but with a break if a condition is met

Advertisements I need to create a sequence from 1 to let’s say 100 (it doesn’t matter), with alternating step size not following any particular distribution or rule. The exact step size can only be defined by a numerical vector: vec <- c(1,1,2,1,3,1,1,1,1,4,1) How do I end up with the following sequence out of the above… Read More Sequence with varying step size defined by a vector

Advertisements I am a beginner in Python. I am learning currently how to Modify an element with index MyCode: data = [4, 6, 8] for index, value in enumerate(data): data[index] = data[index] + 1 value = value * 2 print(data) print(value) Terminal Output: [5, 7, 9] 16 Terminal Output Expectation: [5, 7, 9] [8, 12,… Read More Modifying Element with Index in Python

Advertisements I can produce the list [0, 2, 6, 12, 20, 30, 42, 56, 72, 90] using the following code: x = [] y = 0 for i in range(2,21,2): x.append(y) y += i However I’m not sure how to convert this into list comprehension syntax of the form [expression for value in iterable if… Read More Produce this list [0, 2, 6, 12, 20, 30, 42, 56, 72, 90] using list comprehension syntax

Advertisements How can I calculate col2? col2 should increment each time a value in col1 appears after being interrupted by a different value, e.g. creating a grouping variable that changes every time a new sequence starts. structure(list(col1 = c("A", "A", "A", "A", "B", "B", "B", "C", "C", "C", "C", "A", "A", "E", "E", "E", "F",… Read More How to increment non consecutive duplicated groups

Advertisements I need to generate "ID" in quantity which is given in "quantity" column. I use the formula "=ArrayFormula(TOCOL("T"&TEXT( sequence(C2);"00")&""&$A2&"|"&$B2))". It generates ID only for the first product. How to generate IDs for the entire ID array? Example file >Solution : You may try: =tocol(map(A2:A;B2:B;C2:C;lambda(a;b;c;if(counta({a\b\c})<>3;;index("T"&text(sequence(1;c);"00")&a&"|"&b))));1)

Advertisements I am having A dataset of Three columns ID , ‘sort_seqandlevel. basically i want to identify id wise level sequence sort by sort_seq. please suggest any optimal code other then for loop` because it is taking longer time with dictionary and appending in list. Input Dataset import pandas as pd import numpy as np… Read More Creating a pattern in a sequence for groupby in pandas

Advertisements I have the following data:- x <- c(F, T, T, T, F, T, T, T, T, T) names(x) <- letters[1:10] y <- c(T, F, T, T, T, F, T, T, T, T) names(y) <- letters[1:10] z <- c(T, T, F, T, T, T, T, T, F, F) names(z) <- letters[1:10] a <- c(T, T,… Read More Check for 5 consecutive TRUE values from the back of a vector

Advertisements I need to delete duplicates from xml + set correct sequence i.e. 10, 20, 30 etc. My xml: <?xml version="1.0" encoding="UTF-8"?> <serviceInvocationRequests> <serviceInvocationRequest> <requests> <workCenter>04901</workCenter> <description>Some random description</description> <resourceMemberList> <resource>R4902A01</resource> <sequence>10</sequence> </resourceMemberList> <resourceMemberList> <resource>R4902A02</resource> <sequence>10</sequence> </resourceMemberList> <resourceMemberList> <resource>R4902A01</resource> <sequence>10</sequence> </resourceMemberList> <resourceMemberList> <resource>R4902A02</resource> <sequence>10</sequence> </resourceMemberList> </requests> </serviceInvocationRequest> </serviceInvocationRequests> My xslt for deleting duplicates: (currently works… Read More XSLT: delete duplicates + set sequence

Advertisements Imagine I have the following dataframe: ID Start Date 1 1990-01-01 1 1990-01-01 1 1991-01-01 2 1991-01-01 2 1990-01-01 3 2002-01-01 3 2000-01-01 4 1991-01-01 What would be the best way to create a column named Order that, for each unique ID in the ID column, starting with 1 with the earliest Start Date… Read More Create column that orders ID by first Start Date