Displaying 20 results from an estimated 1000 matches similar to: "Getting multiple tables when using table(dataframe) to tabulate data"
2011 Mar 19
2
persuade tabulate function to count NAs in a data frame
Hi,
I'd like to ask you a question again. It is basically about data frames, NAs and tabulate function.
I have this data frame. I already used this in one of the previous questions of mine. It intentionally looks this simple, my real 'df' dataframe is much bigger actually and again, I am not willing to annoy anyone with huge databases... So, my database:
id
2010 Oct 03
1
tabulate() does not check for input bounds
Dear all,
it looks like that tabulate() does not check for the bounds of the input.
Reproducible example:
> b <- 1:2
> tabulate(b[1:100])
[1] 1 1
> R.version
_
platform i386-pc-mingw32
arch i386
os mingw32
system i386, mingw32
status Patched
major 2
minor 11.1
year 2010
month 09
day
2009 Jul 20
1
tabulate can accept NA values?
tabulate has
.C("R_tabulate", as.integer(bin), as.integer(length(bin)),
as.integer(nbins), ans = integer(nbins), PACKAGE="base")$ans
The implementation of R_tabulate has
if(x[i] != R_NaInt && x[i] > 0 && x[i] <= *nbin)
and so copes with (silently drops) NA. Perhaps the .C could have
NAOK=TRUE? This is useful in apply'ing tabulate to
1999 Apr 03
2
tabulate causes segmentation fault (PR#156)
Peter,
I thought this one was noted and fixed, but I could be wrong.
R : Copyright 1999, The R Development Core Team
Version 0.63.3 (March 6, 1999)
....
[Previously saved workspace restored]
> tabulate(1:10, 5)
Process R:1 segmentation fault at Sat Apr 3 17:48:34 1999
--
(The following contact details become official on 1 May 1999, but
the email
2006 Dec 31
3
tabulate: switching columns and rows
Hi all,
Please, is there any way of controlling factors in row/columns when using ftable/xtabs? As far as I can see, the last cross-clasifing variable in the formula will appear in columns. The previous ones, in rows. For instance, is it possible to make tension and replicate appear in columns?
ftable(xtabs(breaks ~ wool + tension + replicate, data = warpbreaks))
After some years using SAS
2009 Oct 28
1
Aggregate and cross tabulation
R-helpers:
I have a data frame containing 4 factor variables (let's say A,B,C,
and D) and 1 numerical variable (N). I would like to produce a
cross-tabulated data frame in which A,B,C are individual columns, each
factor of D is its own column, and the field is calculated as a given
function of N (I would like to have two output data frames, one with the
mean(N) and one with the
2009 Oct 16
1
generalization of tabulate()
Hi
I want a generalization of tabulate() which works on rows of a matrix.
Suppose I have an integer matrix 'observation':
> observation
y1 y2 y3
1 4 0
1 4 0
2 0 3
4 1 0
0 5 0
0 1 4
2 0 3
Each row corresponds to a (multivariate) observation. Note that the
first two rows are identical: this means that data "c(1,4,0)" was
observed twice.
Now suppose I can list the sample
2011 Sep 20
1
Tabulating Baseline Characteristics on specific observations
I have a data set with many missing observations. When I run a
regression, R of course discards the observations (the whole row) that
have "NA". I want to tabulate some baseline characteristics (column
means) but only for the observations that R used for the regression.
I tried to recreate this data frame by using na.omit on the original
data frame, but this will not work as this will
2007 Feb 28
4
PROC TABULATE with R
Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?...
Nom : non disponible
Url : https://stat.ethz.ch/pipermail/r-help/attachments/20070228/6ebce030/attachment.pl
2012 Feb 17
4
How can I tabulate time series data (in RStudio or any other R editor)?
Hello,
I have a question on how to tabulate the time series data. I use
RStudio, but if can be done in any other R editor, it should work in
RStudio as well.
> a1<-11:22
> a1ts<-ts(a1, frequency=4, start=c(1978,1))
> a1ts Qtr1 Qtr2 Qtr3 Qtr4
1978 11 12 13 14
1979 15 16 17 18
1980 19 20 21 22
If I click the variable "a1ts" on the
2010 Mar 29
0
Question on entry exit tabulating in any R finance package
I asked the question in Rmetrics subforum, but for some reason, almost two
weeks later, it keeps saying I haven't been approved to post yet there.
I'll try again here on the open forum.
I wanted to have a script that tabulates results by trade. I.e. instead of
tabulating each day as a trade event, you enter on one date, exit another,
and simply tabulate metrics based on one trade period.
2003 Feb 28
3
Tabulating
Hello,
I wonder if someone could send me suggestions on how to solve the following problem:
I have a vector of an arbitrary size (ex. data<-c(10,10,11,10,12,11,10,12,11,11,10,11)) and use the table function, which gives the following result
10 11 12
5 5 2
that''s fine, but what I would like to do now is:
construct new classes based on the number of classes from table, 10
2009 Oct 10
2
Tabulation
Hi all,
I have a data set
x1 x2 x3
1 2 1
1 2 3
2 1 2
1 2 1
3 1 1
I want to tabulate in the following way.
1 2 3
x1 3 2 1
x2 2 3 0
x3 3 1 1
It is just like frequency distribution
Any help is highly appreciated
[[alternative HTML version deleted]]
2016 Apr 23
2
CRAN package check results tabulated ... wasRe: Number of package in Ubuntu
> On Apr 23, 2016, at 6:56 AM, David Winsemius <dwinsemius at comcast.net> wrote:
>
>
>> On Apr 22, 2016, at 11:51 AM, mylisttech at gmail.com wrote:
>>
>> Dear Experts ,
>>
>> I am using R with Spark on Windows and now there is a need to move to Ubuntu. I wanted to know if most of the packages that are available on windows , would they be available
2017 Nov 10
0
Calculating frequencies of multiple values in 200 colomns
Hi,
To clarify the default behavior that Boris is referencing below, note the definition of the 'bin' argument to the tabulate() function:
bin: a numeric vector ***(of positive integers)***, or a factor. Long vectors are supported.
I added the asterisks for emphasis.
This is also noted in the examples used for the function in ?tabulate at the bottom of the help page.
The second
2010 Jun 30
1
how to tabulate the prediction value using table function for naive baiyes in R
Hi,
I have written a code in R for classifying microarray data using naive
bayes, the code is given below:
library(e1071)
train<-read.table("Z:/Documents/train.txt",header=T);
test<-read.table("Z:/Documents/test.txt",header=T);
cl <- c(c(rep("ALL",10), rep("AML",10)));
cl <- factor(cl)
model <- naiveBayes(train,cl);
2006 Oct 04
2
Tabulation and missing values
I think this is one for Gabor. I don't seem to be able to find my way to
an answer despite numerous rereadings of factor and table.
Here is a toy example:
### Some data
EthnicCode <- c("European/Other", NA, "European/Other", "European/Other",
"Pacific", "European/Other", "European/Other",
2017 Nov 10
2
Calculating frequencies of multiple values in 200 colomns
|> x <- sample(0:2, 10, replace = TRUE)
|> x
[1] 1 0 2 1 0 2 2 0 2 1
|> tabulate(x)
[1] 3 4
|> table(x)
x
0 1 2
3 3 4
B.
> On Nov 10, 2017, at 4:32 AM, Allaisone 1 <allaisone1 at hotmail.com> wrote:
>
>
>
> Thank you for your effort Bert..,
>
>
> I knew what is the problem now, the values (1,2,3) were only an example. The values I have are
2010 Mar 12
4
Form using R
Hi, R users
We can create a form using R?
I would like to create a form where the information can be read by R.
Itneeds to be updated daily because I have to tabulate the reasons for
delays
in the generation of numerical models products.
I really appreciate any help,
Thanks in advance,
Nilza Barros
[[alternative HTML version deleted]]
2016 Apr 24
0
CRAN package check results tabulated ... wasRe: Number of package in Ubuntu
Or grab https://cran.r-project.org/web/checks/check_results.rds and
read it w/o the need for scraping.
On Sat, Apr 23, 2016 at 10:43 AM, David Winsemius
<dwinsemius at comcast.net> wrote:
>
>> On Apr 23, 2016, at 6:56 AM, David Winsemius <dwinsemius at comcast.net> wrote:
>>
>>
>>> On Apr 22, 2016, at 11:51 AM, mylisttech at gmail.com wrote:
>>>