Displaying 20 results from an estimated 10000 matches similar to: "[help] deleting rows which contain more than 2 NAs or zeros"
2001 Mar 05
1
Canberra dist and double zeros
Canberra distance is defined in function `dist' (standard library `mva') as
sum(|x_i - y_i| / |x_i + y_i|)
Obviously this is undefined for cases where both x_i and y_i are zeros.  Since 
double zeros are common in many data sets, this is a nuisance.  In our field 
(from which the distance is coming), it is customary to remove double zeros: 
contribution to distance is zero when both x_i
2001 Mar 05
1
Canberra dist and double zeros
Canberra distance is defined in function `dist' (standard library `mva') as
sum(|x_i - y_i| / |x_i + y_i|)
Obviously this is undefined for cases where both x_i and y_i are zeros.  Since 
double zeros are common in many data sets, this is a nuisance.  In our field 
(from which the distance is coming), it is customary to remove double zeros: 
contribution to distance is zero when both x_i
2016 May 16
2
Determination of statements that contain only matrix multiplication
Hi Tobias,
could we use information about memory accesses of a SCoP statement and
def-use chains to determine statements, which don’t contain matrix
multiplication of the following form?
for (int i = 0; i < Upper Bound1; i++)
  for (int j = 0; j < Upper Bound2; j++)
    for (int k = 0; k < Upper Bound3; j++)
      C[i][j] += A[i][k] * B[k][j]
We could probably check that memory access
2016 May 17
4
Determination of statements that contain only matrix multiplication
On 05/17/2016 01:47 PM, Michael Kruse wrote:
> 2016-05-16 19:52 GMT+02:00 Roman Gareev <gareevroman at gmail.com>:
>> Hi Tobias,
>>
>> could we use information about memory accesses of a SCoP statement and
>> def-use chains to determine statements, which don’t contain matrix
>> multiplication of the following form?
> 
> Assuming s/don't/do you want
2009 Aug 20
2
Insert rows in between dataframes
Hi all,
Can anyone suggest me how to insert rows in between data frames and also
keep the ordering of row numbers correct?
                             Estimate             Std. Error            t
value   Pr(>|t|)
recmeanC2                      9.275880e-17    6.322780e-17   1.467057e+00
0.14349903
recmeanC3                      1.283534e-17   2.080644e-17    6.168929e-01
0.53781390
2017 Oct 05
4
dealing with a messy dataset
dear R-users,
I am facing a quite regular and basic problem when it comes to dealing 
with datasets, but I cannot find any satisfying answer so far.
I have a messy dataset of galaxies like that :
And XVIII          000214.5+450520  0.69 17   9 0.00  -8.7 26.8 6.44  
6.78 < 6.65  -44  0.5 MESSIER031               0.6  1.54
PAndAS-03          000356.4+405319  0.10 17     0.00  -3.6 27.8 
4.38 
2009 Jun 12
3
replacing zeros by NAs
something like ...
 
> x<-c(1,2,3,0,5,6,0)
> is.na(x[x==0])<-T
> x
[1]  1  2  3 NA  5  6 NA
~~~~~~~~~~~~~~~~
Robert  Kinley
~~~~~~~~~~~~~~~~
	[[alternative HTML version deleted]]
2004 Nov 16
3
Changing zeros to NAs in a data frame
Dear R People:
I have a data frame with some columns that are numeric and some which are 
factors.
There are zeros in the numeric columns and I would like to change them to 
NAs.  However, there are zeros in some of the factor columns, and I would 
like them to be left alone.
Is there a "global" way to do this, please?  I was thinking about use the 
results from "str" but am
2012 Jul 02
4
Removing rows if certain elements are found in character string
I would like to remove rows from the following data frame (df) if there are
only two specific elements found in the df$ch character string (I want to
remove rows with only "0" & "D" or "0" & "d"). Alternatively, I would like
to remove rows if the first non-zero element is "D" or "d".
                                             
2009 May 29
2
excluding NAs in data frame without deleting rows
Hi all,
I have a binary matrix with NAs included.  Each row and column
includes at least one NA, so I don't want to omit them.  Is there a
way to sum across rows and columns, ignoring the NAs but not deleting
the row or column?  If not, I suppose I can write a loop function, but
I have learned that it is best to stay away from loops if possible.
Thanks for any help,
Wade
2012 Mar 01
5
select rows by criteria
Hello,
I am stuck with selecting the right rows from a data frame. I think the
problem is rather how to select them
then how to implement the R code.
Consider the following data frame:
df <- data.frame(ID = c(1,2,3,4,5,6,7,8,9,10), value =
c(34,12,23,25,34,42,48,29,30,27))
What I want to achieve is to select 7 rows (values) so that the mean value
of those rows are closest
to the value of 35
2009 Sep 22
1
any way to make it work faster (deleting rows that contain certain values)
Hello, dear R'ers,
index<-expand.grid(1:7,1:4,1:4,1:4,1:4,1:4,1:4,1:4,1:4,1:4,1:4)
In this case, dim(index) is 7,340,032 (!)  and 11.
I realize it's huge.
Then, I am trying to get rid of the undesired combinations of columns.
They should not contain identical values in any 2 columns.
Also if column 1 has a value of 5, there should be no 2 in any other column,
if column 1 has a value
2011 Jun 02
3
Removing rows of zeros from a matrix
Hi,
Can someone tell me how to remove rows of zeros from a matrix?
For example if I have the following matrix,
0 0
0 1
2 8
0 0
4 56
I should end up with
0 1
2 8
4 56
-- 
Thanks,
Jim.
	[[alternative HTML version deleted]]
2012 Apr 25
1
fill a dataframe with zeros where the rows are a smaller subset of a larger dataframe (species by site)
row <- c("a","b","c","d","e","f","g") #rows from larger data frame
row.1 <- c("a","b","c","g") #rows of smaller data frame because d, e, 
and f don't contain any of the species, but the zeros are important
x <- data.frame(sp1=rnorm(4), sp2=rnorm(4), sp3=rnorm(4),
2012 Jan 27
2
The following code (using rgamma) hangs
Hi,
I'm seeing something that may be a bug in R's standalone math library, 
which is packaged by Debian as r-mathlib. I reported it to the Debian BTS 
as http://bugs.debian.org/657573
I'm using Debian squeeze, and the code was tested with r-mathlib 2.11.1-6 
(default on stable) and 2.14.1-1 (from testing/unstable).
I summarize this report below. The following code with the R math
2011 Oct 25
2
Extracting dataframe rows containing NAs in one column
Hi,
I am working on a data set which looks like this:
> head(temp)
  Day Month Year   PW  ROW
1   1     1 1959   NA 6.40
2   2     1 1959 6.65 6.35
3   3     1 1959 2.50 3.60
4   4     1 1959 0.60 2.25
5   5     1 1959 0.85 0.30
6   6     1 1959 0.00 2.20
I am trying to extract all the rows containing NA. I can extrat all the rows
without NAs in column 4 using 
>
2013 Nov 11
2
[LLVMdev] basic block missing after MachineInstr packetizing
Hi, all,
When I schedule machine instructions in a VLIW way and packetize them, a
problem is encountered, and I will show it use a simplified case as follows.
############ original instruction sequence
...
insn1
...
jump  LBB0_xx
...
LBB0_xx:
...
############ expected instruction sequence after scheduling and packetizing
insn1; jump LBB0_xx
...
LBB0_xx:
...
############ generated instruction
2009 Jun 10
2
How to get the unique pairs of a set of pairs dataframe ?
Hi friends,
Please can anyone help me with an easier solution of doing the  below
mentioned work.
Suppose i have a dataset like this:---
i1 i2  i3   i4 i5
1  7  13  1  2
2  8  14  2  2
3  9  15  3  3
4  10 16  4  4
5  11 17  5  5
6  12 18  6  7
*i1,i2,i3,i4,i5 are my items.I am able to find all possible pairs i.e
Say this dataframe is "item_pairs"
**i1,i2
**i1,i3
**i1,i4
i1,i5
**i2,i1
2017 Oct 05
0
dealing with a messy dataset
It looks like fixed width.  I just used the last position of each
field to get the size and used the 'readr' package;
    > input <- "And XVIII          000214.5+450520  0.69 17   9 0.00
-8.7 26.8 6.44  6.78 < 6.65  -44  0.5 MESSIER031               0.6
1.54
    + PAndAS-03          000356.4+405319  0.10 17     0.00  -3.6 27.8
4.38                    2.8 MESSIER031          
2010 Dec 31
4
Repeated Indexing / Sequence Operation
Hi Everyone,
quick question before the end of the year.
I have soem indices to select data from a bigger sample. I want to select n
days before each index and n days after the index. Any clever way to do it.
A for loop would do but I wanted to know if there is a moreR-friendly way to
approach this
Example
# InitialIndices
i2 = (90, 190, 290)
# Indices I want to end up with
i3 = c(85, 86, 87,