similar to: Exporting/Importing selected columns of a database?

Hi Listers, I can't seem to figure out why I loose precision when I try to import a comma delimited file using read.csv or read.table. The fields of interest are rounded to one decimal place. DataTimeStamp TerminalID Hours Minutes Latitude Longitude Status Temperature Battery BootTimes Current Google 1 2/11/2010 12:22:21 PM 4894551 12 0 45.0 -66.5 0 30

Dear R-listers: I want to import a reasonably big file into a table. (15797 x 257 columns). The file is tab delimited with NA in every empty space. I have reproduced what I have used as my read.table instruction. I have read the R-dataImportExport FAQ and still couldn't solve my problem. (I might have missed it, of course). I'm using R.2.01 in a Mac G4, 10.3.7. I can import the

Hello R-help, I am trying to import a large dataset from SPSS into R. The SPSS file is in .SAV format and is about 1GB in size. I use read.spss to import the file and get an error saying that I have run out of memory. I am on a MAC OS X 10.5 system with 4GB of RAM. Monitoring the R process tells me that R runs out of memory when reaching about 3GB of RAM so I suppose the remaining 1GB is used up

Greetings - After 20+ years of using SAS, for a variety of reasons, I'm using [R] for a bunch of things - while I'm getting a pretty good a handling [R] for script programming, and statistical analysis, I'm struggling with 'pulling data into [R]'. For reasons beyond my control, a number of the files I get sent to 'work with' are in Dbase format (*.dbf). For

Hi, I have a hosting account with godaddy.com and I guess after asking about RoR, it''s now installed on both the Deluxe and Premium shared plans. Now, it seems that I don''t have command line access (i.e ssh). Thus, I was wondering, how does one check to see what gems are installed and how can I add other gems? Is it possible to add gems and plugins to the local project and

Hello, I'm newbie in R and I have a problem exporting a table with many columns to a dbf file. I found an error when I open the result DBF file on other software and also importing it on R again. Here a example snippet of the problem (on a GNU/Linux OS): http://pastebin.com/0SMJqqwb Is it a bug? Thank you, Nacho V [[alternative HTML version deleted]]

Hey Folks, Im looking for some suggestions here. Each day I need to process 200 GZ compressed files each day that contain comma delimited information in the following format: HostName, FileName, DirName, Modified_On Each file contains upwards of 200K rows and works out to be about 20MB when uncompressed. I need to compare this information to the information recieved the day before to look for

Folks: Say I have a matrix: test=matrix(c(1,2,3),nrow=10,ncol=3) I would like to have an output character vector where each line is row's values delimited by commas, e.g.: "1,2,3" "2,3,1" "3,1,2" ... "1,2,3" What is the fastest way of doing this? I can paste() row-by-row but this seems an inefficient approach to doing this. Thanks! I'm not

As it seems that we will be a year or so away from database application programs for linux like there are for windows (Foxpro, Paradox, dBASE, Access, Visual Basic, etc.), I am attempting to use windows as a development system (on a separate computer) and they copying the application to a linux computer (suse 9.3 to 10.1) to see if it will run under wine. It seems that the testing that has

Hi, I have a basic import problem. I tried to import a comma delimited "boston.csv" from C drive and gave the following command at R prompt >read.csv(c:\boston.csv,sep=",",dec=".",fill=TRUE) Error: syntax error can any one help to debugg the code.I am using R version 1.3 for windows with regards srinivas __________________________________________________ Do

Hi, could someone tell me how to list and update the currently installed gems on my rails installation? Thanks in advance, -Conrad

I read through the import/export manual a few times and did not see this mentioned and checked the archives as well. I am dealing with data sheets generated by Eprime (a software package for generating experimental psychology paradigms) that output subject responses in a proprietary Edat file format. All individual subject response spread sheets can be merged to form one long file of all

*I am a very new user of R. I've spent several hours trying to import data, so I feel okay asking the list for help. * *I had an Excel file, then I turned it into a "tab-delimited" file, as instructed by directions My filename is "lahore.txt" I amusing the following commands for read.delim but i am getting following mesages. Sir i am sending you my excel data file i

Dear R user, I am running R under Windows 2000. I am looking for a routine for importing - shape files (ESRI) into R - dbase files (FOXPRO) into R and I am looking for time-space models for description and prediction of Bernoulli-, Binomial- and Poissonvaraibles. Thank's a lot for a reply. Sincerely yours, Ekkehardt Altpeter Swiss Federal Office of Public

Hi, I''m looking to create a gallery index page of thumbnail images which point to their associated images galleries. Also, I would like to organize the images from left to right and top to bottom. Furthermore, I would like to limit the number of thumbnail images on the page. I guess that I''m needing some type of horizontal looping interface for both the thumbnail index page

Hi, I was wondering, does anyone have experience with deploying rails application(s) on TextDrive. At this time, I''m only seeing an index page remotely but on my system, I would type the following and obtain the expected result: http://localhost:3000/visitor/list However, when I perform the same operation on textdrive, I''m getting the following message on the screen:

Dear useRs We have a data-set (comma delimited) with 12Millions of rows, and 5 columns (in fact many more, but we need only 4 of them): id, factor 'a' (5 levels), factor 'b' (15 levels), date-stamp, numeric measurement. We run R on suse-linux 9.1 with 2GB RAM, (and a 3.5GB swap file). on average we have 30 obs. per id. We want to aggregate (eg. sum of the measuresments under

This is the first part (of three) of a set of changes to support merging Windows Registry entries from the common 'regedit' format. https://bugzilla.redhat.com/show_bug.cgi?id=575738 This adds a Perl library Win::Hivex::Regedit which supports two functions for importing and exporting the format. I've tested this on some real output from the Windows regedit.exe program successfully.

Hi, I was wondering, what''s the steps to migrating a Rails 1.0 to 1.1? Thanks in advance, -Conrad

The new gem version dependency system from Rails 1.1.1 needed a few tweaks to work properly and to stop throwing meaningless warnings. This tiny release makes up for that. To install: * gem install rails * rake rails:update:configs (to get the latest config/boot.rb) This release also signals our new commitment to do more tiny releases from the stable branch, which only gets bug fixes. So it will