Question

Generate numbers(.csv) from 1 to 13563 in these following pattern

1 1 1 1 1 2 2 2 2 2 3 3 3 3 3 4 4 4 4 4 5 5 5 5 5 .................................1000 1000 1000 1000 1000

Can use any language, even excel too. Just need .csv file.

Answer 1

Below is a code in python3 that generates the numbers and stores it in a .csv file separated by ","

#CODE STARTS HERE------------

import numpy as np #using numpy module to store array of numbers to .csv
x=13563 #set the upper limit
li=[] #list to store all numbers
for y in range(1,x+1): #loop to generate all numbers
   for _ in range(5): #loop to store each number 5 times
      li.append(y) #adding numbers to the list
print(*li) #print list for confirmation
np.savetxt("file_numbers.csv", [li], delimiter=",",fmt='%s') #store in .csv

#CODE ENDS HERE----------------

Below is a screenshot to check the indentation of the code:

Below is the output in the IDE. NOTE: The output numbers continue till 13563.

Below is the screenshot of the file_numbers.csv file. NOTE: The numbers continue till 13563.