similar to: Massive data insert during migration

I would like to selectively remove rows from a table. I had hoped that I could create a table and selectively add rows with something like > NewTable<-table(nrow=100, ncol=4) > NewTable[1,]<-OldTable[10,] but that doesn't work. The former call gives > NewTable ncol nrow 4 100 1 while the latter call gives a table the length of OldTable. Making a matrix, m, with the

I''m trying to setup an app on Dreamhost and running into no end of problems. The app is running with edge rails and I''m currently getting the dreaded ''Rails application failed to start'' white screen when trying to access it. I''ve gone through all the ''gotchas'' and troubleshooting docs at Dreamhost and the rails wiki to no avail.

It seems that the dbReadTable() method provided by RMySQL could not get rid of the headers, neither the index column... So 1. Can I use read.table() method to get a table of MySQL database? >From the help document the argument of 'file' of read.table() method could be a connection... 2. How can I obtain a matrix from the database table contains all elements except the headers and the

I am finding complex analyses easier than some elementary operations in R. In particular I want to do some low level exploratory data analyses with data in a data frame but cannot find commands to easily insert, remove (delete), rename, and re-order (arbitrarily, not sort) columns. I see that the micEcon package has an insertCol command, but that is for matrices, not data frames. I have looked

Hi, Suppose I have the following data name     score Abel        88 Baker      54 Charlie    77 stored a  table called myData. I want to write a function that will create a table which is a subset of myData containing those have a score > 75. I know I can do this with the following command: subset(myData, score > 75) But I would like to do this via a function, something like:

Hi all, This should be easy, but I can't seem to figure it out. I have a table like this named newtable a1 a2 a3 a4 Cnts Score 1 1 0 0 4 3.28 1 0 1 1 2 2.63 I want the following: a1 a2 a3 a4 Cnts Score 1 1 0 0 4 3.28 1 1 0 0 4 3.28 1 1 0 0 4 3.28 1 1 0 0

Hi, i am unable to install the rugarch package. More than that i do not even find this package in my list of possible packages. Its possible than the name has changed, or the package is not longer availiable? Is there a similar package avaliable for garch modelling except the fGarch what i am using now? many Thanks Roland -- View this message in context:

Is it possible to create a database in MySQL via RMySQL? Also, is the format for the authorization field 'userName/password at databasename'? I saw an example like this somewhere in the documenation, but I haven't found the actual specification. Thanks, Barnet Wagman

userstable: |id|name|password| userdetailstable: |id|col1|col2|col3|user_id| this is my code: [code] def create @user = User.new(@params[''user'']) @userdetail = Userdetail.new(@params[''userdetail'']) if @user.save and @userdetail.save flash[:notice] = "Save succeeded..." redirect_to :action => ''list''

Ok, so I'm slowly figuring out what a factor is, and was able to follow the related thread about finding a mode by using constructs like my_mode = as.numeric(names(table(x))[which.max(table(x))]) Now, suppose I want to keep looking for other modes? For example, Rgames> sample(seq(1,10),50,replace=TRUE)->bag Rgames> bag [1] 2 8 8 10 7 3 2 9 8 3 8 9 6 6 10 10 7 1

FYI, looks like support for Racoon is ending. Does anyone have any experience with the version in ipsec-tools ? ---Mike >Racoon users, > >This is the announcement that the kame project will quit providing >a key management daemon, the racoon, and that "ipsec-tools" will become >the formal team to release the racoon. >The final release of the racoon in the

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 '

Hi, has anyone come across any incompatibilities between file_column and login_engine? I''ve been having strange issues where a User model with file_column in it is failing to save the images properly. Everything uploads to the tmp dir fine, but then it never gets copied to the proper permanent location. No errors - everything happens fine except for that final part. I have

In the customized autocomplete demo, how does it know what content to use as the value of the autocomplete? The returned UL has the name, email address and an image. Yet only the name is used. How does it do this? I''ve been trying to get something similar going all morning with little success. Also, what does :skip_style=>true do? I couldn''t seem to find a mention of it

So here''s the deal. I don''t know the innards of rails well enough to do this quickly but you might. First person to write this and release it under MIT license or public domain, and tells me, gets a free pizza from your favorite local delivery place. You pick the toppings, I''ll call ''em and order it up for you. Yeah a pizza isn''t much but I''m

I''m trying to do an IN query, where I have an array of user objects imaginatively named ''users'': :conditions=>["user_id IN (?)", users.collect{|u| u.id }.join('','')] this ends up with: ... IN(''1,2,3'') ... Obviously I want this to be: ... IN(1,2,3) ... or even ... IN(''1'', ''2'',

I''m trying to deploy an app on Dreamhost and I''m getting the infamous 500 Server Error. Nothing in the rails logs because it looks to be happening before it gets there. In the apache error logs we have: [Wed Apr 12 12:51:51 2006] [error] [client 194.80.32.9] FastCGI: comm with (dynamic) server "/home/rlivsey/thatsprogress.com/current/public/dispatch.fcgi"

Greetings! I''m attempting to use the act_as_versioned plugin to provide versioning functionality for my rails app, but can''t think my way through this: How can you use act_as_versioned to perform versioning on a HABTM join table? It is easy to see how to do so for join models (:has_many :through) but not so for the join table. I want to use act_as_versioned to maintain

I''m trying to use file_column in an app I''m writing. Simple file uploads are working fine. However, when I try and use the :magick options to make resized versions, WEBrick dies. This is the Media model: class Media < ActiveRecord::Base file_column :media_item, :magick => { :versions => { :thumb => {:size =>

Hi all, I''m developing an app on a home Windows computer and using SVN/Capistrano to deploy to a Linux server. I''m encountering some bizarre behavior that I think has something to do with Linux and Windows text file types, but I''m not sure. What''s happening is that, whenever I edit my view files and reload the page in my local browser, I see errors saying