[R] Display a dataframe

arun smartpink111 at yahoo.com
Fri Jul 4 03:57:00 CEST 2014


Hi,
May be this helps:
nC <- max(nchar(row.names(dd)))
 term <- formatC(row.names(dd), width=-nC)
#or
 term <- sprintf("%-11s", row.names(dd))

  dd1 <- setNames(data.frame(unname(dd), term,stringsAsFactors=F), c(colnames(dd), formatC("term",width=-nC)))
dd1
#      # Chisq DF   Pr(>Chisq) term       
#1 153.0216306  1 7.578366e-35 # Sex      
#2  13.3696538  1 5.114571e-04 # Volume   
#3   0.8476713  1 7.144239e-01 # Weight   
#4   1.2196050  1 5.388764e-01 # Intensity
#5   2.6349405  1 2.090719e-01 # ISO      
#6   6.0507714  1 2.780045e-02 # SEC      

A.K.





On Thursday, July 3, 2014 3:57 PM, Gang Chen <gangchen6 at gmail.com> wrote:
I have a matrix 'dd' defined as below:

dd <- t(matrix(c(153.0216306,  1, 7.578366e-35,
13.3696538,  1, 5.114571e-04,
0.8476713,  1, 7.144239e-01,
1.2196050,  1, 5.388764e-01,
2.6349405,  1, 2.090719e-01,
6.0507714,  1, 2.780045e-02), nrow=3, ncol=6))
dimnames(dd)[[2]] <- c('# Chisq', 'DF', 'Pr(>Chisq)')
dimnames(dd)[[1]] <- c('# Sex', '# Volume', '# Weight', '# Intensity',
'# ISO', '# SEC')

'dd' displays as the following:

                # Chisq DF   Pr(>Chisq)
# Sex       153.0216306  1 7.578366e-35
# Volume     13.3696538  1 5.114571e-04
# Weight      0.8476713  1 7.144239e-01
# Intensity   1.2196050  1 5.388764e-01
# ISO         2.6349405  1 2.090719e-01
# SEC         6.0507714  1 2.780045e-02

I would like to display it as:

# Chisq               DF   Pr(>Chisq)                        term
153.0216306  1 7.578366e-35                            # Sex
13.3696538  1 5.114571e-04                              # Volume
0.8476713  1 7.144239e-01                                # Weight
1.2196050  1 5.388764e-01                                # Intensity
2.6349405  1 2.090719e-01                                # ISO
6.0507714  1 2.780045e-02                                # SEC

This is what I came up with

(cc <- data.frame(data.frame(dd), term=dimnames(dd)[[1]]))

               X..Chisq DF   Pr..Chisq.        term
# Sex       153.0216306  1 7.578366e-35       # Sex
# Volume     13.3696538  1 5.114571e-04    # Volume
# Weight      0.8476713  1 7.144239e-01    # Weight
# Intensity   1.2196050  1 5.388764e-01 # Intensity
# ISO         2.6349405  1 2.090719e-01       # ISO
# SEC         6.0507714  1 2.780045e-02       # SEC

But I'm not happy with the following two issues:

1) How to get rid of the row names?
2) The special characters of #, (, >,) in the column names are not
displayed correctly.

Any suggestions?

Thanks,
Gang

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.




More information about the R-help mailing list