Displaying 20 results from an estimated 4000 matches similar to: "Fwd: How to conditionally remove dataframe rows?"
2010 May 12
2
sorting rows of dataframe
Hello:
I have a dataframe, where the first column in a month:
Month CATCHMENT_ med min max
1 Apr Alknda01 71.68080 11.9406600 196.2753
2 Apr Alknda02 69.44580 12.1065600 196.2753
3 Apr ArialKhan 39.89310 5.8598700 175.4433
4 Apr Arjun01 4.79652 0.0093336 55.7136
5 Apr Arjun02 4.79652 0.0093336 55.7136
6 Apr Arun01 52.42320 0.1571928
2002 Jun 06
7
samba with ldap
Hello ,
Does Samba 2.2 has support for LDAP
I want to use LDAP for user authentication instead of smbpasswd
Any help in this regard would be highly appreciated
Thanks & Regards
Kalpit Jain
Vice President-Technology
Email: kalpit@netcore.co.in
Netcore Solutions Pvt Ltd
402, Peninsula Chambers (Morarjee Mills Compound)
Ganpat Rao Kadam Marg (Behind Piramal Hospital)
Near A-Z Industrial
2011 Aug 10
2
using if then statements in a dataframe
I used this service several months ago and was very pleased with the response.
I have a dataframe with several thousand lines and to each line I need to apply a series of "if else" statements. For each row I need either a value or a blank/NA. Below is the series of if else statements I have been trying without success to integrate into a function such as "apply".
if
2012 Jan 11
3
summarizing a complex dataframe
I need some help summarizing complex data frames (small example below):
m1_1 m2_1 m3_1 m1_2 m2_2 m3_2
i1 1 1 1 2 2 2
i1 2 1 1 2 2 2
i2 2 2 1 2 2 2
For an arbitrary number of columns (say m1 ?. m199) where the column names have variable patterns,
and such that each set of columns is repeated (with potentially unique data) an
2010 Dec 24
4
Removing rows with earlier dates
Hi all,
I'm new to the list but have benfited from it quite extensively. Straight to
my rather strange question:
I have a data frame that contains mapping rules in this way:
ACCOUNT, RULE COLUMNS, Effective Date
The dataframe comes from a database that stores all dates. What I would like
to do is to create a data frame with only the most recent rule for each
account. In traditional
2010 Mar 12
5
Vertical subtraction in dataframes
Hello all,
I have not been able to find an answer to this problem. I feel like it might
be so simple though that it might not get a response.
Suppose I have a dataframe like the one I have copied below (minus the
'calib' column). I wish to create a column like calib where I am subtracting
the 'Count' when 'stain' is 'none' from all other 'Count' data for
2011 May 16
2
conditional rowsums in sapply
Hi all
I have a data frame with duplicate columns and i want to remove duplicates
by adding rows in each group of duplicates, but have lots of NA's.
Data:
dfrm <- data.frame(a = 1:4, b= 1:4, cc= 1:4, dd=1:10, ee=1:4)
names(dfrm) <- c("a", "a", "b", "b", "b")
dfrm[3,2:3]<-NA
dfrm
a a b b b
1 1 1 1 1 1
2 2 2 2 2 2
3
2011 Jan 31
2
From data frame to list object
Dear all, let say I have following data frame:
> data.frame(x=rnorm(18), y=rep(c("a", "b", "c"), each=6))
x y
1 -1.072152537 a
2 0.382985265 a
3 0.058877377 a
4 -0.006911939 a
5 -2.355269051 a
6 -0.303095553 a
7 0.484038422 b
8 0.733928931 b
9 -1.136014346 b
10 0.503552090 b
11 1.708609658 b
12 -0.294599403 b
13
2011 Jan 31
2
Missing at random
R users:
Thanks in advance
How to generate missing at random (MAR)?
assaedi76@yahoo.com
Thanks
[[alternative HTML version deleted]]
2011 Jul 15
3
summarized data set - how to use an "occurs" field
I have a data set with 22 fields and several thousand records in which
one field (count) indicates the number of times that each specific
combination of the other 21 fields occurred in a bigger and largely
unavailable data set.
So each record is unique in its combination of field values and has a
field that identifies how many multiples of this record actually
occurred.
Without resorting to
2012 Mar 18
3
Extracting numbers from a character variable of different types
Hello,
I have a file which contains a column with age, which is represented in the
two following patterns
1. "007/A" or ''007/a" or ''7 /a" ..... In this case A or a means year and I
would like to extract only the numeric values eg 7 in the above case if this
pattern exits in a line of file.
2. "004/M" or "004/m" where M or m means month
2011 Oct 16
2
Suppressing the Intercept in lm() when using a dataframe for the model
It's easy to run a linear regression on a simple model without an intercept
just by doing this:
lm(y ~ x1 + x2 -1)
Is there a similar trick to suppress the intercept when your model is in a
large dataframe and you don't want to write out the names of individual
columns?
--
View this message in context:
2013 Mar 11
2
how to convert a data.frame to tree structure object such as dendrogram
I have a data.frame object like:
> data.frame(x=c('A','A','B','B'), y=c('Ab','Ac','Ba','Bd'))
x y
1 A Ab
2 A Ac
3 B Ba
4 B Bd
how could I create a tree structure object like this:
|---Ab
A---|
_| |---Ac
|
| |---Ba
B---|
|---Bb
Thanks,
Zech
[[alternative HTML version deleted]]
2011 Mar 12
2
Merge data under conditions
Dear All,
Debuting in R, I'm facing a problem.
I have 2 vectors, say 'a' et 'b', and I'd like to merge them according to
the proximity of their variable 'time'.
How to do to keep elements which satisfy (for example) 'a$time-b$time<0.5'?
For example :
> a
time x
1 1.0 4
2 2.2 5
3 5.2 6
> b
time y
1 0 1
2 1 3
3 2 5
4 4 7
5
2010 Mar 16
2
Conditional variable assignment
Hi everyone,
Once again I am stuck with a problem I can't seem to figure out. I suppose this learning curve levels off eventually, lol. I am learning on my own with absolutely no background in programming, so if I seem to request help a lot it's not because I am seeking others to do the work for me. I need to assign one of two arrival times to the 'ARRIVE' variable of my
2003 May 09
1
windows data editor changes dimensions displayed data frames
dear R-tists,
i am experiencing a problem with the data editor in the windows version of
R 1.6.1 envoked with the command 'fix'.
the data editor changes the size of large data frames.
a simple example illustrates this:
-------------------------------------------------------
> dfrm <- data.frame(no=c(1:100000))
> length(dfrm[,1])
[1] 100000
> fix(dfrm)
>
2011 Feb 21
1
How to delete rows with specific values on all columns (variables)?
Hi,
I need to filter my data:
I think its easy but i'm stuck so i'll appreciate some help:
I have a data frame with 14 variables and 6 million rows. About half of this
rows have a value of "0" in 12 variables (the other two variables always
have values). How can I delete the rows in which all 12 variables have the
value of "0".
example (from my data, variable 14 is
2011 Jul 01
4
Access only part of last dimension of table/matrix
I would like to do some operations inside a function using only one
value for the last dimension of a table/matrix:
tabfn <- function (dfrm, facvec, YN ="event"){
return( Etbl <- do.call(table, dfrm[ , c(facvec,
"event") ]) )
# just want Etbl[,,,"TRUE"] or Etbl[,, "TRUE"] or
Etbl[,"TRUE"]
}
2011 Dec 06
5
Configure samba to not look for domain master browser
Hello
On my network there is no domain master browser, and my nmbd is spamming
my /var/log/messages file with messages that it cound not find one. Can
I configure nmbd not to look for the domain master browser ?
Thank you,
Timothy Madden
2005 Dec 01
1
Kalman Smoothing - time-variant parameters (sspir)
Dear R-brains,
I'm rather new to state-space models and would benefit from the extra
confidence in using the excellent package sspir.
In a one-factor model, If I am trying to do a simple regression where
I assume the intercept is constant and the 'Beta' is changing, how do
I do that? How do i Initialize the filter (i.e. what is appropriate to
set m0, and C0 for the example below)?