Abstract: A user selects a node that specifies an operation for a dataset. In response, a computer system displays data values for the dataset, in a grid in a data pane. The grid includes a first column and a second column. In the grid, the user edits a first data value in the first column in a first row. The user input changes the first data value to a replacement data value. The computer system identifies a second data value in the second column in the first row, and identifies one or more additional rows in the grid, whose data values for the first column and the second column match the first data value and the second data value. The computer system then updates the data value in the first column for a second row in the grid to the replacement data value.

Abstract: A user interface displays: a first column comprising non-editable input strings retrieved from a data field; a second column comprising editable output strings initialized from the data field; and an expression window displaying a transformation function ƒ. The computer iteratively processes user inputs, each user input i providing a sample row transformation to edit an ith output string ti. Some user inputs i designate a contiguous substring ssi of the corresponding input string si. The contiguous substring expresses a causal basis for transforming the input string si. into the output string ti. The computer updates the transformation function ƒ according to the provided sample row transformations so that: ƒ(s1)=t1, . . . , ƒ(si)=ti; the transformation function ƒ specifies text or string position of at least one contiguous substring; and ƒ has minimal branching among possible transformation functions that satisfy the samples.

Abstract: A user selects a node that specifies an operation for a dataset. In response, a computer system displays data values for the dataset, in a grid in a data pane. The grid includes a first column and a second column. In the grid, the user edits a first data value in the first column in a first row. The user input changes the first data value to a replacement data value. The computer system identifies a second data value in the second column in the first row, and identifies one or more additional rows in the grid, whose data values for the first column and the second column match the first data value and the second data value. The computer system then updates the data value in the first column for a second row in the grid to the replacement data value.

Abstract: A method prepares data for subsequent analysis. The method displays a user interface that includes a plurality of panes, including a data flow pane and a data pane. The data flow pane includes a flow diagram having a plurality of nodes, each node specifying a respective primary operation or specifying a plurality of secondary operations to clean a respective data set. The data pane includes a plurality of data values in rows and columns. The data values correspond to a selected node in the data flow pane. A first user input selects a first data value in a first column and receives a second user input to edit a second data value in a second column according to one or more predefined conditions. The method then highlights the second column. When the predefined conditions are met, the method changes the second data value to a replacement data value.