similar to: Multiple tables by splitting column headings

Dear expeRts, Here is a minimal example with the latest version of 'tables' (questions below): require(tables) saveopts <- table_options(toprule="\\toprule", midrule="\\midrule", bottomrule="\\bottomrule", titlerule="\\cmidrule(lr)", rowlabeljustification="r")#, justification="r") ## data.frame x

Hi all, I am hoping that someone can help me with a problem I am having with column headings. I have read a table into R using read.table: the rows are documents, and the columns are counts of regular expression matches (so that the column heading is the given regular expression). My problem is that read.table seems to be trying to interpret the regular expressions, or has trouble with the

Dear R users: When I create a table without Major Column headings, my *regular* column headings appear correct in the typeset latex file. The major row heading and row groups are as they should. w <- latex(mytab,title="",file="tab/my.tex",ctable=TRUE,caption="Descriptive statistics by

Dear R colleagues, I annotated a list of single nuclotide polymorphiosms (SNP) with the corresponding genes using biomaRt. The result is the following data.frame (pasted from R): snp ensembl_gene_id 1 rs8032583 2 rs1071600 ENSG00000101605 3 rs13406898 ENSG00000167165 4 rs7030479

Hi All, I have the following data in one column for each row , (each value is like x1,y1,z1 space x2,y2,z2 space....) 77.56787,22.09909,0 73.26787,21.09909,0 76.53487,23.09909,0 75.56787,22.09909,0 76.54587,22.09909,0 76.56787,22.03509,0 75.56457,22.05609,0 76.56787,22.05609,0 Note all z values are O (hence ,0 can be treated as a delimiter) How do I split this column into multiple columns for

Hi, I use the excellent Sweave tools for writing documents but was wondering how to neatly print a data.frame with long column headings. I cant manage to do this via package:xtable. Typically the labels that I would like use for each column consist of more than one word, but even with just one word, the heading is often wider than the contents of the column. So the number of columns that fits

When I generate a LaTeX table using xtable I have been setting column names to strings with LaTeX code in order to get features like subscripts in the column headings. I recently had to reinstall xtable and discovered that all my LaTeX column headings were printing out in LaTeX code rather than with LaTeX formatting. For example, with the older xtable I could give my column a name something like

I have been looking at some 'table' examples in Peter Dalgaard's ISwR book, and I am confused by how to get right justification of my table headings when I use the tables() command. Compare the following: # Produces right justfified column names caff.marital=matrix(c(652,1537,598,242,36,46,38,21,218,327,106,67),nrow=3,byrow=T)

I have a reshaped data frame with value column headings concatenated from two column headings in the melted data frame. I want to change all 56 headings in a single command, but 'names' allows me to change only one at a time. In Hadley's 2007 article on reshape in the Journal of Statistical Software he mentions a 'rename' function, but I cannot find that. Is there a way to

Hi, I have a txt file here I want to split it into different files based on the column name if it contains a specific word or part of a word. For example, If the header looks like A001_Sick A015_SB K99_Sick L913_BB I would like to split the data , one file contains the data with column names containing the words ?Sick? or ?SB? and have the rest of the data in another file. I

HI, Try this: dat1<- read.table(text=" ?V1,V2,V3,V4,V5,V6,V7 ?chr1,564563,564598,564588 564589,1336,+,134 ?chr1,564620,564649,564644 564645,94,+,10 ?chr1,565369,565404,565371 565372,217,+,8 ?chr1,565463,565541,565480 565481,1214,+,15 ?chr1,565653,565697,565662 565663,1031,+,28 ?chr1,565861,565922,565883 565884,316,+,12 ",sep=",",header=TRUE,stringsAsFactors=FALSE)

I have an array of categories, and I wanted them split up into two columns in tables: category item_count | category item_count category item_count | category item_count category item_count | category item_count category item_count | category item_count ... Here''s the template code: <table> <tr valign="top"> <td width="50%"> <table

Hello! I have a column in my data frame that I have to split: I have to distill the numbers from the text. Below is my example and my solution. x<-data.frame(x=c("aaa1_bbb1_ccc3","aaa2_bbb3_ccc2","aaa3_bbb2_ccc1")) x library(stringr) out<-as.data.frame(str_split_fixed(x$x,"aaa",2)) out2<-as.data.frame(str_split_fixed(out$V2,"_bbb",2))

Yesterday I posted the following question (my apologies for not putting a subject line): =================question====================== Hello -- I would like to know of a more efficient way of writing the following piece of code. Thanks. options(stringsAsFactors=FALSE) orig <- c(rep('11111111',100000),rep('22222222',200000),rep('33333333'

Hi i have the data in the following format: rent,100,1,common,674 pipe,200,0,usual,864 car,300,1,uncommon,392:jump,700,0,common,664 car,200,1,uncommon,864:snap,900,1,usual,746 stint,600,1,uncommon,257 pull,800,0,usual,594 where as i want the above 6 lines data into 8 lines as below (Spliting row 3 & 4 at : and sending to a new row): rent,100,1,common,674 pipe,200,0,usual,864

Yesterday I posted the following question (my apologies for not putting a subject line): =================question====================== Hello -- I would like to know of a more efficient way of writing the following piece of code. Thanks. options(stringsAsFactors=FALSE) orig <- c(rep('11111111',100000),rep('22222222',200000),rep('33333333'

Hi Bogdan, Messy, and very specific to your problem: df.sample.gene<-read.table( text="Chr Start End Ref Alt Func.refGene Gene.refGene 284 chr2 16080996 16080996 C T ncRNA_exonic GACAT3 448 chr2 113979920 113979920 C T ncRNA_exonic LINC01191,LOC100499194 465 chr2 131279347 131279347 C G ncRNA_exonic LOC440910 525 chr2 223777758 223777758 T A

I would appreciate please a suggestion on how to do the following : i'm working with a dataframe in R that contains in a specific column multiple gene names, eg : > df.sample.gene[15:20,2:8] Chr Start End Ref Alt Func.refGene Gene.refGene284 chr2 16080996 16080996 C T ncRNA_exonic GACAT3448 chr2 113979920 113979920 C T ncRNA_exonic LINC01191,LOC100499194465

Hello, I have been using read.table to read data files into R, then rbind to combine them into one table. The column headings are all identical, so it should be straightforward, and it seems to be working well so far. My question is: What is the maximum number of tables that can be combined with rbind? Is it driven by the number of rows in the tables, by a constraint with the syntax of rbind

Colleagues ---------------------------------- System info: R version rw1020 on NT ESS using emacs ver. 20.4 ---------------------------------- I need to get the means for each column of a dataframe in the list created by splitting a data frame. At present, I am getting the mean of all columns in aggregate. The structure of the unsplit data is: > shuttle.tr1[1:10,] juliandate