similar to: Examples on how to READ/WRITE to database using R-Project

Displaying 20 results from an estimated 600 matches similar to: "Examples on how to READ/WRITE to database using R-Project"

2009 Oct 10
7
SPSS long variable names
Hello guys I am new to this list and for R too. I am wondering if there is a patch for the SPSS reading code on the foreign package, in order to be able to read long variable names. Right now read.spss() just trunc the names to 8 characters. Or if someone could help me on other way: I have to process everyday a lot of SPSS Syntax Files and Dat files that come from one system that can only export
2008 Jan 18
3
Wishlist- Windows Gui (PR#10589)
Full_Name: Robert Baer Version: 2.6.1 OS: Windows XP Submission from: (NULL) (198.209.172.95) It would be wonderful if the CRAN mirror had an easy way to set a "default CRAN mirror". Current behavior is to have to choose a CRAN mirror the first time a package is installed in a session. The closest mirror site is always the same for me, and I wouldn't wish to change it unless it
2011 May 20
5
regression coefficient for different factors
Dear R-helpers, In my dataset I have two continuous variable (A and B) and one factor. I'm investigating the regression between the two variables usign the command lm(A ~ B, ...) but now I want to know the regression coefficient (r2) of A vs. B for every factors. I know that I can obtain this information with excel, but the factor have 68 levels...maybe [r] have a useful command. Thanks,
2012 Oct 09
2
RMySQL install on windows
I have been trying to install RMySQL on Windows 7 following the procedure at: http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL I think I have properly installed RTools and created a proper Renviron.site file saying: MYSQL_HOME="C:/Program Files/MySQL/MySQL Server 5.5" When I try to install the packages from source, I get warnings that suggest I'm still not quite "with the
2017 Mar 12
1
. Possible issue with R-tools on Windows
I encountered this issue a couple of months ago and resolved it by installing Rtools in the default directory C:\Rtools, see below for details. I didn't have time to prepare a proper error report and in fact suspected that I may be messing up something. I tracked down the error by installing from the command line, rather than with install.packages(). On Windows I keep multiple versions of
2011 Apr 06
1
corSpatial and nlme
I noticed that ?corClasses in package nlme does not list corSpatial among the standard classes. This might either be intentional because corSpatial is not "standard" , or it might be simply an oversight that needs correcting. ------------------------------------------ Robert W. Baer, Ph.D. Professor of Physiology Kirksville College of Osteopathic Medicine A. T. Still University of
2011 Mar 09
1
state.x77 dataset
I tried: > data(state.x77) Warning message: In data(state.x77) : data set 'state.x77' not found data(iris) seems to work fine, but the other state datasets (which I haven’t every tried before) don’t seem to be available on my windows 7 running R 2.12.2 installation. ?state brings up the state help page page which suggest the dataset should still be there. In help there still seems to
2018 Jul 16
2
persp command
Dear R-devel mailing list, I am wondering whether the "theta" and "phi" parameters of the "persp" function in the graphics commands are named in error (the names seem to have been swapped). Also, in the documentation to "persp", reference is made to "colatitude" when the effect in the image is actually that of "latitude". Thank you,
2008 Apr 13
1
SPSS to R Data file conversion
I wrote a little routine to convert multiple spss data files (as data frames) to R data files. The code is as follows: # list=dir(pattern=".sav") library(foreign) for (i in 1:length(list)){ # The saved data frame will be dat dat=read.spss(list[i],to.data.frame=TRUE) name=substring(list[i],1,nchar(list[i])-4) rname=paste("../R/",name,".rda",sep="") # This
2011 May 03
3
Watts Strogatz game
Hi, I have a erdos-renyi game with 6000 nodes and probability 0.003. g1 = erdos.renyi.game(6000, 0.003) How to create a Watts Strogatz game with the same probability. g1 = watts.strogatz.game(1, 6000, ?, ?) What should be the third and fourth parameter to this argument. -- View this message in context: http://r.789695.n4.nabble.com/Watts-Strogatz-game-tp3491922p3491922.html Sent from the R
2004 Nov 24
2
confidence interval of a average...
I have a sample of lung capacities from a population measured against height. I need to know the 95% CI of the lung capacity of a person of average height. I have fitted a regression line. How do I get a minimum and maximum values of the 95% CI? My thinking was that this has something to do with covariance, but how? My other thinking was that I could derive the 0.975 (sqrt 0.95) CI for the
2017 Sep 30
4
Converting SAS Code
On 9/29/2017 3:37 PM, Rolf Turner wrote: > On 30/09/17 07:45, JLucke at ria.buffalo.edu wrote: > > <SNIP> > >> >> The conceptual paradigm for R is only marginally commensurate with >> that of >> standard statistical software. >> You must immerse yourself in R to become proficient. > > Fortune nomination. For newer list members wondering what
2011 Jan 30
2
ggplot2 -- scale_colour_manual()
According to Hadley's ggplot book (p. 109), both the graphs below should have a legend, and yet none appears in my hands. Any suggestions? I can't see a typo. Is there a bug? library(ggplot2) data(LakeHuron) huron = data.frame(year=1875:1972,level=LakeHuron) p = ggplot(huron, aes(year)) + geom_line(aes(y= level - 5), colour = 'blue') + geom_line(aes(y= level + 5), colour
2004 Oct 19
2
Matrix/Table col headings R 2.0.0
I have been looking at some 'table' examples in Peter Dalgaard's ISwR book, and I am confused by how to get right justification of my table headings when I use the tables() command. Compare the following: # Produces right justfified column names caff.marital=matrix(c(652,1537,598,242,36,46,38,21,218,327,106,67),nrow=3,byrow=T)
2011 Mar 25
2
library(foreign) read.spss warning
I got the following: > library(foreign) > swal = read.spss("swallowing.sav", to.data.frame =TRUE) Warning message: In read.spss("swallowing.sav", to.data.frame = TRUE) : swallowing.sav: Unrecognized record type 7, subtype 21 encountered in system file > The bulk of the data seems to read in a usable form, but I'm curious about what might be getting lost
2004 Jan 20
4
Loading packages at startup
Hi, I use the Windows R GUI. I frequently use (or have my students use) foreign and survival packages. I would like to make them part of the basic start-up package set (like base, ctest, etc.) using something short of recompiling a special Windows version of R. Is this possible? I examined the autoload() command but this seems to target a single command of package, and only apply during a
2004 Mar 07
2
Excel files
Hello, I was trying to import data from an Excel file. After I imported the data, I was trying to make a scatter plot. The X axes variable is a time variable, which occupies two columns, one is date, another one is time. Example 21-Apr-03, 4:10 PM. My qestion is: 1. How can I access the data of certain column? I mean how can I refer it in R? 2. How can I make the two column character
2008 Oct 13
4
Fw: Logistic regresion - Interpreting (SENS) and (SPEC)
Dear Mr Peter Dalgaard and Mr Dieter Menne, I sincerely thank you for helping me out with my problem. The thing is taht I already have calculated SENS = Gg / (Gg + Bg) = 89.97% and SPEC = Bb / (Bb + Gb) = 74.38%. Now I have values of SENS and SPEC, which are absolute in nature. My question was how do I interpret these absolue values. How does these values help me to find out wheher my model is
2009 Oct 29
1
strsplit() and Windows file paths
There are two ways to express file paths with the Windows environment: > a=file.choose() > a [1] "C:\\Documents and Settings\\rbaer\\Desktop\\_VNT_Test\\coordFocused 20k F5 0ng Ki8751 t20.txt" and >b= paste(getwd(),"/",dir()[1],sep="") >b [1] "C:/Documents and Settings/rbaer/Desktop/_VNT_Test/coordFocused 20k F5 0ng Ki8751 t20.txt" I have 2
2006 Mar 21
5
How to use: library lattice: barchart
Dear ladies and gentlemen! In the help text for the xyplot (library(lattice), help(xyplot)) is an example given how one can use barchart: barchart(yield ~ variety | site, data = barley, groups = year, layout = c(1,6), ylab = "Barley Yield (bushels/acre)", scales = list(x = list(abbreviate = TRUE, minlength = 5)))