Test Data Set Creation Program - R (preferable)
Budget: $30 – $250 USD
We have a series of excel tables with input and output data (Example Table 1). We need to create test sets for these tables that contain every possible permutation of the inputs in each column of the table. We are converting from an old system to a new system and we need to run these test sets in both systems. We need a program to create these test sets given an excel table (we will have hundreds of these).
I've included three files. The first (Example Table 1.xlsx) is what the data looks like initially. It has several columns of input data contained in rows below and then an output column. What I need is to create arrays of all the unique inputs for each column. I've added a formula to the bottom of the rows that trys to capture all the unique values in the columns above, but this still will need to be cleaned up some an then fed into the R program below.
The second file is an R program that shows how to create each possible permutation of all the input values. This program outputs the results to an excel spreadsheet testset2.xlsx.
So, ultimately I need a spreadsheet file that has every possible permutation of the input values in the excel table. How I get that file I really don't care but would prefer it in R so that we can tweak it if needed. I'd be happy to answer any questions. We will need to be creating a lot of test sets with these spreadsheets. Ideally would be to have the R program input the spreadsheet file, do the data wrangling to find the unique values in each column and then to create the output of all possible permutations in order for us to test.
I've included three files. The first (Example Table 1.xlsx) is what the data looks like initially. It has several columns of input data contained in rows below and then an output column. What I need is to create arrays of all the unique inputs for each column. I've added a formula to the bottom of the rows that trys to capture all the unique values in the columns above, but this still will need to be cleaned up some an then fed into the R program below.
The second file is an R program that shows how to create each possible permutation of all the input values. This program outputs the results to an excel spreadsheet testset2.xlsx.
So, ultimately I need a spreadsheet file that has every possible permutation of the input values in the excel table. How I get that file I really don't care but would prefer it in R so that we can tweak it if needed. I'd be happy to answer any questions. We will need to be creating a lot of test sets with these spreadsheets. Ideally would be to have the R program input the spreadsheet file, do the data wrangling to find the unique values in each column and then to create the output of all possible permutations in order for us to test.