CPC G06F 16/287 (2019.01) [G06F 3/0482 (2013.01); G06F 16/221 (2019.01); G06F 16/252 (2019.01); G06F 16/9024 (2019.01)] | 20 Claims |
1. A method for preparing data for subsequent analysis, comprising:
at a computer system having one or more processors and memory storing one or more programs configured for execution by the one or more processors:
receiving, in a data flow pane, user selection of a node that specifies an operation for a data set;
in response to the selection of the node, displaying data values for the data set corresponding to the node, in a grid in a data pane, the grid including a first column and a second column;
receiving a user input in the grid to edit a first data value in the first column in a first row of the grid, changing the first data value to a replacement data value;
identifying a second data value in the second column in the first row;
generating a rule that maps the first data value to the replacement data value for each row of the grid in which a data value in the first column matches the first data value and a data value in the second column matches the second data value;
inserting a respective node, into the data flow pane, that specifies a respective operation that performs the generated rule;
identifying one or more additional rows in the grid, other than the first row, whose data value for the first column matches the first data value and whose data value for the second column matches the second data value; and
updating, automatically in accordance with the generated rule, a respective data value in the first column in a second row of the one or more additional rows in the grid to the replacement data value.
|