similar to: Copy data from Excel

Displaying 20 results from an estimated 10000 matches similar to: "Copy data from Excel"

2009 Sep 24
2
Downloading data from from internet
Hi all, I want to download data from those two different sources, directly into R : http://www.rateinflation.com/consumer-price-index/usa-cpi.php http://eaindustry.nic.in/asp2/list_d.asp First one is CPI of US and 2nd one is WPI of India. Can anyone please give any clue how to download them directly into R. I want to make them zoo object for further analysis. Thanks, -- View this message in
2012 Aug 15
4
Import Data from Excel
Dear all, I want to import just part of an excel data file into R. I would like to have the data imported without rownames or colume names. I used read.delim("clipboard", header=F). Somehow even though I added the argument "header=F", I still have the row names V1, V2, ..., Does anyone know how to fix this? Thanks very much in advance. Hannah [[alternative
2009 Jul 29
3
Transporting data in different R windows
Hi, I am working with multiple R-windows opened and would like to transport some variables from one to another. Is there any direct way to do this without saving them in hard-disk? Thanks -- View this message in context: http://www.nabble.com/Transporting-data-in-different-R-windows-tp24719077p24719077.html Sent from the R help mailing list archive at Nabble.com.
2010 Mar 22
2
Why "\\" instead of simple "/" to specify a file path
Hi all, I have saved my workplace in a .RData format. However if I want to open that, I need to use following code : load("C:\\......") Here my question is why "\\". In all the time generally we use "/" like when we use read.delim() function etc. Is there any possibility to have some consistency there? Is there any other way to re-open the .RData file? Thanks, --
2007 Jan 12
1
R editor vs. Tinn-R
Have you used Tinn-R and what landmines await the inexperienced? I could not understand why a script that used to work stopped working. Look at these two scenarios I opened an excel spreadsheet and copied several cells to the clipboard Then Scenario 1 Executed from Tinn-R > prelim<-read.delim("clipboard") > str(prelim) 'data.frame': 0 obs. of 1 variable: $
2009 Sep 18
1
Reading clipboard with read.delim("clipboard") crash (PR#13957)
Full_Name: Liam Gretton Version: 2.9.2 OS: openSUSE 11.1 (x86_64) Submission from: (NULL) (143.210.13.77) Reading a large number of rows of delimited data via the clipboard results in a segfault or double free error. I've tested copying from various applications, but gedit will do. This problem exists in the openSUSE-supplied 2.8.1, I've just built 2.9.2 to see if it's still there,
2006 Aug 26
2
Importing data from clipboard on Mac OSX
Dear R users, I am trying to get data from the clipboard into R on MacOSX. I tried the following, but got an error message: read.delim("clipboard") Error in file(file, "r") : unable to open connection In addition: Warning message: unable to contact X11 display Obviously, I'm not running R using X11. I'm wondering, can I import data from the clipboard on MacosX?
2016 Apr 14
2
R y Excel - paquete openxlsx
Y muchas veces, se guardan los datos en esas hojas excel, donde los usuarios, que no son estadísticos, que no conocen R y no lo van a conocer completan esos excel. Es más cómodo hacer que guarden los datos en esos ficheros fijos respetando ciertas reglas en cuanto a formatos, estando dichos ficheros en ubicaciones fijas y llamar los datos desde R directamente a los archivos en sí, que tener que
2018 Mar 04
3
Change Function based on ifelse() condtion
Below is my full implementation (tried to make it simple as for demonstration) Lapply_me = function(X = X, FUN = FUN, Apply_MC = FALSE, ...) { if (Apply_MC) { return(mclapply(X, FUN, ...)) } else { if (any(names(list(...)) == 'mc.cores')) { myList = list(...)[!names(list(...)) %in% 'mc.cores'] } return(lapply(X, FUN, myList)) } } Lapply_me(as.list(1:4), function(xx) { if (xx ==
2010 Jul 10
7
Need help on date calculation
Hi all, please see my code: > library(zoo) > a <- as.yearmon("March-2010", "%B-%Y") > b <- as.yearmon("May-2010", "%B-%Y") > > nn <- (b-a)*12 # number of months in between them > nn [1] 2 > as.integer(nn) [1] 1 What is the correct way to find the number of months between "a" and "b", still
2018 Mar 04
0
Change Function based on ifelse() condtion
The reason that it works for Apply_MC=TRUE is that in that case you call mclapply(X,FUN,...) and the mclapply() function strips off the mc.cores argument from the "..." list before calling FUN, so FUN is being called with zero arguments, exactly as it is declared. A quick workaround is to change the line Lapply_me(as.list(1:4), function(xx) { to Lapply_me(as.list(1:4),
2010 May 24
2
import data from a csv file
Hi all, I have some trouble reading data from a csv file. I used command "read.delim("clipboard") to read in the data. > aalpha.data <- read.delim("clipboard") > class(aalpha.data) [1] "data.frame" > dim(aalpha.data) [1] 8 25 > colnames(aalpha.data) [1] "X" "V1" "V2" "V3" "V4"
2018 Mar 04
2
Change Function based on ifelse() condtion
My modified function looks below : Lapply_me = function(X = X, FUN = FUN, Apply_MC = FALSE, ...) { if (Apply_MC) { return(mclapply(X, FUN, ...)) } else { if (any(names(list(...)) == 'mc.cores')) { myList = list(...)[!names(list(...)) %in% 'mc.cores'] } return(lapply(X, FUN, myList)) } } Here, I am not passing ... anymore rather passing myList On Sun, Mar 4, 2018 at 10:37 PM,
2019 Oct 17
2
Installing R in Ubuntu
Thanks for this. I have downloaded the r-base-core_3.6.1-3disco_amd64.deb file and placed in /var/cache/apt/archives Next I ran below code in Ubuntu sudo apt-get install -f /var/cache/apt/archives/r-base-core.deb But this is failing with below message - E: Unsupported file /var/cache/apt/archives/r-base-core.deb given on commandline Could you please help resolve this? On Thu, Oct 17, 2019 at
2007 Nov 29
6
MS Excel Data
I am using MS Excel (Windos Operating system), how I import/export data between MS_Excel and R. Regds Faisal Afzal SIddiqui +92-300-9297089 fasidfas at yahoo.com ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page.
2018 Mar 04
2
Change Function based on ifelse() condtion
@Eric - with this approach I am getting below error : Error in FUN(X[[i]], ...) : unused argument (list()) On Sun, Mar 4, 2018 at 10:18 PM, Eric Berger <ericjberger at gmail.com> wrote: > Hi Christofer, > You cannot assign to list(...). You can do the following > > myList <- list(...)[!names(list(...)) %in% 'mc.cores'] > > HTH, > Eric > > On Sun, Mar
2010 Mar 22
2
Fw: Re: Why "\\" instead of simple "/" to specify a file path [modified]
Hi, I was following this thread and would like to ask is there any way to save and open a .RData file after using some Password. What I mean to say, how to make my workplace password-protected? Also would like to know how same can be done for .R file. Thanks for your time. Thanks and regards, --- On Tue, 23/3/10, David Winsemius <dwinsemius@comcast.net> wrote: From: David Winsemius
2012 Dec 14
5
A question on list and lapply
Dear all, let say I have following list: Dat <- vector("list", length = 26) names(Dat) <- LETTERS My_Function <- function(x) return(rnorm(5)) Dat1 <- lapply(Dat, My_Function) However I want to apply my function 'My_Function' for all elements of 'Dat' except the elements having 'names(Dat) == "P"'. Here I have specified the name
2017 Aug 02
4
Extracting numeric part from a string
Hi again, I am struggling to extract the number part from below string : "\"cm_ffm\":\"563.77\"" Basically, I need to extract 563.77 from above. The underlying number can be a whole number, and there could be comma separator as well. So far I tried below : > library(stringr) > str_extract("\"cm_ffm\":\"563.77\"",
2012 Mar 16
4
How to start R in maximized size???
Dear all, when I start R, I want that the console window should be in the Maximized size automatically. Can somebody help me how to achieve that? Thanks and regards,