I have a dfdf
which has a serial number generated with each new record. The serial number combines with some other part like state code, year of registration and category code. So it has a format like below:
| DOR | Applicant's code |
|:---- |:------:|
|1-2-2018| MH2018-PAR-0689|
|1-2-2018| MH2018-PAR-0689|
|2-2-2018| MH2018-PAR-0690|
|2-2-2018| MH2018-OMC-0691|
|1-2-2018| UP2018-OMC-2461|
|1-2-2018| UP2018-FPR-2462|
|3-2-2018| UP2018-PAR-2463|
|1-2-2018| UP2018-OMC-2462|
Lets
| DOR | Applicant's code |
|:-------|:--------------:|
|1-2-2018| MH2018-PAR-0689|
|1-2-2018| MH2018-PAR-0689|
|2-2-2018| MH2018-PAR-0690|
|2-2-2018| MH2018-OMC-0691|
|1-2-2018| UP2018-OMC-2461|
|1-2-2018| UP2018-FPR-2462|
|3-2-2018| UP2018-PAR-2463|
|1-2-2018| UP2018-OMC-2462|
Let's say 20 such records are generated in each state every month and there are 37 different state codes and 8 different category codecodes. I want to create a list of all possible Applicant's codes for next month which should be 37 x 1 x 8 x 20 possible values. I need guidance on how to code it with python and also if my approach is correct.