The subject matter described herein relates to table detection in a spreadsheet. According to implementations of the subject matter described herein, there is proposed a solution for determining a table in a spreadsheet. In the solution, respective multiple attributes of multiple cells comprised in the spreadsheet may be extracted. Respective features of the multiple cells may be determined based on the extracted multiple attributes. The multiple cells may be divided into at least one candidate area based on the features. At least one candidate table in the spreadsheet may be determined based on the at least one candidate area. By means of the solution, respective features of the multiple cells comprised in the spreadsheet may be determined based on the respective attributes of the multiple cells, and further, a candidate region where a table might exist may be determined based on the respective features of the multiple cells.

Described are methods, systems and computer readable media for dynamic updating of query result displays.

Described are methods, systems and computer readable media for dynamic updating of query result displays.

In an embodiment, a data processing method comprises accessing a computer memory comprising a shareable cell-based computation notebook comprising: notebook metadata specifying a kernel for execution, and a computational cell comprising cell metadata, a source code reference, and an output reference, wherein the cell metadata identifies a particular version of source code of a function that defines an input dataset, a transformation, and one or more variables that are to be associated with output data that is to be generated as a result of executing the particular version of the source code; updating the source code reference to identify a first storage location that is to contain the particular version of the source code of the function; and updating the output reference to identify a second storage location that is to contain the output data that is to be generated as a result of executing the particular version of the source code identified in the cell metadata using the kernel specified in the notebook metadata, wherein the method is performed by one or more computing devices.

In an embodiment, a data processing method comprises accessing a computer memory comprising a shareable cell-based computation notebook comprising: notebook metadata specifying a kernel for execution, and a computational cell comprising cell metadata, a source code reference, and an output reference, wherein the cell metadata identifies a particular version of source code of a function that defines an input dataset, a transformation, and one or more variables that are to be associated with output data that is to be generated as a result of executing the particular version of the source code; updating the source code reference to identify a first storage location that is to contain the particular version of the source code of the function; and updating the output reference to identify a second storage location that is to contain the output data that is to be generated as a result of executing the particular version of the source code identified in the cell metadata using the kernel specified in the notebook metadata, wherein the method is performed by one or more computing devices.

Described are methods, systems and computer readable media for performance logging of complex query operations.

Aspects of the present disclosure relate to systems and methods for automatically constructing a new formula based upon an existing formula. Various methods are employed to analyze an existing formula in order to determine an intent. Once the intent is determined, a new formula may be constructed that satisfies the intent of the existing formula. Further aspects relate to validating the new formula to ensure it produces the same result as the existing formula which it is intended to replace. Various user interface elements are also disclosed which may be employed to provide the newly constructed formulas to users of an application. The various aspects to disclosed herein may be performed by an application, such as a spreadsheet application, performed in real-time, or provided as a remote service.

A computer readable medium includes a data set with data stored in rows and N columns. Each of the rows is associated with one individual patient. Each of the N columns is associated with one type of data for patients. One or more processors is configured to: initialize missing values in M ones of the N columns with M values for the M ones of the N columns, respectively; generate M mathematical models for the M ones of the N columns having one or more missing values; for each of the rows having one or more missing values, update ones of the M values for the M ones of the N columns; and fill missing values in the M ones of the N columns with the M values, respectively.

A computer readable medium includes a data set with data stored in rows and N columns. Each of the rows is associated with one individual patient. Each of the N columns is associated with one type of data for patients. One or more processors is configured to: initialize missing values in M ones of the N columns with M values for the M ones of the N columns, respectively; generate M mathematical models for the M ones of the N columns having one or more missing values; for each of the rows having one or more missing values, update ones of the M values for the M ones of the N columns; and fill missing values in the M ones of the N columns with the M values, respectively.

A method includes receiving, via a user interface of a device associated with a user, a request to populate one or more cells of a plurality of cells of a document having a tabular structure, wherein the one or more cells correspond to a first attribute pertaining to a first column and a first object pertaining to a first row; analyzing the request to obtain contextual information indicating the first attribute and the first object; generating a query based at least in part on the contextual information; initiating an execution of the query to obtain a response using one or more data sources; causing the user interface to be modified to populate the response in the one or more cells corresponding to the first attribute and the first object; determining second contextual information based on the response, the second contextual information indicating a second attribute and a second object; generating a second query based at least in part on the second contextual information; initiating an execution of the second query to obtain a second response using one or more data sources; and causing the user interface to be modified to populate the second response in one or more cells corresponding to the second attribute and the second object.