similar to: [OT] (slightly) - OpenOffice Calc and text files

Hello all, I am loading a data frame, fitting a model, getting diagnostic plots and they are flagging a couple of observations as problematic. Fair enough, and I want re-fit without them. After I delete an offending row (identified by one of the diagnostic plots), something like data = data[-3,]; then R will no longer print the contents of the data frame; it tells me it is a data frame

Hi, Until now I've been a happy user of CentOS. Everything just works(tm), and I don't care if application versions are slightly outdated. Next week I have to give a series of classes for a company that recently made the switch to Linux. On schedule is a one-week course for Writer and Calc. And right now I discover that one crucial function of Calc, "fill series",

Is there a way to estimate a nominal response model? To be more specific let's say I want to calibrate: \pi_{v}(\theta_j)=\frac{e^{\xi_{v}+\lambda_{v}\theta_j}}{\sum_{h=1}^m e^{\xi_{h}+\lambda_{h}\theta_j}} Where $\theta_j$ is a the dependent variable and I need to estimate $\xi_{h}$ and $\lambda_{h}$ for $h \in {1...,m}$. Thank you, Mauricio Romero Quantil S.A.S. Cel: 3112231150

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

I am attempting to create a simple line chart graphing three columns from a soffice-calc spreadsheet. I expect it to take the leftmost column as the X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis of the row number in the columns, and the first column amongst the data. I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2, iWork Pages, and Excel 12.2.4

Hi R users: I am using RODBC to create some new ".xls" files each with several sheets (about 100) with sqlSave() from a data.frame inside R without any problem, but on windows XP platform. I would like to know if it is posible to make a similar solution on linux with openoffice? RODBC work only (for the moment) with ".xls" on windows, via the ODBC driver. Is it posible to

Hello all, I think I probably did something stupid, and R's part was to allow me to do it. My goal was to control the order of factor levels appearing horizontally on a boxplot. Enter search engines and perhaps some creative stupidity on my part, and I came up with the following: v=read.table("factor-order.txt",header=TRUE); levels(v$doseGroup) = c("L", "M",

The thread "R licensing query" currently running has raised the classic critcisms of using Excel for statistics. I was wondering: Has anyone applied the same or similar set of tests to OpenOffice "calc"? Or would the Executive Summary be: "Calc is just like Excel"? (Not that I'm a spreadsheet user, if I can avoid it; but I sometimes get asked about such

I did a yum update last night at about 23h15 EDT (-4). No upgrade. I just did a yum update this morning at about 08h45 (-4). for my system there's about 348 megs of updates. Now all I have to do is figure out how to remove OO.o 2.0.whatever which is being upgraded to 2.3.whatever. I'm using 2.4.1 on my 4.6 boxes (have always been using the latest OO.o on them since installation a

I have been very satisfied with R-Excel interface (DCOM). Few months ago I have changed my OS to Linux-Mandrake, and now I am using OpenOffice.org Calc as spreadsheet. I would like to know does exist some R-OpenOffice.org interface or how is possible to use R-functions in OpenOffice.org Calc? Thanks a lot!

I am in awe of the project you developed but wish to do something simpler. I have recently decided to give up on Microsoft Office and wish to use OpenOffice exclusively. In the past I have used the RODBC package to read data from excel files. Do you know how to read data directly from OpenOffice calc files into R? Farrel Buchinsky

I am reading dates in Excel2007 into R. Here are the functions I used: library(RODBC) channel<-odbcConnectExcel2007("myfile.xlsx") tmp<-sqlFetch(channel,"1",as.is=T) The dates in myfile.xlsx are all in this format: mm/dd/yyyy. But when I read it to R, some columns look like "yyyy-mm-dd 00:00:00", some columns look like "yyyy-mm-dd", and some

Hi all, Has anyone upgraded OpenOffice.org 3.1.1 on Centos 5.3? Everything seemed fine but I have found 1 problem on Calc. The autofill does not work. Example, when I type "Jan" in cell A5 and drag the handle to cell D5, the Fill Settings dialog box pops up instead of the Feb, Mar, Apr filling in the cell automatically. When OpenOffice.org 3.1.1 from Sun is installed, it works.

I've just install centos 5.0 on new PC. However it gives this error while installing per-Date-Calc: [root at piranha tmp]# perl -ivh perl-Date-Calc-5.4-1.2.2.1.i386.rpm Unrecognized character \xED at perl-Date-Calc-5.4-1.2.2.1.i386.rpm line 1. what could be the problem? --beast

The last few releases of OpenOffice have gotten very unstable on my desktop which is a CentOS 5.5 i386 system. After multiple crashes when doing embedded simple drawings in OpenOffice writer (circles and lines with connections), I started using the versions from Sun then Oracle. I am now using version 3.3: openooffice.org3-3.3.0-9567. I've lived with this but with version 3.x it has gotten

Hello everyone. When I execute the following in R > (18-46)/(45-93) [1] 0.5833333 I get small precision for what I am trying to deal with . Is it possible to increase the precision for this and for other operations? For example openoffice calc for this operation returns 0.58333333333333300000 I I would like to thank you for your help [[alternative HTML version

Does anyone else find that using the Var.calc option (for heteroscedasticity consistent std. errors) in Match() (from the Matching library) slows down computation of the matching estimator by a lot? I don't really understand why when I use this option it slows down so much, but for me it does significantly. I want to use the heteroscedasticity consistent std. errors in my project, but as long

Hi, Can R read open office.org Calc files Thanks -- Shane [[alternative HTML version deleted]]

I have only one box[1] running 3 sub-systems[2] at my system, are these numbers resonsable[3]?? [1] - From dmesg (FreeBSD 6.1-RELEASE): AMD Sempron(tm) Processor 3000+ (1808.33-MHz K8-class CPU) real memory = 2080309248 (1983 MB) avail memory = 1997869056 (1905 MB) ad0: 76350MB <SAMSUNG SP0802N TK200-04> at ata0-master UDMA33 [2] The sub-systems are: 1 - A server giving adreesses of