[R] Skipping rows and columns in large matrix

Silvia Lomascolo slomascolo at zoo.ufl.edu
Wed May 9 00:38:10 CEST 2007


yes, this works.  I didn't think of concatenating... thanks!



jim holtman wrote:
> 
> zzz <- zzz[-c(1,45,23,321), -c(23,34,45,67)]
> 
> 
> On 5/8/07, Silvia Lomascolo <slomascolo at zoo.ufl.edu> wrote:
>>
>> I work on Windows, R version 2.4.1
>> I need to leave out many rows and columns when reading a matrix.  The
>> 'skip'
>> commands in read.table, seem to be just for skipping rows, if I
>> understand
>> well, but I need to skip many columns as well. I tried something very
>> simple
>> and left one row and one column out, but I don't know how to do it for
>> many
>> rows and columns at a time.
>>
>> Example:
>>
>> zzz # euclidean distances matrix
>>
>>      X1   X2   X3   X4   X5
>> X1    0   11   12     1   15
>> X2   11    0     5   12     3
>> X3   12    5     0     8     4
>> X4     1  12     8     0   16
>> X5   15    3     4    16    0
>>
>> skip.data = zzz [-3, -3]   #  gives me the same matrix without row 3 and
>> column 3... how can I tell R to skip more than one row and column? 
>> Columns
>> and rows to be left out are not contiguous  The matrix I'm using is
>> fairly
>> large (335x335), so excel won't read the whole thing, and it's not a
>> fixed-width txt file, so I cannot use read.fwf.  I also don't have access
>> to
>> Unix, as was suggested to other users to solve this problem.
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Skipping-rows-and-columns-in-large-matrix-tf3712332.html#a10384400
>> Sent from the R help mailing list archive at Nabble.com.
>>
>> ______________________________________________
>> R-help at stat.math.ethz.ch mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
> 
> 
> -- 
> Jim Holtman
> Cincinnati, OH
> +1 513 646 9390
> 
> What is the problem you are trying to solve?
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> 
> 

-- 
View this message in context: http://www.nabble.com/Skipping-rows-and-columns-in-large-matrix-tf3712332.html#a10385469
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list