Displaying 20 results from an estimated 6000 matches similar to: "summarized data set - how to use an "occurs" field"
2010 Jun 07
2
graphical representation of a correlation between 3 variables (~30 datapoints)
Dear Ms and Mr R,
I am seeking a visually appealing presentation of 3 variables (~30
datapoints) that are correlated and that should to into the same direction.
The objective is to show that they do go in the same direction and what
differences there might be while also giving an idea of the values of the
variables. I had done this with simple bargraphs for 6 datapoints in the
past, but for
2010 Apr 26
1
mvpart : Printing response values at terminal nodes
I have created a multivariate regression tree using mvpart, with 3-4
responses. Though the plot shows bargraphs for each response, I would
like to have the VALUES of the responses
printed or indicated (via a scale or something) alongside the bargraph.
Is this possible ??
Thanks,
Manjunath
[[alternative HTML version deleted]]
2001 Aug 02
4
pictex driver and bargraph shading
I'm trying to use the pictex driver for bargraphs, and the shading isn't
showing up. Is there any way to get some sort of shading in the plots? A
hatch or stipple would be fine, too; just some way to differentiate the
bars.
The postscript driver won't do, since I'm trying to embed this in a LaTeX
document which I'll use pdflatex on and \includegraphics for pdftex doesn't
2012 Apr 19
2
suggested method to transform list to a matrix
I have data in the following list format:
USER,VARIABLE,COUNT
user1, var1, 3
user1, var2, 4
user2, var1, 7
userN, var12, 5
And would like to have it format as a matrix:
var1 var2 var12
user1 3 4
user2 7
userN 5
What is the suggested method to do this for 1 million rows, with 12 variables and ~ 4,000 unique users?
Thank you,
Tim Stutt
tim@ischool.berkeley.edu
[[alternative
2011 Feb 08
1
Set a Numeric Field To Blank
Hi,
I have one of those questions that I suspect is very simple, but hard to
classify, so I have been searching for quite some time and am not able to
find it.
If I have a data frame and I want to change all the values of one of the
columns to blanks, what is the syntax? I tried a few different spellings
of Null, etc., but can't get it. Can someone please send me what I
suspect is a one
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
2012 Jun 08
2
Percent of a given subset
How would I find the Percent of FuelTypeNum within the Band given
AvailableMW?
example:
type 1 is 1% of PB0
type 2 is 54% of PB0
type 4 is 4% of PB0
type 5 is 42% of PB0
Note: the Bands and fuel types are not always constant.
Data:
FuelTypeNum Bands AvailableMW AvailableMWNewFormat
1 PB0 185319 185.319
2 PB0 18352000 18352
4 PB0 1338785 1338.785
5 PB0 14189756 14189.756
2 PB1
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
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]]
2013 Mar 06
2
Fwd: How to conditionally remove dataframe rows?
Hi,
I have a data frame with two columns. I need to remove duplicated rows in
first column, but I need to do it conditionally to values of the second
column.
Example:
Point_counts Psi_Sp
1 A 0
2 A 1
3 B 1
4 B 2
5 B 0
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
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 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"]
}
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)?
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
2012 May 16
2
Splus equivalent of reshape in R
Hello R/Splus users..
I am posting in R discussion group in hope of wider response compared to
what I received from Splus user groups....
Was wondering if there is any function available in Splus 8.2 that is
equivalent to "reshape" of R?
Below is a sample dataset. Size [both rows and columns) of the dataset may
vary
X1 Y1 Y2 Y3
0.25 40 38 22
0.5 44 41