Dear Rui,
No problem and Many thanks.
Best Regards,
Ashim
On Fri, Dec 13, 2019 at 12:09 AM Rui Barradas wrote:
> Hello,
>
> You're right, none of the two seems to be working.
>
> set_width gives me tables of the same width no matter what value I pass
> as argument.
>
> And set_caption is askin
Hello,
You're right, none of the two seems to be working.
set_width gives me tables of the same width no matter what value I pass
as argument.
And set_caption is asking for a flextable object, doesn't work with
huxtable.
I don't know how to solve it right now, I will try later.
Rui Barrad
Hello once again,
for me,set_caption is not working as well. Here is my Rmd file :-
---
title: Testing Huxtables
author: Ashim Kapoor
output: word_document
---
```{r}
library(dplyr)
library(huxtable)
hx <- iris %>%
group_by(Species) %>%
summarise_if(is.numeric, mean) %>%
as_hux() %>%
On Wed, Dec 11, 2019 at 9:11 PM Rui Barradas wrote:
> Hello,
>
> This works for me:
>
>
> library(dplyr)
> library(huxtable)
> library(flextable)
> library(officer)
>
> hx <- iris %>%
>group_by(Species) %>%
>summarise_if(is.numeric, mean) %>%
>as_hux() %>%
>add_colnames() %>%
>
Hello,
This works for me:
library(dplyr)
library(huxtable)
library(flextable)
library(officer)
hx <- iris %>%
group_by(Species) %>%
summarise_if(is.numeric, mean) %>%
as_hux() %>%
add_colnames() %>%
set_bold(1, , TRUE) %>%
set_bottom_border(1, , 1) %>%
set_width(0.99) %>%
set_c
I have heard of people using CSS formatting with Rmarkdown output and
copy-pasting into Word/LibreOffice, but LaTeX is so much nicer if you don't
require Word that I suppose there haven't been many with that itch. To some
extent you can use a manually-styled Word starting document (referred to a
On 13/06/2018 10:10 AM, Bert Gunter wrote:
You should post this on the r-package-devel list, not here. That list is
exactly concerned with such issues. This list is about R programming itself.
No, r-package-devel is about developing and publishing R packages, not
using them.
I don't know th
You should post this on the r-package-devel list, not here. That list is
exactly concerned with such issues. This list is about R programming itself.
Cheers,
Bert
Bert Gunter
"The trouble with having an open mind is that people keep coming along and
sticking things into it."
-- Opus (aka Berk
On 22/02/2016 6:19 PM, Santosh wrote:
Sorry.. I forgot to mention that I wanted it be published in MS Word,
because it goes into a Report this is prepared using MS Word.
I can't help you with that.
Hence,the above effort.. yes, it's a lot easier to send it to Latex..
I was also wondering if
On Mon, Feb 22, 2016 at 3:36 PM, Santosh wrote:
> Thanks, Gergely.. I wonder if it allows to insert lines etc as sent in
> previous email which might need some additional preprocessing..
AFAIK that's not possible, as pandoc's markdown has no markup to add
horizontal/vertical lines in tables a
Thanks, Gergely.. I wonder if it allows to insert lines etc as sent in
previous email which might need some additional preprocessing..
Best,
Santosh
On Mon, Feb 22, 2016 at 3:27 PM, Gergely Daróczi wrote:
> On Mon, Feb 22, 2016 at 1:55 PM, Duncan Murdoch
> wrote:
> >
> > On 22/02/2016 3:46
On Mon, Feb 22, 2016 at 1:55 PM, Duncan Murdoch
wrote:
>
> On 22/02/2016 3:46 PM, Santosh wrote:
>>
>> Just figured out..
>>
>> as.data.frame(as.matrix(),stringsAsFactors=F)
>>
>> could work! :)
>
>
> Why do you want to produce Markdown output? the tables package (lowercase
> t!) can produce out
Sorry.. I forgot to mention that I wanted it be published in MS Word,
because it goes into a Report this is prepared using MS Word.
Hence,the above effort.. yes, it's a lot easier to send it to Latex..
I was also wondering if it is possible to add "\hline" separating the
categories in a table..
On 22/02/2016 3:46 PM, Santosh wrote:
Just figured out..
as.data.frame(as.matrix(),stringsAsFactors=F)
could work! :)
Why do you want to produce Markdown output? the tables package
(lowercase t!) can produce output in either LaTeX or HTML. Just tell
knitr to leave the output alone, e.g. f
Just figured out..
as.data.frame(as.matrix(),stringsAsFactors=F)
could work! :)
On Mon, Feb 22, 2016 at 12:17 PM, Santosh wrote:
> Dear Rxperts..
> I am able to generate tables using Tables R package..
> However, when I have been unsuccessful in using kable (from knitr package)
> to generate
On 15/05/2015 10:38 AM, Patricio Cuarón wrote:
> Hello. I'd like to know how could I localize (or otherwise change the
> string) of the "All" subtotal that appears when using something like
I just took a look at the source of the package. Currently there is no
way to use the R internationalizatio
On 15/05/2015 10:38 AM, Patricio Cuarón wrote:
> Hello. I'd like to know how could I localize (or otherwise change the
> string) of the "All" subtotal that appears when using something like
> library(tables)
> data(iris)
>
> tabular((Species + 1) ~ (n=1) + Format(digits=2)* + (Sepal.Length +
> Sep
riginal Message-
From: Duncan Murdoch [mailto:murdoch.dun...@gmail.com]
Sent: Monday, January 13, 2014 2:13 AM
To: Daniel Cher; r-help@r-project.org
Subject: Re: [R] tables package and alternative to col percent
On 14-01-13 12:02 AM, Daniel Cher wrote:
> Library "tables" and tabular
On 14-01-13 12:02 AM, Daniel Cher wrote:
Library "tables" and tabular function is neato.
I'm trying to figure out how to get percents other than just row and
columns. I'd like a percent of a factor.
That's a recent addition, still only on R-forge.
library(tables)
c=data.frame(
On 13-11-10 1:16 PM, Jeff Newmiller wrote:
There seems to be some inappropriate quoting in the tabular function from
the tables package. Consider this example:
This turned out to be different than I thought at first. It was simply
that I mis-used the latexTranslate function from the Hmisc pac
On 13-11-10 1:16 PM, Jeff Newmiller wrote:> There seems to be some
inappropriate quoting in the tabular function from
> the tables package. Consider this example:
>
> library(tables)
> sampledf <- data.frame( Manufacturer=c(rep("Joe & Co.",6)
> ,rep("\\tabu
On 13-11-09 5:56 PM, Jeff Newmiller wrote:
The problem that prompted this question involved manufacturers and their model
numbers, so I think the cross everything and throw away most of it will get out
of hand quickly. The number of models per manufacturer definitely varies. I
think I will wor
The problem that prompted this question involved manufacturers and their model
numbers, so I think the cross everything and throw away most of it will get out
of hand quickly. The number of models per manufacturer definitely varies. I
think I will work on the print segments of the table successi
On 13-11-09 1:23 PM, Jeff Newmiller wrote:
Visually, the elimination of duplicates in hierarchical tables in the
tabular function from the tables package is very nice. I would like to do
the same thing with non-crossed factors, but am perhaps missing some
conceptual element of how this package is
On 13-11-09 1:23 PM, Jeff Newmiller wrote:
Visually, the elimination of duplicates in hierarchical tables in the
tabular function from the tables package is very nice. I would like to do
the same thing with non-crossed factors, but am perhaps missing some
conceptual element of how this package is
The order in the table is the order of the levels in the factor, so the
best thing to do is to set the order in the factor itself. You can do this
using the factor function when you create the factor, or with a function
like relevel after the function has been created. In your case, what
happens
On Oct 8, 2013, at 10:29 AM, Renger van Nieuwkoop wrote:
> Hi
> I am using the package tables and want to have the rows in the numerical
> order and not in the alphabetical order:
>
> library(tables)
> Nodes <- c(1,10,20,2)
> Values<- c(1,2,3,4)
> Data <- data.frame(cbind(Nodes,Val
Hello,
First of all, there's no need for data.frame(cbind(...)). data.frame()
only will do the job, and it's less error prone.
As for the question, since the column Nodes is to become a factor, why
use as.character()? Without it the problem is solved:
data <- data.frame(Nodes,Values)
On Wed, Apr 24, 2013 at 9:23 PM, Santosh wrote:
> Dear Rxperts,
> Sorry if I am posting a really really dumb request.. I am new to subversion
> and am trying to use subversion to download the tables package as suggested
> by Duncan. I installed subversion client(from collabnet) and tried to
> acce
yes, With Duncan's and Liviu's help, I was able to remove those NAs and
NaNs from the tabular summary.
svn .. thing has not worked for me yet.. would try this later..
Thanks so much!
Regards,
Santosh
On Wed, Apr 24, 2013 at 1:46 PM, Santosh wrote:
> Thanks so much.. I will try it out.
> Reg
On 13-04-24 3:23 PM, Santosh wrote:
Dear Rxperts,
Sorry if I am posting a really really dumb request.. I am new to subversion
and am trying to use subversion to download the tables package as suggested
by Duncan. I installed subversion client(from collabnet) and tried to
access "tables" package u
Dear Rxperts,
Sorry if I am posting a really really dumb request.. I am new to subversion
and am trying to use subversion to download the tables package as suggested
by Duncan. I installed subversion client(from collabnet) and tried to
access "tables" package using the command below.
svn checkout
Dear Duncan,
On Tue, Apr 23, 2013 at 2:13 PM, Duncan Murdoch
wrote:
> I've done this now, in version 0.7.54 on R-forge. To leave out the rows
> with N=0, you can select a subset of the table where N (the first column) is
> non-zero:
>
> tab <- tabular(((p=factor(p))*(a=factor(a))+1) ~ (N = 1) +
On 13-04-23 8:07 AM, Liviu Andronic wrote:
Dear Duncan,
Thank you for your explanations.
On Tue, Apr 23, 2013 at 12:31 PM, Duncan Murdoch
wrote:
This isn't something that the package is designed to handle: if you say
p*a, it wants all combinations of p and a.
To your knowledge is there anot
On 13-04-23 6:31 AM, Duncan Murdoch wrote:
On 13-04-22 10:40 PM, David Winsemius wrote:
On Apr 22, 2013, at 5:49 PM, Santosh wrote:
Dear Rxperts,
q <- data.frame(p=rep(c("A","B"),each=10,len=30),
a=rep(c(1,2,3),each=10),id=seq(30),
b=round(runif(30,10,20)),
c=round(runif(30,40,70)))
The opera
Dear Duncan,
Thank you for your explanations.
On Tue, Apr 23, 2013 at 12:31 PM, Duncan Murdoch
wrote:
> This isn't something that the package is designed to handle: if you say
> p*a, it wants all combinations of p and a.
>
To your knowledge is there another 'complex tables' package that could
ac
On 13-04-22 10:40 PM, David Winsemius wrote:
On Apr 22, 2013, at 5:49 PM, Santosh wrote:
Dear Rxperts,
q <- data.frame(p=rep(c("A","B"),each=10,len=30),
a=rep(c(1,2,3),each=10),id=seq(30),
b=round(runif(30,10,20)),
c=round(runif(30,40,70)))
The operation below...
tabular(((p=factor(p))*(a=fact
Dear David,
On Tue, Apr 23, 2013 at 10:00 AM, David Winsemius
wrote:
> tabular( (`p a`=interaction(a,p, drop=TRUE, sep=" ")) ~ (N = 1) + (b + c)*
> (mean+sd),data=q)
>
> b c
> p a N mean sd mean sd
> 1 A 10 12.8 0.7888 52.1 8.020
> 3 A 10 14.6 3.7771 56.5
On 13-04-23 4:05 AM, Liviu Andronic wrote:
Dear David,
I'm once again facing the same issue as Santosh.
On Sat, Apr 20, 2013 at 12:15 AM, David Winsemius
wrote:
On Apr 19, 2013, at 2:03 PM, Santosh wrote:
Rounding was done to replicate the problem I faced in the original data set...
I go
On Tue, Apr 23, 2013 at 10:06 AM, David Winsemius
wrote:
>
> On Apr 23, 2013, at 1:00 AM, David Winsemius wrote:
>
>>
>> On Apr 23, 2013, at 12:53 AM, Liviu Andronic wrote:
>>
>>> Dear David,
>>> I'm having the exact same issue as Santosh, and looking at the fix
>>> that you've provided it seems t
On Apr 23, 2013, at 1:00 AM, David Winsemius wrote:
>
> On Apr 23, 2013, at 12:53 AM, Liviu Andronic wrote:
>
>> Dear David,
>> I'm having the exact same issue as Santosh, and looking at the fix
>> that you've provided it seems to me that results are slightly
>> different.
>>
> Reverse the ord
Dear David,
I'm once again facing the same issue as Santosh.
On Sat, Apr 20, 2013 at 12:15 AM, David Winsemius
wrote:
>
> On Apr 19, 2013, at 2:03 PM, Santosh wrote:
>
>> Rounding was done to replicate the problem I faced in the original data
>> set...
>
> I got an error every time I tried to u
On Apr 23, 2013, at 12:53 AM, Liviu Andronic wrote:
> Dear David,
> I'm having the exact same issue as Santosh, and looking at the fix
> that you've provided it seems to me that results are slightly
> different.
>
Reverse the order of arguemtns to `interaction`:
tabular( (`p a`=interaction(a,p
Dear David,
I'm having the exact same issue as Santosh, and looking at the fix
that you've provided it seems to me that results are slightly
different.
On Tue, Apr 23, 2013 at 4:40 AM, David Winsemius wrote:
>> b c
>> p a N mean sdmean sd
>> A 1 10 16.30 2.49
On Apr 22, 2013, at 5:49 PM, Santosh wrote:
> Dear Rxperts,
> q <- data.frame(p=rep(c("A","B"),each=10,len=30),
> a=rep(c(1,2,3),each=10),id=seq(30),
> b=round(runif(30,10,20)),
> c=round(runif(30,40,70)))
> The operation below...
> tabular(((p=factor(p))*(a=factor(a))+1) ~ (N = 1) + (b + c)*
> (
Dear Rxperts!
Thanks for the suggestions...(esp. Dr. Mathemedician)! :)
I add one more factor level (a level higher to "a") in the example..
a <- data.frame(p=rep(c("A","B"),each=10,len=30),
a=rep(c(1,2,3),each=10),id=seq(30),
b=round(runif(30,10,20)),
c=round(runif(30,40,70)))
tabular(((p=factor
On Apr 19, 2013, at 2:03 PM, Santosh wrote:
> Rounding was done to replicate the problem I faced in the original data set...
I got an error every time I tried to use digits=0. My basic rule is that if a
parameter choice consistently errors out ... stop using it. I'm fundamentally a
pragmatist.
Rounding was done to replicate the problem I faced in the original data
set...
2 independent identifiers in a group (shown only for 1 of 7 groups) may
have same value of b or c.
On Fri, Apr 19, 2013 at 1:53 PM, David Winsemius wrote:
>
> On Apr 19, 2013, at 1:29 PM, Santosh wrote:
>
> > Dear exp
On Apr 19, 2013, at 1:29 PM, Santosh wrote:
> Dear expeRts!
> when I try summarize data using "tabular" of tables package..
>
> here is an example..
>> a <-
> data.frame(a=rep(10,10),b=round(runif(10,10,20)),c=round(runif(10,40,50)))
>> a
>a b c
> 1 10 14 44
> 2 10 17 40
> 3 10 13 40
>
Are you sure that it is not just telling you that it cannot tabulate on a since
it only has one value?
John Kane
Kingston ON Canada
> -Original Message-
> From: santosh2...@gmail.com
> Sent: Fri, 19 Apr 2013 13:29:05 -0700
> To: r-help@r-project.org
> Subject: [R] tables package - error
I would like to thank all of you for spending your precious time in ordrer to
help me out.
I really appreciate the fact that experienced R users replied to my
"newbie" post.
Regards,
Spiros Gkolfinopoulos
--
View this message in context:
http://r.789695.n4.nabble.com/Tables-extraction-in-R-tp46
On 07/07/2012 03:23 AM, Greeknovice wrote:
Hi,
I 'm a novice user of R statistics and my hands-on experience with it is
minimal.
I want to create a table for my MBA course assignment that looks like the
ones that SPSS and MS Excel produces ,the data that the table has to include
are the following
---Original Message-
> From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
> project.org] On Behalf Of John Kane
> Sent: Friday, July 06, 2012 12:55 PM
> To: Greeknovice; r-help@r-project.org
> Subject: Re: [R] Tables extraction in R ?
>
> Have a look at the xtabl
Have a look at the xtables package. I have not used it in some time but I
think it may do what you want. A google search "R statistics xtables" should
bring up some useful information on this.
John Kane
Kingston ON Canada
> -Original Message-
> From: sggk...@gmail.com
> Sent: Fri, 6
Merge can only handle two tables at a time.
---
Jeff Newmiller The . . Go Live...
DCN: Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedde
On Jul 6, 2011, at 7:36 AM, Silvano wrote:
- Original Message - From: "Silvano"
To:
Sent: Thursday, June 30, 2011 9:07 AM
Subject: Tables and merge
I have 21 files which is common variable CODE.
Each file refers to a question.
I would like to join the 21 files into one, to construc
- Original Message -
From: "Silvano"
To:
Sent: Thursday, June 30, 2011 9:07 AM
Subject: Tables and merge
Hi,
I have 21 files which is common variable CODE.
Each file refers to a question.
I would like to join the 21 files into one, to construct
tables for each question by CODE.
I
?prop.table probably.
RSiteSearch at R Site Search http://finzi.psych.upenn.edu/nmz.html
or ?RSiteSearch would probably given you the anwser in about 30 seconds.
--- On Mon, 6/21/10, Erin Hodgess wrote:
> From: Erin Hodgess
> Subject: [R] tables
> To: "R help"
> Received: Monday, June 21,
On Jun 21, 2010, at 2:46 PM, Erin Hodgess wrote:
Dear R People:
I have generated the following table:
table(zza$DEATH,zza$GENDER)
F M
2009-04-21 0 1
2009-04-22 4 2
2009-04-24 6 0
2009-04-25 1 3
2009-04-26 2 0
2009-04-28 3 0
2009-04-29 2 2
Erin -
Here's a reproducible example that should help
answer your question:
set.seed(17)
df = data.frame(a=sample(letters[1:5],250,replace=TRUE),
+ b=sample(c('A','B'),250,replace=TRUE))
tt = table(df$a,df$b)
100 * prop.table(tt) # total of all percentages = 100
There are a few different options for exporting
matrices and dataframes from R to Excel.
RExcel (an Excel addin available from rcom.univie.ac.at) allows you
use a menu item "Get array" or "Get dataframe"
to do this.
Other options are described in Chapter 8 of the R Data Import/Export manual.
There
On Fri, Jun 12, 2009 at 10:57 AM, Stavros Macrakis wrote:
> On Fri, Jun 12, 2009 at 6:09 AM, Duncan Murdoch wrote:
>
>> On 11/06/2009 5:35 PM, Stavros Macrakis wrote:
>>
>>> A table without names displays like a vector:
>>>
>>> > unname(table(2:3))
>>> [1] 1 1 1
>>>
>>> and preserves the tabl
On Fri, Jun 12, 2009 at 6:09 AM, Duncan Murdoch wrote:
> On 11/06/2009 5:35 PM, Stavros Macrakis wrote:
>
>> A table without names displays like a vector:
>>
>>> unname(table(2:3))
>>[1] 1 1 1
>>
>> and preserves the table class (as with unname in general):
>>
>>> dput(unname(table(2:3
> "DM" == Duncan Murdoch
> on Fri, 12 Jun 2009 06:09:14 -0400 writes:
DM> On 11/06/2009 5:35 PM, Stavros Macrakis wrote:
>> A table without names displays like a vector:
>>
>> > unname(table(2:3)) [1] 1 1 1
>>
>> and preserves the table class (as with unname
On 11/06/2009 5:35 PM, Stavros Macrakis wrote:
A table without names displays like a vector:
> unname(table(2:3))
[1] 1 1 1
and preserves the table class (as with unname in general):
> dput(unname(table(2:3)))
structure(c(1L, 1L), .Dim = 2L, class = "table")
Does that make sen
On Jun 11, 2009, at 5:35 PM, Stavros Macrakis wrote:
A table without names displays like a vector:
unname(table(2:3))
[1] 1 1 1
and preserves the table class (as with unname in general):
dput(unname(table(2:3)))
structure(c(1L, 1L), .Dim = 2L, class = "table")
Does that make sense?
How are you sure it moved the data? What is the column separator that
you have? Is it just 'white space' as opposed to a tab or comma? It
you have a CSV file with a separator, the system knows where the
columns are. If it sees 'a b c' and then 'a c' as the next
row, 'c' will be in column
can share any ideas on how to do this.
-Original Message-
From: jim holtman [mailto:jholt...@gmail.com]
Sent: Friday, February 06, 2009 4:52 PM
To: Vemuri, Aparna
Cc: r-help@r-project.org
Subject: Re: [R] Tables in legend
This will probably do what you need:
plot(1)
This will probably do what you need:
plot(1)
x <- 1:10 # numbers for the legend
blah <- LETTERS[1:5]
legendData <- character(5)
for (i in 1:5)
legendData[i] <- sprintf("Blah-%s %d %d", blah[i], x[2*i - 1], x[2*i])
legend('topright', legend=legendData)
On Fri, Feb 6, 2009 at 6:57 PM, Vemuri,
xtable package and depending on what word processor you're using export as
latex or html. Fancier approach is xtable combined with Sweave.
--- On Tue, 1/13/09, Jason Rupert wrote:
> From: Jason Rupert
> Subject: [R] Tables for journal/conference publications from within R
> To: r-help@r-pr
Dear Jason,
I would suggest xtable (from the xtable package) and LaTeX / Sweave.
HTH,
Thierry
ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek / Research Institute for Nature and
Forest
Cel biometrie, met
71 matches
Mail list logo
