Displaying 20 results from an estimated 10000 matches similar to: "Tabular output: from R to Excel or HTML"
2011 May 09
3
converting a matrix or data.frame into an html table
Dear all,
Is there a function in R to convert a matrix or a data.frame into an html table?
Many thanks,
Samuel
[[alternative HTML version deleted]]
2009 Jan 08
1
R and Excel
Even using the VBA back of Excel to create interfaces with R would
make a lot of sense. Suppose I could have access to VBA macros that
import and export data into R , it would be great.
The R GUI series like Rattle come even closer to Excel...so a VBA
_R_ExCel package might be useful to ordinary folks .
Besides Excel costs money, so adding R functions to Open Office would
help both of them ( if
2001 Feb 09
1
tabular data (was RE: [R] Removing "row.names")
Hi,
I agree that replacing data.frames for modeling functions would
be too painful. Also I agree with Thomas that new class(es) for
tabular data should not inherit from data.frame, and that data.frames
should conceptually inherit from some other base tabular data class.
At this point I'm not suggesting anything in concrete --- I haven't
sorted it out in my own mind --- but I want
2011 Oct 28
1
xtable with \begin{tabular} and only.contents
I have found that I like having my captions and labels in my latex document
rather than having them contained in my xtable output file (I haven't fully
gone to sweave yet). I know I can do something like this by using the
'only.contents' argument in xtable. Unfortunately, the only.contents
argument also removes the \begin{tabular}{rrrrrr} & \end{tabular} (in the
example below) of
2009 Apr 10
1
How to handle tabular form data in lmer without expanding the data into binary outcome form?
Dear R-gurus:
I have a question about lmer.
Basically, I have a dataset, in which each observation records number of
trials (N) and number of events (Y) given a covariate combination(X) and
group id (grp_id).
So, my dataset is in tabular form. (in case my explanation of tabular form
is unclear,
please see the link:
2004 Jan 20
2
Error: unknown identifier {|} in tabular format {|l|c|c|c|}
I've got a package I would like to send out for testing and have noticed a
"problem" with the \tabular portion of the help "compiler"
the code for inserting vertical lines, in the tabular environment, causes
the build to choke, but not the check command.
C:\>rcmd build --binary -docs=all nlsystemfit
\tabular{|l|c|c|c|}{
\hline
Method \tab Instruments \tab
2012 Jul 26
4
Variables in a Tabular form. easily saved in a txt file
Dear all,
I would like to save few variable-names with their values in a tabular form, with that I mean
that files can be printed easily in R in a tabular form and also saved in a ascii file that when one opens it see also the variables in a nice tabular format.
IS that possible? Below a small example of how should look results in R and in a txt file.
Postal Code | Superb
2015 Jun 09
3
Tablas con tabular en latex
Buenos días,
estoy tratando de encontrar la manera de generar tablas en ficheros pdf
(sweave) a través del paquete tables. He mirado que este tema esta activo
en las listas pero no logro localizar las respuestas antes dadas, por eso
lanzo esta consulta.
Mi fichero .rnw tiene el siguiente aspecto:
*******
\documentclass{article}
\usepackage{array,booktabs,caption}
\begin{document}
2009 Jul 01
5
convert tabular time series into a matrix format
Hi, thanks everyone for any help in advance.
I found myself dealing with a tabular time-series data formatted each row
like [ time stamp, ID, values]. I made a small examples:
X = data.frame(t=c(1,1,1,2,2,2,2,3,3,3,4,4,4,5,5),id =
2009 Mar 05
4
including tabular information with a plot in R Graphics
Hi all,
I have a presentation problem that I cannot find a solution to in the
documetnation.
I have a nice barplot. Below this I would also like a table with some
information relating to the plot.
My idea was to have the plot and table on the same graphics window so I can
output them as an image file for a report.
Does anybody know how to include tabular information from a dataset or table
into
2010 Dec 01
3
Save R2HTML as an object instead of file
Hi
Is it possible to instead of getting the HTML code written to a file, get it
saved as a string in an object instead?
Or is there any kind of package that can do this?
//Joel
--
View this message in context: http://r.789695.n4.nabble.com/Save-R2HTML-as-an-object-instead-of-file-tp3066776p3066776.html
Sent from the R help mailing list archive at Nabble.com.
2006 Dec 14
5
Nicely formatted tables
If I use latex(summary(X)) where X is a data frame with four
variables I get something like
Rainfall Education Popden Nonwhite
Min. :10.00 Min. : 9.00 Min. :1441 Min. : 0.80
1st Qu.:32.75 1st Qu.:10.40 1st Qu.:3104 1st Qu.: 4.95
Median :38.00 Median :11.05 Median :3567 Median :10.40
Mean :37.37 Mean :10.97 Mean :3866
2009 Apr 16
3
Presenting R Results in Webpages
I apologize in advance that this question is not specific to R, but I thought some R users may be using this in their work process flow.
I would like to be able to have a tool (prefer "scriptable") that will take two images and some pre-written text and put it on an simple webpage.
That is, it would look something like the following:
|---------------------------------------------|
2006 Jul 21
4
Printed/PDF Reports (Text/Tabular/Summary) in Rails
The recent discussion about different graphing solutions made me
think. What is everyone using for general reports? Currently I have a
web based application at work that has roughly 20 different reports
ranging from simple tabular data with totaling at the bottom to
pretty, colorized, graphic logo''s,etc... going to clients, and
finally complex ones I hate to think about such as
2012 Oct 28
1
Tabular datos de Encuesta Continua de Hogares
Buenas, tengo la siguiente inquietud.
Tengo un data frame con los microdatos de la ECH de mi pais. He realizado un cuadro sin problemas en excel pero me gustaria una rutina de R para poder generar la tabla. El data.frame se llama ECH2009. Cuenta con las siguientes variables para este caso:
idhogar region estrato integranteshogar expansor ingpercapsvl Computador TvAbonado Internet
1 capital 1 2
2009 Jun 03
4
Excel Export in a beauty way
Hallo all,
I`ve read a lot of things in this forum about an Excel export via R. It is
no problem to export my data frames via write.table or write.xls (xls or
csv), but some things are not very convenient for me: I always have to
adjust the column with to see all the numbers or the text and there is no
frame between the cells. And I missing the possibility to make some headers
bold or coloured.
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
2008 Dec 05
2
xtable html links
Hi,
I was trying to get hyperlinks using xtable, but couldn't get the hyperlinks to function properly. For example, if I use
## Try to link NY times website to every figure in column 4
mat <- matrix(1:43,6,5)
mat[,5] <- "http://nytimes.com"
for(i in 1:nrow(mat)){
strr <- paste('<a href="', mat[i,5],'">', mat[i,4], '</a>',
2007 Nov 05
1
R2HTML package and Open Office: text only pasted
I am trying to use R2HTML (just downloaded from CRAN) to paste R (2.6.0)
results output via the clipboard to OpenOffice Writer and Calc
(version 2.3on WinXPPro)
Pasting into Excel gives a formatted table of results (as expected), but
pasting into Calc simply pastes the HTML code. Trying paste special only
gives an option to paste unformatted text.
Equally, with Writer, in the past when I tried
2013 Apr 25
0
tables: proper use of Hline() in tabular()
Dear all,
I am unable to understand how Hline() works in tabular(). I've read
the vignette and the help page, and here this example compiles
perfectly fine:
latex( tabular( Species + Hline() + 1
~ Heading()*mean*All(iris), data=iris) )
However, if I try it on my own data it fails. Consider this:
set.seed(1)
Xa <- data.frame(p=rep(c("First group","Second