Stack Overflow
Stack Overflow

Questions tagged [sequential-number]

50 questions
1
vote
2 answers

Sequential Increase in Column value based on a condition R

I have an R data frame that has an ID column with multiple records for an ID. When the flag is set to 1 for an ID, I want to create a column new timeline that starts from 1 and increases sequentially in increments of 6 (1,6,12...). How can I achieve…
Datamaniac
  • 171
  • 2
  • 9
1
vote
1 answer

Sequential numbering based on another column (date) R

I need to make a column with sequential numbers based on the date. There are multiple rows of the same date, and should look like so: nest in.temp out.temp age date 1 501 (913) 18.0 11.5 0 06/02 2 501 (913) 17.5 12.0 0…
Emily Phillips
  • 13
  • 2
1
vote
4 answers

Generate unique semi random numeric strings

I want to generate 10k of unique numbers composed of a sequential number (16 digits) followed by a random numeric string (4 digits). Weapon of choice is Powershell because it's the only tool I have a very limited knowledge of. Problems…
knuckle_sandwich
  • 207
  • 1
  • 6
  • 12
1
vote
1 answer

Number of occurrences of next value in a vector in R

I have a vector with random numbers from 1-7 and I want to be able to determine the next number in the vector that follows the first value so that I can look for patterns and get a 7x7 matrix of values that shows how often a specific number follows…
AtmoSci
  • 87
  • 1
  • 1
  • 7
1
vote
1 answer

Excel scatter plot x axis displays only sequential numbers but not real data selected for x axis

I have an excel scatter plot with 5 different data series on single chart. First 4 series are working well. When I want to add a new series with similar x-axis data (0.0, 0.4, 0.9 .. ) the plot is displayed with x-axis values as 1,2,3 but not as the…
santu
  • 51
  • 1
  • 9
1
vote
3 answers

Generate sequential numbers between 0 and 1 with equal distance

I am generating random variables in my array: np.random.rand(5,3,20) How can I create the same shape and size but sequentially between 0 and 1?
jacky
  • 524
  • 1
  • 5
  • 15
1
vote
1 answer

Is sequential or random comparison more efficient?

I am wondering (purely out of curiosity) if it is more efficient to compare numbers sequentially or randomly. I initially thought that it would be more efficient to compare numbers sequentially, but I was not sure and I have know idea how I would go…
zoecarver
  • 5,523
  • 2
  • 26
  • 56
1
vote
1 answer

How to make auto numbering on UITextview when press return key in swift

When user press [Return] key then need to display the number. Like serial numbers [1,2 etc] for each line.Is there any way to do that? Following code I tried func textView(_ textView: UITextView, shouldChangeTextIn range: NSRange, replacementText…
Lydia
  • 2,017
  • 2
  • 18
  • 34
1
vote
1 answer

SQL Server query add sequential number to resuls

I have emergency contact information attached to contact records that I am making into their own contact records. I need to assign a temporary id to the new contact records for migration purposes. I was hoping to do this within my SQL query that…
db Neophyte
  • 13
  • 3
0
votes
1 answer

is there a way to select only records with ingredient numbers of 3 or more

I have a table of compound ingredients. depending on the product each product may have more than one ingredient number: Product Ingred No A 1 B 1 B 2 C 1 C 2 C 3 D 1 D 2 D 3 D 4 I only want to select products with 3 or…
angelo
  • 5
  • 2
0
votes
1 answer

MS ACCESS table default value code line for autogenerated sequential and unique alphanumeric number

I am new to MS Access and I would like to generate an autogenerated sequential and unique alphanumeric number of the format SYYMM001, SYYMM002, SYYMM003... (ex for 2023 january: S2301001, S2301002, S2301003). I use MS Access 2016. I am in my table,…
Seashade
  • 1
0
votes
1 answer

I need to name sequential images that are being capured from a video in order to procees them, sort them, and rebuild the video again. (Python)

I have a script in Python that captures frames from a video, then an ML model detects objects, and draws the bounding boxes on the frame. The scrip names each captured frame like "img" + secuencial_counter, and save them in the same folder. When I…
Pablo Biosca
  • 1
  • 1
0
votes
1 answer

SQL create a dynamic sequential number in a select statement based on a SortOrder

I want to generate a new column with a sequential number based on a data column SortOrder. The Sortorder is returned from a subquery, where I manually mapped floor designations of buildings. Building Floor SortOrder BuildingA 1.…
Waren Schild
  • 13
  • 3
0
votes
1 answer

SQL Grouping in sequence & Sequential ID for group

I have below SQL database and would like to group them in sequence and assign ID to each group. Time Line Colour 2021-11-02 3:00:00PM 1 Black 2021-11-02 3:00:01PM 1 White 2021-11-02 3:00:02PM 1 Red 2021-11-02…
s9yu
  • 9
  • 1
0
votes
2 answers

Renaming attributes result using sequential values

I'm facing a challenge with SVG attributes results. I need to rename several of the results of the SVG attribute in a sequential form. xlink:hreef-"#path-1" xlink:hreef-"#path-2" xlink:hreef-"#path-3" ... How can I automatize it? Exist a plugin or…
Luiz Alves
  • 1
1
2
3 4