| T O P I C R E V I E W |
| Amad |
Posted - 03/22/2017 : 11:52:30 AM
Hi,
I have many negative data points on a table. I would like to remove all those values wich are noise induced.
I know about the "Data->Remove Bad Data Points" method which allows to remove them manually but it is way to fastidious in this case.
I have also used "ctrl+f" wich allows to detect all the negative values of the table by looking for "-" but unfortunatly it only allows the "-" character to be remplaced and not the case value.
Is there a method to suppress many data points at the same time based on a specific criteria?
I'm using Origin 8.1.
Thanks for your help.
|
| 4 L A T E S T R E P L I E S (Newest First) |
| Amad |
Posted - 03/23/2017 : 09:49:50 AM
Thank you, first method works perfectly! |
| arstern |
Posted - 03/22/2017 : 2:47:22 PM
Hi Amad,
I have two suggestions. Hopefully you can use at least one of the methods with Origin 8.1. Please let us know if both methods do not work for you.
1) You can find and replace all data points that are < 0. Do not input anything for replace. This will empty the cell.
http://www.originlab.com/doc/Origin-Help/Wks-Find-Replace-Data
If you want to delete the empty cell, select Worksheet--> Select reduce rows. This will open the Reduce Rows Dialog box. For the Reduce Method tab --> Select Delete Rows with Missing values.
2) You can Mask the values and then remove the rows with the masked values.
-Select Column in the Menu bar ---> Select Mask Cells by Condition.
- The Mask Cells by Condition dialog box will open
- Select condition <
- Input 0 for Value
-Select OK
- All the negative values will be masked and should display a different color font in the worksheet.
- To remove the masked rows: Select Worksheet ---> Reduce Rows
- This time select Delete rows with Masked values from the drop down menu.
-- Aviel Stern
OriginLab
|
| Amad |
Posted - 03/22/2017 : 1:34:14 PM
Hi Arstern,
Thanks for your answer.
I have been looking at all the toolbars and the user guide it seems that they are no filters on the 8.1 version. Am I wrong?
It should appears in the "worksheet data" toolbar but it's not.
Do you have any other method? |
| arstern |
Posted - 03/22/2017 : 12:11:54 PM
Hi Amad,
You can add a filter to your columns. The filter will hide all the rows that you specify. When you analyze and/or plot your data, OriginLab will not include the hidden rows in your worksheet. Refer to the link to look at how to add the filter.
http://www.originlab.com/doc/Origin-Help/Wks-DataFilter
--Aviel Stern
OriginLab |
