I have a
df 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|
Let's say 20 such records are generated in each state every month and there are 37 different state codes and 8 different category codes. 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.