I am trying to remove some data from graphs due to a fault in the measurement equipment at certain time increments and also differentiate between two sections of the data. I have attached an image and file to help with solving this problem.
The blue oval of data needs to be removed and the red data needs to be differentiated from the rest of the data.
Can someone recommend ways to do this?
Thank you for the help.
I believe that by using the Lasso tool you can select the data points from the graph, and since the selected points are reflected in the data table as selected rows, you can then do simple data table manipulations to get done what you want.
1. Select the Lasso tool
2. Lasso all of the data points you show in your chart as being in the Blue Oval.
3. Go to the data table's RowState Column(the column that has the row numbers in it). Right click on one of the rows that has been selected by your Lasso tool, and select "Hide and Exclude", or if you want, you can select "Delete Rows".
For the second issue of Binning:
1. Create a new Column in the data table, and make it a character data type
2. In row one of the new type in the value you want to use to indicate for the rows shown in the red oval on your chart.
3. Copy that value into the Paste buffer, and then erase the value from row 1. We did this operation just to get the value into the paste buffer.
4. Now go to the graph, and select the Lasso tool, and Lasso all of the data points from the red oval.
5. Go to the data table which now has all of the rows selected for the points in the red oval. Hover over one of the cells(rows) in the new column that has been selected.
6. Right click and select "Paste"
7. All of the selected cells for the new column will now have the value you placed into the paste buffer.
Don't forget about the Rows->Row Selection->Name Selection in Column option. This will let you select points in any graph and then quickly create a column to assign the selected (and unselected) rows to a category.
How to group points in a plot and assign categories in data table (3 or more categories) has a nice video showing how to use Name Selection in Column.
I am sorry that wasn't clearer before. I have hundreds of these graphs and am trying to find a less manual way of finding the outliers and peak values. If you open up the attached document, you can see a small set of the data that I am working with and the variations in the runs.
There are no labels assigned to this post.