similar to: Copy data from Excel

Hi, I am trying to the data from https://online.stat.psu.edu/onlinecourses/sites/stat501/files/ch15/employee.txt without any success. Below is the error I am getting: > read.delim('https://online.stat.psu.edu/onlinecourses/sites/stat501/files/ch15/employee.txt') Error in make.names(col.names, unique = TRUE) : invalid multibyte string at '<ff><fe>t' In

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

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

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.

That looks like a UTF-16LE byte order mark. Simply open the connection with the proper encoding: read.delim( 'https://online.stat.psu.edu/onlinecourses/sites/stat501/files/ch15/employee.txt', fileEncoding = "UTF-16LE" ) On Sat, Sep 7, 2024 at 3:57?PM Christofer Bogaso <bogaso.christofer at gmail.com> wrote: > > Hi, > > I am trying to the data from >

On 2024-09-07 7:37 p.m., Jeff Newmiller wrote: > I tried it on R 4.4.1 on Linux Mint 21.3 just before I posted it, and I just tried it on R 3.4.2 on Ubuntu 16.04 and R 4.3.2 on Windows 11 just now and it works on all of them. > > I don't have a big-endian machine to test on, but the Unicode spec says to honor the BOM and if there isn't one to assume that it is big-endian data.

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: $

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, --

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

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.

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,

Hi! Is it possible to easily cut & paste data from an Excel spreadsheet to an R edit( ) grid or to variable? It seems that R cannot handle the cell delimiters Excel hands over. Regards, Werner

When you specify LE in the encoding type, you are logically telling the decoder that you know the two-byte pairs are in little-endian order... which could override whatever the byte-order-mark was indicating. If the BOM indicated big-endian then the file decoding would break. If there is a BOM, don't override it unless you have to (e.g. for a wrong BOM)... leave off the LE unless you really

On Sun, 08 Sep 2024, Christofer Bogaso writes: > Hi, > > I am trying to the data from > https://online.stat.psu.edu/onlinecourses/sites/stat501/files/ch15/employee.txt > without any success. Below is the error I am getting: > >> read.delim('https://online.stat.psu.edu/onlinecourses/sites/stat501/files/ch15/employee.txt') > > Error in make.names(col.names,

Dear all I used to transfer data from excel to R by simple ctrl-c and read.delim("clipboard") construction. I know it is a bad practice but it is easy and for quick exploratory work it is OK. However after changing to new R devel few days ago I encountered weird behaviour. I tried one or two columns. In case of 2 columns, header is repeated after 526 items >

Hello again, My query may look quite generic, however at this point of time I just want explain my problem. I am hopeful that somebody can help me. Let say I have a script file 'Script.R'. Now I want R to run this script file each day at a specific time, and store the result (the calculation for the result are already in that script file) in excel (or may be csv file) for each day. Is

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?

Dear Sir, I’am a frensh student and i’am a new user of the R software. After using the command (x<-read.delim(“clipboard”) to read a spreadsheet of Excel, I want to run the bds test and calculate the Lyapunov exponent. I have charged the R software by the packages tseries and tseriesChaos. when i run bds.test(x,m=2) Unfortunately the R software displays “error in as.vector(x,mode= “double”) :

On 2024-09-07 4:52 p.m., Jeff Newmiller via R-help wrote: > When you specify LE in the encoding type, you are logically telling the decoder that you know the two-byte pairs are in little-endian order... which could override whatever the byte-order-mark was indicating. If the BOM indicated big-endian then the file decoding would break. If there is a BOM, don't override it unless you have to

Can anyone help me how to read xls file into R. I have tried following library(gdata) xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls') read.xls(xlsfile) I got following error: Converting xls file to csv file... Error in system(cmd, intern = !verbose) : perl not found Error in file.exists(tfn) : invalid 'file' argument Question *1) What is the way