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,