similar to: system(mysql... Does not recognize < as passing an attribute

Hi, This is my command line request: mysql -u root -ppassword -D quant <c:/cline.txt This line works from the command line in windows. In R, when I try to use the system function, it does not work, > system(paste('mysql -u root -ppassword -D quant <c:/cline.txt'),show.output.on.console = TRUE) ERROR 1102 (42000): Incorrect database name '<c:/cline.txt' It seems

Hello, I have this data frame: ### begin d <-data.frame(matrix(c("1","--","bla",2),2,2)) d # I want to replace the "--" by "\N" and still get a data frame. # I tried: out <-gsub("--","\\\\N",as.matrix(d)) #using as.matrix to get rid of factors out cat(out) # But I lost my data frame ### end Any idea? Regards,

Hello, How do you change the language of the labels in a graph. In this example, I want to get French labels by changing Sys.putenv. I should get "Mai" instead of "May". Sys.putenv(LANGUAGE="fr") x <- as.Date(c("1jan1960", "2jan1960", "31mar1960", "30jul1960"), "%d%b%Y") y <-1:4 plot(x,y) Regards, Pierre

Here's my contribution to R. When R interacts with external programs (MySQL, cURL, etc.), it often requires a pasted string that is sent to these programs. For readability reasons, it is often preferable to have complex commands (SQL for example) spread on several lines. However, the normal paste function requires to add additional ' ", ' at the end of each line and another '

Hello, How would you export a 3-dimensional array to an SQL database? a<-array(1:24, 2:4) Is there an open source DB that would be more adequate for this type of operation? Is there a way to reshape/flatten a 3-dimensional array? Regards, Pierre Lapointe ************************************************** AVIS DE NON-RESPONSABILITE: Ce document transmis par courrie...{{dropped}}

Gregexpr - extract results with lapply Hello, I need to extract sequences of three upper case letters in a string. In other words, in this string: str <-c("ABC", "this WOUld be gOOD") The result I'm looking for is ABC WOU OOD. With gregexpr, I can get the position and length of the sequences gregexpr('[A-Z]{3}',str,perl=TRUE) [[1]] [1] 1

Hello, I need to identify all elements which have a sequence of 3 consecutive upper case letters, anywhere in the string. I tested my grep expression on this site: http://regexlib.com/RETester.aspx But when I try it in R, it does not filter anything. str <-c("AGH", "this WOUld be good", "Not Good at All") str[grep('[A-Z]{3}',str)] #looking for a

Hello, I'm trying to find out if something has been written in R regarding data assimilation and inverse modeling. These searches do not return anything that look like Kalman filter variations (EK, SEEK, ROEK, etc.) help.search("assimilation") help.search("inverse model") Regards, ************************************************** AVIS DE NON-RESPONSABILITE: Ce

Hello, I created a table in MySQL with this command CREATE TABLE example (pk INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(pk), id VARCHAR(30),col1 VARCHAR(30),col2 VARCHAR(30)) ### In R, I can connect to this table: library(DBI) library(RODBC) chan <- odbcConnect("MySQL51", uid="root", pwd="xxx") first <- sqlQuery(chan, "select * from example")

Hi, I'm starting to play with glusterfs, and I'm having a problem with the df output. The value seems to be wrong. (on the client) /var/mule-client$ du -sh 584K . /var/mule-client$ df -h /var/mule-client/ Filesystem Size Used Avail Use% Mounted on glusterfs 254G 209G 32G 88% /var/mule-client (on the server) /var/mule$ du -sh 584K . Is it a known

Hello, Let's say I have 50 R scripts to run. What would be the most efficient way to run them? I thought I could do multiple Rterms in a DOS batch file: Ex: Rterm <1.R> 1.txt Rterm <2.R> 2.txt ... Rterm <50.R> 50.txt However, I'm afraid they will all open at the same time. I know I could pause the batch file with something like: PING 1.1.1.1 -n 1 -w 60000

Hello, I want to reduce the distance between my ticks and their labels. I managed to do it for the x-axis, but the y-axis puzzles me. Here's an example where there is no space between the x-asix ticks and labels. par(las=1) plot(runif(50), type="l",xaxt="n",yaxt="n",ylab="", bty="l") axis(2) axis(1,padj=-1.5) #However, axis(2,padj=-1.5)

Hello, Ever wondered how people use a particular function in their programs? Use Google to find actual scripts: filetype:R boxplot will return real R scripts using the boxplot function. Regards, Pierre Lapointe Assistant Market Strategist *********************************************************************************** AVIS DE NON-RESPONSABILITE:\ Ce document transmis par

Hello, I have an excel file that I load through RODBC. Some of my columns are blank. They are equity time series and the stocks did not exist at the earlier dates. My problem is that the whole column becomes <NA> even though there are numbers at later dates. Here's my excel file http://www.tradebit.com/download.php/35699 <http://www.tradebit.com/download.php/35699> And

Dear all, I'd appreciate any hints how to arrange some plots. I have three plots. I would like to arrange them in the following order: - Plot 1 and Plot 2 should be in the upper row - Plot 3 should be in the lower row but centered in the middle. I hope the following sketch will help understanding my problem ================ | === === | || P1| |P2 | | || | | | | | === === |

Hello, This is not a problem with R, the calculated results are mathematically correct. This a matrix stability problem. Because of measuring errors, my matrix solution is a bit off. Here is what my equations look like: A11 x11+A12 x12 +A13 x13 = b1 A21 x21+A22 x21 +A23 x23 = b2 A31 x31+A32 x31 +A33 x33 = b3 A is a reading, X is a measured weight, and b is total. The 3 experiments give

Hi all. I usally make backups of databases mysql. I make buckups of all datbase for example: mysqldump -u user -ppassword name_db > backups.sql also I make backups just its schema for example mysqldump -u user -ppassword name_db --no-data > backups.sql but now I need a backups incrementals, because the size of DB is very big (500 mb) How to make this? regards -- *Atte.

Hello R-helpers, I'm new to XML. I have been using an application for some time, but now I wish to automate my downloads with R. When I use the web interface of their XML application, I'm able to read the response in R with the XML package. My problem now is to send the requests directly from R. Here below are two XML request scripts that come from the applicaton help file. My

Hello there, I tried so many times to download windows binary zip package but it told me that I don't have the access to do so. It worked for me a few months ago. Please help me with it. Thank you Lisa Wang Msc. Princess Margaret Hospital Toronto , Canada tel: (416) 946 4501 ext.5201

> > A quick google search found this: > > http://callecalle.uach.cl/ovirt-engine/docs/manual/en_US/html/Technical_Gu > > id e/QEMU_Guest_Agent_Overview.html > > > > Sadly, it didn't spell out the name of where you install hook scripts > > into the guest. But this commit is pretty telling: > >