Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Thank you for all your tips. Will keep these checked. Have a great day On Wed, Jul 27, 2016 at 1:26 AM, William Dunlap wrote: > Your original mail said >Example of date - 05-30-16 > >To change this i have used eir$date<- as.Date(eir$date, "%m-%d-%y") > > but by

[R] Ocr

2016-07-26 Thread Shane Carey
Hi, Has anyone ever done any ocr in R?? I have some scanned images that I would like to convert to text!! Thanks -- Le gach dea ghui, Shane [[alternative HTML version deleted]] __ R-help@r-project.org mailing list -- To UNSUBSCRIBE and

Re: [R] R3.3.1 - Windows10 OS - Overriding default Legend title with user specified title

2016-07-26 Thread Tom Wright
A quick google for "ggplot2 change legend text" turns up several hits. This stackexchange question has several recipes. http://stats.stackexchange.com/questions/5007/how-can-i-change-the-title-o f-a-legend-in-ggplot2 including the correct use of the labs() function; labs(aesthetic='BrandValue in

Re: [R] Date Time in R

2016-07-26 Thread William Dunlap via R-help
Your original mail said Example of date - 05-30-16 To change this i have used eir$date<- as.Date(eir$date, "%m-%d-%y") but by showing us the actual code I see you reversed the m and d and capitalized the Y in your first attempt, causing NA's since your data was not in that format. The big

Re: [R] Time format issue

2016-07-26 Thread David Winsemius
> On Jul 26, 2016, at 11:24 AM, kolkata kolkata wrote: > > Hello Everyone, > > I have a file with time in the following format: > > Time > > 27DEC11:00:30 > > 27DEC11:01:30 > > 27DEC11:02:00 > > ……. > > The time column is factor. I want to convert each time to the

Re: [R] lm() silently drops NAs

2016-07-26 Thread peter dalgaard
> On 26 Jul 2016, at 22:26 , Hadley Wickham wrote: > > On Tue, Jul 26, 2016 at 3:24 AM, Martin Maechler > wrote: >> ... > To me, this would be the most sensible default behaviour, but I > realise it's too late to change without breaking many

Re: [R] removing all non-numeric characters from a string, but not "."

2016-07-26 Thread David Winsemius
> On Jul 26, 2016, at 2:28 PM, Dimitri Liakhovitski > wrote: > > gsub("[^0-9]", "", x) ?regex I think you might be bit embarrassed because it seems pretty obvious once you know that character class elements like "." don't need to be escaped so it's just

Re: [R] removing all non-numeric characters from a string, but not "."

2016-07-26 Thread Marc Schwartz
> On Jul 26, 2016, at 4:28 PM, Dimitri Liakhovitski > wrote: > > Hello! > > I have a string x: > x <- c("x - 84", "y - 293.04", "z = 12.5") > > I want to remove all the non-numeric stuff from it. The following works: > gsub("[^0-9]", "", x) > > However, it

Re: [R] about netcdf files

2016-07-26 Thread lily li
How to read continuous daily precipitation at each grid cell, and then export to a csv file? Later, there should be several csv files, each represents daily precipitation data for one grid cell. Thanks a lot. On Tue, Jul 26, 2016 at 2:52 PM, Roy Mendelssohn - NOAA Federal <

Re: [R] removing all non-numeric characters from a string, but not "."

2016-07-26 Thread peter dalgaard
> On 26 Jul 2016, at 23:28 , Dimitri Liakhovitski > wrote: > > Hello! > > I have a string x: > x <- c("x - 84", "y - 293.04", "z = 12.5") > > I want to remove all the non-numeric stuff from it. The following works: > gsub("[^0-9]", "", x) > > However, it

Re: [R] Ocr

2016-07-26 Thread Jim Lemon
Hi Shane, FreeOCR is a really good place to start. http://www.paperfile.net/ Jim On Wed, Jul 27, 2016 at 6:11 AM, Shane Carey wrote: > Hi, > > Has anyone ever done any ocr in R?? I have some scanned images that I would > like to convert to text!! > Thanks > > > -- > Le

Re: [R] Ocr

2016-07-26 Thread Jim Lemon
Hi Shane, If you want to run OCR on the command line, the Tessaract engine is probably the way to go. Harder to build and install, but you can call it from an R session. Jim On Wed, Jul 27, 2016 at 8:24 AM, Shane Carey wrote: > Cool, thanks Jim!! > I would love to be able

Re: [R] Windows 10 Application Compatibility Check | FreeWare R Statistical Environment v3.2.2

2016-07-26 Thread Robert Baer
Runs fine on Windows 10 for me. On 7/25/2016 7:18 AM, Ramar, Rohini wrote: Hello Team, We are, Citi Application Readiness Team, need your assistance in order to gather info about below application compatibility and support for Win 10 as part of Window 10 Readiness initiative. CITI Bank has

Re: [R] lm() silently drops NAs

2016-07-26 Thread Hadley Wickham
On Tue, Jul 26, 2016 at 3:24 AM, Martin Maechler wrote: > I have been asked (in private) Martin was very polite to not share my name, but it was me :) > > Hi Martin, > > y <- c(1, 2, 3, NA, 4) > x <- c(1, 2, 2, 1, 1) > > t.test(y ~ x) > lm(y ~ x)

[R] Time format issue

2016-07-26 Thread kolkata kolkata
Hello Everyone, I have a file with time in the following format: Time 27DEC11:00:30 27DEC11:01:30 27DEC11:02:00 ……. The time column is factor. I want to convert each time to the following format: 20111211003000 20111211013000 2011121102 (Year)(month)(date)(hr)(min)(sec) Any

Re: [R] about netcdf files

2016-07-26 Thread lily li
Here are the results. Yes, I tried to read netcdf files, but cannot grasp the contents. Thanks for helping out. > str(pre1) List of 14 $ filename : chr "~/Downloads/sample_precip_daily.nc" $ writable : logi FALSE $ id : int 262144 $ safemode : logi FALSE $ format : chr

[R] removing all non-numeric characters from a string, but not "."

2016-07-26 Thread Dimitri Liakhovitski
Hello! I have a string x: x <- c("x - 84", "y - 293.04", "z = 12.5") I want to remove all the non-numeric stuff from it. The following works: gsub("[^0-9]", "", x) However, it strips my numbers of "." Help - how could I do the same but leave the "." in? Thanks a lot! -- Dimitri Liakhovitski

Re: [R] removing all non-numeric characters from a string, but not "."

2016-07-26 Thread Marc Schwartz
> On Jul 26, 2016, at 4:39 PM, Marc Schwartz wrote: > > >> On Jul 26, 2016, at 4:28 PM, Dimitri Liakhovitski >> wrote: >> >> Hello! >> >> I have a string x: >> x <- c("x - 84", "y - 293.04", "z = 12.5") >> >> I want to remove all the

Re: [R] removing all non-numeric characters from a string, but not "."

2016-07-26 Thread Dimitri Liakhovitski
Thank you very much, gentlemen! On Tue, Jul 26, 2016 at 5:48 PM, peter dalgaard wrote: > >> On 26 Jul 2016, at 23:28 , Dimitri Liakhovitski >> wrote: >> >> Hello! >> >> I have a string x: >> x <- c("x - 84", "y - 293.04", "z = 12.5") >> >> I

Re: [R] lm() silently drops NAs

2016-07-26 Thread Hadley Wickham
> I think that's a bit too strict for me, so I wrote my own: > > na.warn <- function(object, ...) { > missing <- complete.cases(object) > if (any(missing)) { > warning("Dropping ", sum(missing), " rows with missing values", > call. = FALSE) > } > > na.exclude(object, ...) > } That

Re: [R] lm() silently drops NAs

2016-07-26 Thread Andrew Robinson
Agh. I've argued elsewhere that the default behaviour should be to fail, and the user should take the responsibility to explicitly handle the missing values, even if that simply be by changing the argument. Probably Peter and I have different experiences with the completeness of datasets, but

Re: [R] change the colour line in gamm4 plotting

2016-07-26 Thread Jim Lemon
Hi Maria, The "plot.gam" function doesn't use the "col" argument for lines, but does change the color of points in the second example on the help page. There doesn't seem to be an easy way to change the function to get what you want. Jim On Tue, Jul 26, 2016 at 11:47 PM, Maria Lathouri via

Re: [R] Ocr

2016-07-26 Thread boB Rudis
https://cran.rstudio.com/web/packages/abbyyR/index.html https://github.com/greenore/ocR https://electricarchaeology.ca/2014/07/15/doing-ocr-within-r/ that was from a Google "r ocr" search. So, yes, there are options. On Tue, Jul 26, 2016 at 6:43 PM, Achim Zeileis

[R] word stemming for corpus linguistics

2016-07-26 Thread Andy Wolfe
Hi list On a piece of work I'm doing in corpus linguistics, using a combo of texts by Gries "Quantitative Corpus Linguistics with R: A Practical Introduction" and Jockers "Text Analysis with R for Students of Literature", which are both really excellent by the way, I want to stem or lemmatize

Re: [R] R version 3.2.5

2016-07-26 Thread Loris Bennett
Maria Alice Jacques writes: > Good night, > > How can I download and install R version 3.2.5 from cran mirror of > University of São Paulo, São Paulo? > > Thanks for your support. > > Maria Alice P. Jacques [snip (8 lines)] On this page https://cran.r-project.org/ you

Re: [R] word stemming for corpus linguistics

2016-07-26 Thread Andy Wolfe
Hi Paul I have seen this - it's part of the tm package mentioned originally. So, I've tried it again and perhaps I'm using stemDocument incorrectly, but this is what I am doing: # > library(tm) Loading required package: NLP > text.v <- scan(file.choose(), what = 'char', sep = '\n') Read 938

[R] knitr package error.

2016-07-26 Thread Shadrack Magut
hello, someone help me sort out this error "## Error in summary(data): object ’analysis’ not found"" in using Knitr package in R. I imported the data into R studio but as soon as i use any code involving the data i imported in the Knitr environment within the latex document i encounter the above

Re: [R] about netcdf files

2016-07-26 Thread David Winsemius
Please show code that allows potential responders to reply meaningfully. -- David > On Jul 25, 2016, at 9:54 PM, lily li wrote: > > Hi all, > > I have a problem in opening netcdf files. If one netcdf file contains > longitude, latitude, and daily precipitation. How to

Re: [R] about netcdf files

2016-07-26 Thread lily li
Thanks for your reply. But it says "Error in (function (classes, fdef, mtable)): unable to find an inherited method for function 'brick' for signature 'ncdf4' " The dataset is attached. It contains daily precipitation data for 20 years, within a rectangle, so that there are several grid points. I

Re: [R] Ocr

2016-07-26 Thread Achim Zeileis
On Wed, 27 Jul 2016, Shane Carey wrote: Cool, thanks Jim!! I would love to be able to write my own script for this as I have many images/ pdf's in a folder and would like to batch process them using an R script!! The underlying engine is "tesseract" which is also available as a command-line

Re: [R] about netcdf files

2016-07-26 Thread Roy Mendelssohn - NOAA Federal
Hi Lily: > On Jul 26, 2016, at 2:00 PM, lily li wrote: > > Here are the results. Yes, I tried to read netcdf files, but cannot grasp the > contents. Thanks for helping out. > > > str(pre1) A guide to netcdf files and R can be found at

Re: [R] about netcdf files

2016-07-26 Thread Roy Mendelssohn - NOAA Federal
Hi Lily: I doubt the mail-list would pass through the netcdf file. Instead, could you do the following, and post the results: library(ncdf4 pre1 = nc_open('sample_precip_daily.nc') str(pre1) nc_close(pre1) I have a feeling you haven't worked much with netcdf files. I will try to find a

Re: [R] Visualization of a Convex Hull in R (Possibly with RGL)

2016-07-26 Thread Duncan Murdoch
On 26/07/2016 10:34 AM, Lorenzo Isella wrote: On Tue, Jul 26, 2016 at 10:48:22AM +, Michael Sumner wrote: On Tue, 26 Jul 2016 at 20:29 Lorenzo Isella wrote: Dear All, I am not an expert about the calculation and visualization of convex hulls, but I am trying to

Re: [R] Ocr

2016-07-26 Thread Shane Carey
Cool, thanks Jim!! I would love to be able to write my own script for this as I have many images/ pdf's in a folder and would like to batch process them using an R script!! Thanks On Tuesday, July 26, 2016, Jim Lemon wrote: > Hi Shane, > FreeOCR is a really good place to

Re: [R] Date Time in R

2016-07-26 Thread Duncan Murdoch
On 26/07/2016 7:05 AM, Shivi Bhatia wrote: Hi Team, This scenario may have come across a number of times however i checked nabble & SO and couldn't find a solution hence request assistance. I have a date variable in my data-set eir. The class of this var was character while i had read the file

Re: [R] Visualization of a Convex Hull in R (Possibly with RGL)

2016-07-26 Thread Michael Sumner
On Tue, 26 Jul 2016 at 20:29 Lorenzo Isella wrote: > Dear All, > I am not an expert about the calculation and visualization of convex > hulls, but I am trying to do something relatively simple. > Please consider the snippet at the end of the email. > The array pts

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Thanks Duncan for the quick response. I will check again as you suggested. If that doesn't work i will share a reproducible example. Thanks again On Tue, Jul 26, 2016 at 4:43 PM, Duncan Murdoch wrote: > On 26/07/2016 7:05 AM, Shivi Bhatia wrote: > >> Hi Team, >>

Re: [R] about netcdf files

2016-07-26 Thread Jon Skoien
You could try with the brick function from the raster package. bvar = brick(netcdfName) This uses the ncdf4 functions for opening and reading the netcdf, but makes it easier to extract data for each day: p1 = rasterToPoints(bvar[[1]]) and write p1 to csv. Best, Jon On 7/26/2016 6:54 AM,

[R] Visualization of a Convex Hull in R (Possibly with RGL)

2016-07-26 Thread Lorenzo Isella
Dear All, I am not an expert about the calculation and visualization of convex hulls, but I am trying to do something relatively simple. Please consider the snippet at the end of the email. The array pts represents the position of (the centres of) a set of spheres in 3D (whose radius is 0.5). I

[R] Visualization of a Convex Hull in R (Possibly with RGL)

2016-07-26 Thread Lorenzo Isella
Dear All, I am not an expert about the calculation and visualization of convex hulls, but I am trying to do something relatively simple. Please consider the snippet at the end of the email. The array pts represents the position of (the centres of) a set of spheres in 3D (whose radius is 0.5). I

[R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Hi Team, This scenario may have come across a number of times however i checked nabble & SO and couldn't find a solution hence request assistance. I have a date variable in my data-set eir. The class of this var was character while i had read the file in r studio. Example of date - 05-30-16 To

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Hello Again, While i tried your solution as you suggested above it seems to be working. Here is the output temp<- dput(head(eir$date)) c("05-30-16", "05-30-16", "05-30-16", "05-30-16", "05-30-16", "05-30-16") however it still shows class(eir$date) as character and hence i cannot find weekdays

Re: [R] word stemming for corpus linguistics

2016-07-26 Thread Paul Johnston
Suggest look at http://www.inside-r.org/packages/cran/tm/docs/stemDocument -Original Message- From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Andy Wolfe Sent: 26 July 2016 08:10 To: r-help@r-project.org Subject: [R] word stemming for corpus linguistics Hi list On a

Re: [R] lm() silently drops NAs

2016-07-26 Thread Martin Maechler
I have been asked (in private) > Hi Martin, y <- c(1, 2, 3, NA, 4) x <- c(1, 2, 2, 1, 1) t.test(y ~ x) lm(y ~ x) > Normally, most R functions follow the principle that > "missings should never silently go missing". Do you have > any background on why these

[R] change the colour line in gamm4 plotting

2016-07-26 Thread Maria Lathouri via R-help
Dear all I am stuck probably in a simple plotting question My model is:model.1<-gamm4(y~s(x1, by=end.group)+Year+K1+k2+k3, data=.., random=~(1|WB_ID/Site_ID)) where y is my dependent variable, x1 is the smooth covariate and I use the by argument for the smooth term based on six different

[R] Error when installing packages

2016-07-26 Thread G . Maubach
Hi All, I try to install packages on Debian GNU Linux 8 (Kernel 3.16.0-4-amd64). My sessionInfo() is R version 3.3.1 (2016-06-21) Platform: x86_64-pc-linux-gnu (64-bit) Running under: Debian GNU/Linux 8 (jessie) locale: [1] LC_CTYPE=de_DE.UTF-8 LC_NUMERIC=C [3]

Re: [R] knitr package error.

2016-07-26 Thread Jeff Newmiller
The mailing list allows very few types of attachments through to limit virus problems. You need to learn how to convey your problem as a reproducible sequence of R statements to get clear assistance here. [1] In this case, you may be confused between the interactive working environment

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Thanks Marc for the help. this really helps. I think there is some issue with the data saved in csv format for this variable as when i checked: str(eir$date)- this results in :- Date[1:5327], format: NA NA NA NA NA. Thanks again. On Tue, Jul 26, 2016 at 5:58 PM, Marc Schwartz

Re: [R] Date Time in R

2016-07-26 Thread Marc Schwartz
Hi, That eir$date might be a factor is irrelevant. There is an as.Date() method for factors, which does the factor to character coercion internally and then calls as.Date.character() on the result. Using the example data below: eir <- data.frame(date = c("05-30-16", "05-30-16", "05-30-16",

Re: [R] word stemming for corpus linguistics

2016-07-26 Thread Paul Johnston
Hi I use the tm_map() with stemDocument used as an argument Looking at a particular file before stemming writeLines(as.character(data_mined_volatile[[1]])) ## The European Union is a "force for social injustice" which backs "the haves rather than the have-nots", Iain Duncan Smith has said.

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Hi Team, Please read wdy as wday it was mistakenly copied. On Tue, Jul 26, 2016 at 9:15 PM, Shivi Bhatia wrote: > Hi David please see the code and some reproducible data: > eir$date<- as.Date(eir$date,format = "%m-%d-%y") then i had used the > lubridate library to help

Re: [R] Date Time in R

2016-07-26 Thread Tom Wright
Hi again Shiva, I think what we need to see is the output from: str(eid$date) and perhaps head(eid$date) If you can send this information before doing any processing on the date (i.e. before the as.Date() function) we may be able to help. -Original Message- From: R-help

Re: [R] Date Time in R

2016-07-26 Thread David L Carlson
What does this produce? > readLines("YourCSVfilename.csv", n=5) If the data are in Excel, the date format used in .csv files is not always in the same as the format used when viewing dates in the spreadsheet. - David L Carlson Department of Anthropology

Re: [R] word stemming for corpus linguistics

2016-07-26 Thread Andy Wolfe
Hi Thanks for following up on this thread. I've opted for this, albeit circuitous, route: use the tm package to stem the document and then use writeCorpus to write the stemmed document to disk, so that I can open it up and do the concordancing piece. Many thanks - this'll do me fine until I

Re: [R] Visualization of a Convex Hull in R (Possibly with RGL)

2016-07-26 Thread Lorenzo Isella
On Tue, Jul 26, 2016 at 10:48:22AM +, Michael Sumner wrote: On Tue, 26 Jul 2016 at 20:29 Lorenzo Isella wrote: Dear All, I am not an expert about the calculation and visualization of convex hulls, but I am trying to do something relatively simple. Please consider

Re: [R] Error when installing packages

2016-07-26 Thread Ulrik Stervbo
Hi Georg, excel.link and installr: as far as I can tell from CRAN, excel.link and installr are for windows OS only 1-5: you are installing packages that are wrappers to system function/programms. They must be present on your system first. 2: Maybe Weka is missing in the path? Is your java

[R] Linear Dependance of Model Matrix and How Fitted/ Sums of Squares Follow

2016-07-26 Thread Justin Thong
Below is the covariates for a model ~x1+x2+x3+x4+x5+x6. I noticed that when fitting this model that the coefficient x6 is unestimable.*Is this merely a case that adding more columns to my model matrix will eventually lead to linear dependance so the more terms I have in the model formulae the more

Re: [R] Date Time in R

2016-07-26 Thread Tom Wright
So this looks correct so far. # convert strings (or factors) to a date object a1$date <- as.Date(a1$date, “%m-%d-%y”) # Note the date object is now displayed in the format %Y-%m-%d by default # so no need for the mdy() or ymd() function # extract the weekdays as number weekdays <-

Re: [R] Date Time in R

2016-07-26 Thread Hadley Wickham
I'd recommend reading up on how to create a minimal reproducible example (e.g. http://r4ds.had.co.nz/exploratory-data-analysis.html). It is unlikely anyone will be able to help you unless you can reliably communicate _exactly_ what you're doing. Unlike human languages, computer languages are

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Hello Tom, Please find the details: (i have changed name from eir to a1, rest all is same) str(a1$date) Factor w/ 32 levels "05-30-16","05-31-16",..: 1 1 1 head(a1$date) 05-30-16 05-30-16 05-30-16 05-30-16 05-30-16 05-30-16 32 Levels: 05-30-16 05-31-16 06-01-16 06-02-16 06-03-16 06-04-16

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Thanks Tom for the recommendation. This is now working. Apologies if this sounds like a juvenile but i am not very good with dates in R. What i initially did when i saw date as factor and then tried converting with lot many transformation that is where it went bad. But thanks to all this is

[R] R3.3.1 - Windows10 OS - Overriding default Legend title with user specified title

2016-07-26 Thread udhayakanth reddy
Team - Could you please do the needful. I have a below code using ggplot2() package. I am trying to plot between the variables - 'Company Advertising' and 'Brand Revenue' of my data frame 'htmltable' , when the another variable 'Industry' is 'Luxury'; using ggplot() function. I am using another

Re: [R] Date Time in R

2016-07-26 Thread William Dunlap via R-help
Can you show us what transformations you tried when you saw the column called 'date' was a factor? Bill Dunlap TIBCO Software wdunlap tibco.com On Tue, Jul 26, 2016 at 9:33 AM, Shivi Bhatia wrote: > Thanks Tom for the recommendation. This is now working. > > Apologies if

Re: [R] Date Time in R

2016-07-26 Thread David L Carlson
Show us the output, don’t just tell us what you are seeing. If the dates are correct in the csv file, show us the structure of the data frame you created with read.csv() and show the command(s) you used to convert the character data to date format. The solution is likely to be simple if you

Re: [R] Date Time in R

2016-07-26 Thread Nordlund, Dan (DSHS/RDA)
You still seem to be having problems, so where is the promised reproducible example? Dan Daniel Nordlund, PhD Research and Data Analysis Division Services & Enterprise Support Administration Washington State Department of Social and Health Services > -Original Message- > From: R-help

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Hi David please see the code and some reproducible data: eir$date<- as.Date(eir$date,format = "%m-%d-%y") then i had used the lubridate library to help with the dates: install.packages("lubridate") library(lubridate) eir$date <- mdy(eir$date) weekdays <- wdy(eir$date) week names <- wdy(eir$date,

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
Hi Bill, I have mentioned the transformation all on the email above. Regards, Shivi On Tue, Jul 26, 2016 at 10:19 PM, William Dunlap wrote: > Can you show us what transformations you tried when > you saw the column called 'date' was a factor? > > Bill Dunlap > TIBCO

Re: [R] Date Time in R

2016-07-26 Thread Shivi Bhatia
These are some of the codes will i have eir$date<- as.Date(eir$date, "%d-%m-%Y") class(eir$date) eir$week<- (eir$date) eir$week<- weekdays(as.Date(eir$week)) eir$week<- as.factor(eir$week) On Tue, Jul 26, 2016 at 10:24 PM, Shivi Bhatia wrote: > Hi Bill, > > I have

[R-es] Exportar datos en formato de Excel

2016-07-26 Thread Alexa Aristizabal
Buenos días a todos! Estoy trabajando con una base de datos que directamente he descargado de internet y después de prepararla un poco necesito exportarla a Excel he intentando con las dos opciones que mencionaré al final pero ninguna funciona, de qué otra manera puedo exportar esos datos a

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Isidro Hidalgo Arellano
Te recomiendo el paquete "openxlsx". Verás que es muy sencillo de utilizar. En la página "https://cran.r-project.org/web/packages/openxlsx/index.html; tienes las vignettes, los ejemplos son instantáneos: https://cran.r-project.org/web/packages/openxlsx/vignettes/Introduction.pdf Un saludo Isidro

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Carlos Ortega
Puedes utilizar esa alternativa con paquetes que conectan con "Excel" y otra muy directa es exportar tu data.frame a un "csv" que directamente puedes importar cómodamente en Excel... Para hacer esto con la función "write()" y asociadas puedes hacerlo sin problemas Saludos, Carlos Ortega

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Javier Martínez-López
Yo utilizo este script, done 'DataFrame' es el df que quieres guardar: library(XLConnect) fileXls <- "newFile.xlsx" unlink(fileXls, recursive = FALSE, force = FALSE) exc <- loadWorkbook(fileXls, create = TRUE) createSheet(exc,'Data') saveWorkbook(exc) writeWorksheet(exc, DataFrame, sheet =

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Javier Martínez-López
que raro... se te ha instalado bien la librería? tiene pinta de un problema de JAVA pero no sé cuál... 2016-07-26 13:46 GMT+02:00 Alexa Aristizabal : > Hola Javier, de antemano muchas gracias por tu ayuda! :) > > He intentado replicar tu script pero sale el

Re: [R-es] Vision por computador

2016-07-26 Thread Fernando Fernández
Hola, Llevo trabajando en este área los últimos dos años. C++ y Python son los lenguajes más adecuados para trabajar con OpenCV y con CV en general (ojo, digo en general, no digo que para imagen médica por ejemplo no pueda haber cosas interesantes en R). Yo uso R para cosas puntuales como el

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Javier Martínez-López
Yo utilizo este script, done 'DataFrame' es el df que quieres guardar: library(XLConnect) fileXls <- "newFile.xlsx" unlink(fileXls, recursive = FALSE, force = FALSE) exc <- loadWorkbook(fileXls, create = TRUE) createSheet(exc,'Data') saveWorkbook(exc) writeWorksheet(exc, DataFrame, sheet =

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Mauricio Monsalvo
Hola. En mi caso, no he podido resolver los problemas con el Java para usar XLConnect, que en los papeles me parece el mejor. Supongo que algo de la arquitectura del sistema o bien de la relación entre el Java, el R y el RStudio. Así que utilizo library(openxlsx) write.xlsx(datos, file =

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Mauricio Monsalvo
Yo uso Windows, que suele ser la explicación de todos los males... Voy a intentar pasarme a XLConnect y si resulta, lo comparto. De todos modos, para leer y guardar como un xlsx eñ openxlsx con RTools funciona bien. El 26 de julio de 2016, 11:44, Javier Martínez-López <

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Fernando Macedo
Que error te dá el uso de xlsx? Lo he probado tanto en windows 10 como en Ubuntu 16.04 y no he tenido problemas. Saludos Fernando Macedo El 26/07/16 a las 07:22, Alexa Aristizabal escribió: Buenos días a todos! Estoy trabajando con una base de datos que directamente he descargado de

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Javier Martínez-López
vaya, pues no sé, yo uso Ubuntu Linux 14.04 con Oracle Java 1.8 instalado, a lo mejor con windows da problemas pero el script funciona bien. Puede ser que tengáis que añadir el JAVA_HOME al path? 2016-07-26 16:39 GMT+02:00 Mauricio Monsalvo : > Hola. > En mi caso, no he

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Manuel Spínola
Hola, Yo estoy usando la librería rio y la función export es muy práctica. Manuel Spínola El 26 de julio de 2016, 8:39, Mauricio Monsalvo escribió: > Hola. > En mi caso, no he podido resolver los problemas con el Java para usar > XLConnect, que en los papeles me parece

Re: [R-es] Exportar datos en formato de Excel

2016-07-26 Thread Javier Marcuzzi
Estimados Exportar a Excel desde R es posible, pero muchas opciones utilizan java, y este lenguaje últimamente tiene algunos problemas, yo experimente inconvenientes al exportar desde R a Excel en Windows 10. Aunque también tengo inconvenientes por otros lados, por ejemplo ideaJ y netbeans me