Re: Selecting Rows Based on Column Values
- To: mathgroup at smc.vnet.net
- Subject: [mg101496] Re: [mg101471] Selecting Rows Based on Column Values
- From: "David Park" <djmpark at comcast.net>
- Date: Thu, 9 Jul 2009 01:52:16 -0400 (EDT)
- References: <18007573.1247052717709.JavaMail.root@n11>
Select[tester, Part[#, 3] == 1 &] David Park djmpark at comcast.net http://home.comcast.net/~djmpark/ From: cynthia wu [mailto:wu.x.cynthia at gmail.com] I've been trying to use the Select Command to select only the rows that have the a specific value in a specific column. I have, for example, the following matrix (4x3): tester={{1, 3, 1}, {3, 1, 0}, {4, 2, 1}, {5, 6, 2}} I want to select the rows that have values ==1 in the 3rd column. I've tried: select(tester, #[[All,3]]==1&), but I get an error saying that my request violates the matrix boundaries. The desired output should be: {{1,3,1}, {4,2,1}}. Any thoughts would be greatly appreciated. Thanks!