The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Deleting negative data from table		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Amad

France
3 Posts
Posted - 03/22/2017 :  11:52:30 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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.

arstern

USA
237 Posts
Posted - 03/22/2017 :  12:11:54 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

Amad

France
3 Posts
Posted - 03/22/2017 :  1:34:14 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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?
Go to Top of Page

arstern

USA
237 Posts
Posted - 03/22/2017 :  2:47:22 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Edited by - arstern on 03/22/2017 2:47:44 PM
Go to Top of Page

Amad

France
3 Posts
Posted - 03/23/2017 :  09:49:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you, first method works perfectly!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000