Various systems and methods provide an intuitive user interface that enables automatic specification of queries and constraints for analysis by ML component. Various implementations provide methodologies for automatically formulating machine learning (“ML”) and optimization queries. The automatic generation of ML and/or optimization queries can be configured to use examples to facilitate formulation of ML and optimization queries. One example method includes accepting input data specifying variables and data values associated with the variables. Within the input data any unspecified data records are identified, and a relationship between the variables specified in the input data and a variable associated with the at least one unspecified data record is automatically determined. The relationship can be automatically determined based on training data contained within the input data. Once a relationship is established a ML problem can be automatically generated.
Please help me write a proper abstract based on the patent claims. CLAIM: 1. A computer implemented method for automatically generating machine learning problems, the method comprising: accepting, by a computer system, input data specifying variables and data values associated with the variables; identifying, by the computer system, at least one unspecified data record within the input data; determining, automatically, by the computer system, a relationship between the variables specified in the input data and a variable associated with the at least one unspecified data record, based on training data contained within the input data; and generating, automatically, by the computer system a machine learning problem including the relationship between the variables and the training data. 2. The method according to claim 1, further comprising solving, automatically by the computer system, the machine learning problem to provide a result value for the at least one unspecified data record within the input data. 3. The method according to claim 2, further comprising assigning a function for calculating the result value to the at least one unspecified data record. 4. The method according to claim 1, further comprising displaying, by the computer system the machine learning problem. 5. The method according to claim 1, wherein accepting the input data includes accepting within a spreadsheet display of variables and data values selection of a group of the variables, the data values, and the at least one unspecified data record. 6. The method according to claim 5, wherein identifying, determining, and generating occur in response to selection of the group. 7. The method according to claim 2, further comprising determining a confidence value associated with the result value. 8. The method according to claim 7, further comprising encoding, visually, the confidence level associated with the result value. 9. The method according to claim 8, wherein encoding visually the confidence level associated with the result value includes displaying a value having a high relative confidence value bolder than a value having a lower relative confidence value. 10. The method according to claim 1, further comprising converting categorical values from the input data into set membership binary values. 11. The method according to claim 1, wherein generating, automatically, by the computer system the machine learning problem including the relationship between the variables and the training data, includes generating the machine learning problem based on symbolic regression. 12. The method according to claim 1, wherein generating, automatically, by the computer system, the machine learning problem includes: generating one or more possible query patterns that relate a blank cell in a spreadsheet to its surrounding non-blank cells, collecting data from the spreadsheet that matches that pattern, running a ML algorithm to find a model and determine its confidence level, and selecting the model having the highest confidence level. 13. The method according to claim 12, further comprising filling in values in all blank cells that fit the query pattern using the selected model with the highest confidence level. 14. The method according to claim 12, wherein generating one or more possible query patterns includes generating possible patterns including both absolute cell positions and cell positions that are relative to the at least one unspecified data record in a spreadsheet. 15. The method according to claim 2, further comprising identifying at least one second unspecified data record, and calculating a result value for the at least one second unspecified data record according to the input data and the result value for the at least one unspecified data record. 16. The method according to claim 1, wherein generating, automatically, by the computer system the machine learning problem including the relationship between the variables and the training data includes automatically formulating prediction queries to fill in the at least one unspecified data record. 17. The method according to claim 16, wherein the at least one unspecified data record is at least one blank cell in a spreadsheet, and wherein the prediction query is generated based on the relationship between the at least one blank cell and cells having data values. 18. The method according to claim 1, wherein generating, automatically, by the computer system the machine learning problem including the relationship between the variables and the training data includes automatically formulating at least one optimization query to fill in the at least one unspecified data record. 19. The method according to claim 18, wherein the at least one unspecified data record is at least one blank cell in a spreadsheet, and wherein the optimization query is generated based on the relationship between the at least one blank cell and cells having data values. 20. The method according to claim 18, wherein generating, automatically, by the computer system a machine learning problem including the relationship between the variables and the training data includes: generating a model that relates a target value to the blank value; and performing a search to identify the optimal value of the blank cells that minimize the difference between the target value and the value predicted by the model. 21. The method according to claim 20, further comprising holding constant at least some of the non-blank cells corresponding to independent variables as search constraints. 22. The method according to claim 20, wherein multiple target values are optimized simultaneously using a multi-objective optimization technique. 23. The method according to claim 1, further comprising accepting constraints defined against the at least one unspecified data record. 24. A system for automatically generating machine learning problems, the system comprising: at least one processor operatively connect to a memory, the at least one processor when executing is configured to: accept input data specifying variables and data values associated with the variables; identify at least one unspecified data record within the input data; determine, automatically, a relationship between the variables specified in the input data and a variable associated with the at least one unspecified data record, based on training data contained within the input data; and generate, automatically, a machine learning problem including the relationship between the variables and the training data. 25. The system according to claim 24, wherein the at least one processor is configured to solve, automatically, the machine learning problem to provide a result value for the at least one unspecified data record within the input data. 26. The system according to claim 25, wherein the at least one processor is configured to assign a function for calculating the result value to the at least one unspecified data record. 27. The system according to claim 24, wherein the at least one processor is configured to display the machine learning problem. 28. The system according to claim 24, wherein accepting the input data includes accepting within a spreadsheet display of variables and data values a selection of a group of the variables, the data values, and the at least one unspecified data record. 29. The system according to claim 28, wherein identifying, determining, and generating occur in response to selection of the group. 30. The system according to claim 25, wherein the at least one processor is configured to determine a confidence value associated with the result value. 31. The system according to claim 30, wherein the at least one processor is configured to encode, visually, the confidence level associated with the result value. 32. The system according to claim 31, wherein encoding visually the confidence level associated with the result value includes displaying a value having a high relative confidence value bolder than a value having a lower relative confidence value. 33. The system according to claim 24, wherein the at least one processor is configured to convert categorical values from the input data into set membership binary values. 34. The system according to claim 24, wherein the at least one processor is configured to generate the machine learning problem based on symbolic regression. 35. The system according to claim 24, wherein the at least one processor is configured to generate one or more possible query patterns that relate a blank cell in a spreadsheet to its surrounding non-blank cells, collect data from the spreadsheet that matches that pattern, execute a ML algorithm to find a model and determine its confidence level, and select the model having the highest confidence level. 36. The system according to claim 35, wherein the at least one processor is configured to fill in values in all blank cells that fit the query pattern using the selected model with the highest confidence level. 37. The system according to claim 35, wherein the at least one processor is configured to generate possible patterns including both absolute cell positions and cell positions that are relative to the at least one unspecified data record in a spreadsheet. 38. The system according to claim 25, wherein the at least one processor is configured to identify at least one second unspecified data record, and calculate a result value for the at least one second unspecified data record according to the input data and the result value for the at least one unspecified data record. 39. The system according to claim 24, wherein the at least one processor is configured to automatically formulate prediction queries to fill in the at least one unspecified data record. 40. The system according to claim 39, wherein the at least one unspecified data record is at least one blank cell in a spreadsheet, and wherein the prediction query is generated based on the relationship between the at least one blank cell and cells having data values. 41. The system according to claim 24, wherein the at least one processor is configured to automatically formulate at least one optimization query to fill in the at least one unspecified data record. 42. The system according to claim 41, wherein the at least one unspecified data record is at least one blank cell in a spreadsheet, and wherein the optimization query is generated based on the relationship between the at least one blank cell and cells having data values. 43. The system according to claim 41, wherein the at least one processor is configured to generate a model that relates a target value to the blank value; and perform a search to identify the optimal value of the blank cells that minimize the difference between the target value and the value predicted by the model. 44. The system according to claim 43, wherein the at least one processor is configured to hold constant at least some of the non-blank cells corresponding to independent variables as search constraints. 45. The system according to claim 43, wherein the at least one processor is configured to optimize multiple target values simultaneously using a multi-objective optimization technique. 46. The system according to claim 24, wherein the at least one processor is configured to accept constraints defined against the at least one unspecified data record.