Re: [R] you are making it far too difficult

2018-12-27 Thread Caitlin Gibbons
I would :) Sent from my iPhone > On Dec 27, 2018, at 2:34 PM, Spencer Brackett > wrote: > > So I should use “\t” proceeding on? > >> On Thu, Dec 27, 2018 at 4:30 PM Caitlin Gibbons >> wrote: >> “\t” is an escape sequence which signifies one tab character. “/t” is NOT an >> escape sequenc

Re: [R] you are making it far too difficult

2018-12-27 Thread Spencer Brackett
For future reference, I unpacked the full gene expression file from ICGC by directly downloading the following link protein_expression.GBM-US.tsv.gz, and then using the argument Mr. Heiberger layed out. Best, Spencer Brackett On Thu, Dec 27, 2018 at 4:30 PM Spencer Brackett < spbracket...@saint

Re: [R] you are making it far too difficult

2018-12-27 Thread Spencer Brackett
Thank you! On Thu, Dec 27, 2018 at 4:43 PM Sarah Goslee wrote: > \t is the symbol for a tab. > /t is two characters just as it seems. It's highly unlikely your file > is delimited with /t, which would look like > 1/t2/t3 > > The help for read.table mentions this tangentially as part of > read.de

Re: [R] you are making it far too difficult

2018-12-27 Thread Sarah Goslee
\t is the symbol for a tab. /t is two characters just as it seems. It's highly unlikely your file is delimited with /t, which would look like 1/t2/t3 The help for read.table mentions this tangentially as part of read.delim(), and you can find out more under ?regex - see the section about escaping

Re: [R] you are making it far too difficult

2018-12-27 Thread Spencer Brackett
So I should use “\t” proceeding on? On Thu, Dec 27, 2018 at 4:30 PM Caitlin Gibbons wrote: > “\t” is an escape sequence which signifies one tab character. “/t” is NOT > an escape sequence, and to R, looks like a very brief file path. > > Sent from my iPhone > > > On Dec 27, 2018, at 2:09 PM, Spe

Re: [R] you are making it far too difficult

2018-12-27 Thread Spencer Brackett
Mr. Heiberger, I followed your argument and it works. I received the same data. And yes, ICGC breakes their datasets into separate files based on data type. Thank you for the pointer on selecting all 50 rows, as I assumed that the entirety of gene expression data within the data set would be dow

Re: [R] you are making it far too difficult

2018-12-27 Thread Caitlin Gibbons
“\t” is an escape sequence which signifies one tab character. “/t” is NOT an escape sequence, and to R, looks like a very brief file path. Sent from my iPhone > On Dec 27, 2018, at 2:09 PM, Spencer Brackett > wrote: > > What is the significance of using / or \ ? > >> On Thu, Dec 27, 2018 at

Re: [R] you are making it far too difficult

2018-12-27 Thread Richard M. Heiberger
I downloaded the Donors dataset https://dcc.icgc.org/search?filters=%7B%22donor%22:%7B%22projectId%22:%7B%22is%22:%5B%22GBM-US%22%5D%7D,%22availableDataTypes%22:%7B%22is%22:%5B%22pexp%22%5D%7D%7D%7D by clicking "Export table as TSV". Then I read it with donors <- read.delim("~/Downloads/donors_

Re: [R] you are making it far too difficult

2018-12-27 Thread Spencer Brackett
What is the significance of using / or \ ? On Thu, Dec 27, 2018 at 4:02 PM Sarah Goslee wrote: > On Thu, Dec 27, 2018 at 2:03 PM Spencer Brackett > wrote: > > > > Thank you for the help! I tried using the read.table command in my > RStudio > > using the following argument, and managed to open t

Re: [R] you are making it far too difficult

2018-12-27 Thread Sarah Goslee
On Thu, Dec 27, 2018 at 2:03 PM Spencer Brackett wrote: > > Thank you for the help! I tried using the read.table command in my RStudio > using the following argument, and managed to open the file. > > GBM_protein_expression<-read.table(file.choose(), header=TRUE, sep=“/t”) Note that sep="/t" is N

Re: [R] you are making it far too difficult

2018-12-27 Thread Spencer Brackett
Mr. Calboli, After beginning to unpack the GBM file you sent me via directly importing it unit my console, I received the following: View(GBM_PEXP.tsv) **Note that I named the file GBM_PEXP.tsv)** Upon downloading, my script now contains a 2 by 2 table, with the x column still containing enco

Re: [R] you are making it far too difficult

2018-12-27 Thread Spencer Brackett
Thank you for the help! I tried using the read.table command in my RStudio using the following argument, and managed to open the file. GBM_protein_expression<-read.table(file.choose(), header=TRUE, sep=“/t”) However, my data did not unpack as yours did. I again only received a table of true and f

[R] Fwd: UPDATE

2018-12-27 Thread Spencer Brackett
I tried importing the file without preview and recieved the following library(readxl) > GBM_protein_expression <- read_excel("C:/Users/Spencer/Desktop/GBM protein_expression.csv") Error: Can't establish that the input is either xls or xlsx. > View(GBM_protein_expression) Error in View : object

Re: [R] Help converting .txt to .csv file

2018-12-27 Thread PIKAL Petr
Hi See inline > -Original Message- > From: R-help On Behalf Of Spencer Brackett > Sent: Thursday, December 27, 2018 3:57 AM > To: Richard M. Heiberger > Cc: R-help > Subject: Re: [R] Help converting .txt to .csv file > > Hello again, > > I worked on directly downloading the file into R