Databases
StackOverflow2013
Postsdbo
POFinding patterns in these numbers
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFinding patterns in these numbers
    text
    copied!<p>I am currently working on a project. In this project I have set of data which follows particular algorithm. I have to find the pattern.</p> <pre><code> 1 355138022809833 RUPQ730562P 247001 20578330 70175500 2 355138022809841 RUPQ730563D 247001 72754950 71957850 3 355138023475287 RVSQ831978E 247001 39374170 25101090 4 355138023475295 RVSQ831979F 247001 06260280 87190670 5 355138023475303 RVSQ831980L 247001 05025410 26440510 6 355138023475352 RVSQ831985Y 247001 96637700 48209200 7 355138023475360 RVSQ831986A 247001 27362620 70790740 8 355138023475378 RVSQ831987P 247001 16576600 30002180 9 355138023475386 RVSQ831988D 247001 74778020 98010580 10 355138023475402 RVSQ831990M 247001 25716170 97946520 </code></pre> <p>First column is the serial number. Next 3 columns are the input which will be given. Next 2 are the output of the algorithm.</p> <p>So basically </p> <p>I have 3 variables x, y, z (2nd, 3rd, 4th column of above data)</p> <p>And </p> <pre><code>y1 = f1(x, y, z) y2 = f2(x, y, z) </code></pre> <p>y1 is 5th column of above data</p> <p>y2 is 6th column of above data</p> <p>I have above data. Now I need to find function f1 and f2.</p> <p>What procedure should I follow? What steps must be taken? </p> <p><strong>EDIT 1 by Krishna Kant Sharma</strong> </p> <p>I posted this question to not to ask for the answering algorithm. I just asked for the steps necessary to take, to solve these kinds of problem, when we have alphabets in variables too. This is the first time, in my experience, some small portion of stackoverflow community have acted like closed minded people. Whats the whole point of stackoverflow? We are here to help each other understand and resolve problems. To lend a helping hand when some of us need it. So why dont we stop beating around some technical pureness (like alphabets are not alphabetical characters), and solve the main problem. </p> <p><strong>More Data</strong></p> <pre><code>11 355138023475436 RVSQ831993L 247001 07481830 49057990 12 355138023475444 RVSQ831994T 247001 65090950 87729430 13 355138023475451 RVSQ831995B 247001 06689330 60021180 14 355138023475469 RVSQ831996K 247001 05784310 69836640 15 355138023475477 RVSQ831997Z 247001 13157740 35850670 16 355138023475485 RVSQ831998Y 247001 68658020 77311320 17 355138023475501 RVSQ832000N 247001 01567780 26994970 18 355138023475519 RVSQ832001E 247001 43775370 58120770 19 355138023475527 RVSQ832002F 247001 42463550 55145190 20 355138023475535 RVSQ832003R 247001 85766840 15491950 </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload