search for: clumn

Hello, I have a question regarding a way to control the appreance of output exported by R when I use capture.output( x, file = "Directory/file.txt") , I get a text file which when I paste to a word file looks like the first table below. The following table has its clumns spaced closely so when I paste it to a word file it looks continuous. Is there any option in R to make the outputs like the second table? Any help will be highly appreciated. Thank you very much in advance. Model 1 4/70-3/80 Year 2 Source Area Runoff Nitrogen Phosphorus V1 LDR_imperv...

...ith numbers and character. I want to evaluate each cell and change the value of the cell before it depending on the evaluation. My evaluation: if a cell had the word "down" change the cell preceding it to a negative number by multiplying that value by a -1. I am have trouble going back on clumn to make this change. I'm receiving an error on the j-1 part, and the "down" cells are converted to 'NA'. A sample of my data matrix and code are pasted below. Any suggestions would be appreciated. Thanks! Data: PROBE 1 2.5 UP PROBE 2 1 UP PROBE 3 1.4...

...", design2, row.names = F, overwrite = T) : could not create table: aborting mysqlWriteTable The problem seems to be in double qoutes: syntax to use near '"condition" text, I have tracked down it to the problem with specific column in my frame If "condition" clumn is exluded, it works fine > mysqlWriteTable(conn, 'comparison',design2[,-10], row.names = F, overwrite=T) [1] TRUE > class(design2[,10]) [1] "character" > packageDescription('RMySQL') Package: RMySQL Version: 0.7-4 Date: 2009-04-07 Title: R interface to...