similar to: Export data to Multiple Sheets in Excel via xlsReadWritePro

I have a several character variables that I need to recode, but some of them have special characters like single quote or ( ). How tell R to ignore these special characters so I can rename them? Below is the error message I am getting. social$FamilySupport[social$FamilySupport=="Mr. XXXs' extended family live in the Nashville area where he and his wife reside."]<-"Highly

I have a large dataset that contain duplicate records. How do I identify and remove duplicate records? Chris Anderson 707.315.8486 www.sassydeals4u.com ____________________________________________________________ Free info for small business owners. Click here to find great products geared for your business.

I have a variable that identifies citizen type but some of my rows are blank. I want to replace the blank entries with the correct value which is conditional on another variable. In SAS, my conditional statement would be as follow: if citizenType="" and primarylanguage="English" then citizenType ="US citizen"; else citizenType=citizenType; When I try to duplicate this

I am new to R, and I need to do some simple data cleaning. In the example below I have 164 rows of data with a missing value. I want to convert these missing to unknown while keeping the other values as is. summary(ABIClinical$HasSkinBreakdown) no unknown yes 164 914 163 178 When I did the following code:

I’m trying to export a file from R to excel using the xlsReadWritePro function and I keep getting the error below. I get the same error when I use the oledatetime function. My current date format is mm/dd/yyyy, which is how I want it in excel. Also is there anyway to export different datasets to multiple sheets similar to the ods function in SAS? <?xml:namespace prefix = o ns =

I am trying to create the roc plot bootstrap method from library(verification), and when I set the plot =both or emp then I get the following error. The roc.plot works fine when the plot is set to binorm. This is my first time using this function in R and am not sure what this error means or how to resolve the issue. It seems to work ok with the example dataset. Is there an option or data

Hello Developers, I am considering using SPEEX on an embedded processor that does not have a floating point unit. Does anybody have a SPEEX performance characterization on a fixed point processor? More specifically, I am interested in knowing how the MFLOPS values from Table 9.2 in the manual translate to fixed-point instructions when SPEEX is compiled with enable-fixed-point option. Any help

Hi, Is there a package I can use to write to multiple sheets on xls file, other than using the paid version of xlsReadWrite package (xlsReadWritePro)? Thank you, Ferry

Hi, I just finished xlsReadWritePro, a package that is - like the free xlsReadWrite - capable to read and write native Excel files. The Pro version is a shareware package and adds features such as: ? Sheet handling (select/insert/copy/delete/ren.) ? Select regions (columns, rows, cells or area) ? Append data (several possibilities) ? Work with multiple files at the same time ? Inside information

The xlsReadWrite[Pro] package allows to natively read and write Excel files (.xls) on the Win 32-bit platform. Changes: o fix bug with integer conversion (http://dev.swissr.org/issues/113) PROBLEM: values outside the integer range (i.e. 12345678901) didn't give an NA (and a warning message) but have been converted to a wrong value WHERE: - free/pro: reading an Excel sheet

The xlsReadWrite[Pro] packages allow to natively read/write Excel files (.xls) on the Win 32-bit platform. About a week ago new package versions have been released: * xlsReadWrite 1.5.3 is available at CRAN (for R2.11/2.12) and from www.swissr.org/download (binary builds for R2.9 - R2.12) * xlsReadWritePro 1.6.3 is available from www.swissr.org/download (binary builds for R2.9 - R2.12) * (the

i am currently using roundcube my webmail and configure using dovecot quota plugins. but it seems to not be updating the maildirsize when new mails comes.Deleting the maildirsize will recreate the files correctly.Is there any solutions to this problem with dovecot. Either you're not using dovecot-lda to deliver the mails, or you haven't configured quota plugin correctly for it.

Hello, everyone I run Eclipse Ganymede and R 2.7.2 at work. I have one R script file where I open in memory a new xls file (using xlsReadWritePro), call other R scripts, which are in the same folder as the main R script, which get data from an existing xls file, process data, and output results in the xls file which is in memory. That is the idea. But I cannot make it work. First, I do not

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

Hi I just started to use rsync & samba to backup some windows NT & 98 shared directories to a linux machine linux: debian 2.2.4 rsync: 2.2.5 samba: 2.2.3a-6 I first mount the windows directory on the linux and then do a local rsync. ---command on linux umount /data/transfer mount -t smbfs -o username=user,password=passwd //ntserver/exp_dir /data/transfer cd /data/transfer rsync -a

I am trying to use the quantcut function to create deciles, but I am getting the error below. I am new to using this function and do not know how to properly use the options or some other conversion that is necessary. #initial summary using describe function in Hmisc library DegreeBurn4th n missing unique Mean .05 .10 .25 .50 .75 .90 .95 76 133

I have been working with SYSLINUX/PXELINUX Mostly v.2.x recently v3.0 &v3.1 to remote-boot IBM PC's off of 1.44Floppy Images with great success. I have searched through several distributions and the SYSLINUX package seems to be by far the easiest to work with.. (thanks) My question would be: Is it possible to boot a diskless client PC with Complete hard disk images? or even better hard

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

Hi! Will you please ask a newbie's question? Need linear discriminant analysis, need to capture discrim. function coefficiemts for further processing. Using R ver 1.4.0 package MASS function lda() Help says resulting object should have "components" (among others): means, scaling, svd, but program returns NULL for all of them Thank you!

http://bugzilla.mindrot.org/show_bug.cgi?id=600 Summary: compilation of ssh-askpass or ssh-rand-helper fails on NCR MP-RAS v3.02 Product: Portable OpenSSH Version: -current Platform: ix86 OS/Version: other Status: NEW Severity: normal Priority: P2 Component: Build system