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
Is the file being saved as .xls, .xlsx, .csv, .tsv, or .txt?
On Wed, Dec 26, 2018 at 10:14 PM Spencer Brackett <
spbracket...@saintjosephhs.com> wrote:
> Follow up,
>
> Would read.txt also work, as I am certain that I have both datasets in
> .txt files? As to a previous users question concern th
Follow up,
Would read.txt also work, as I am certain that I have both datasets in .txt
files? As to a previous users question concern the .csv nature of the
supposed excel file, I am uncertain as to how this was translated as such.
The file is most certainly in excel.
On Thu, Dec 27, 2018 at 12:
Caitlin,
I tried your command in both RGui and RStudio but both came up as errors.
I believe I made a mistake somewhere I labeling/downloading the files,
which is the source of the confusion in R. I will re-examine the files
saved on my desktop to determine the error. Regardless, would it be bet
Does this help Spencer? The read.delim() function assumes a tab character by
default, but I specifically included it using the read.csv function. The
downloaded file is NOT an Excel file so this should help.
GBM_protein_expression <- read.csv("C:/Users/Spencer/Desktop/GBM
protein_expression.tsv
this is wrong because the file is a csv file. read_excel is designed
for xls files.
GBM_protein_expression <- read_excel("C:/Users/Spencer/Desktop/GBM
protein_expression.csv")
How did you get a csv? it downloads as tsv.
the statement you should use is in base, no library() statement is needed.
Sorry, my mistake.
So I could still use read.table and should I try using a .txt version of
the file to avoid the silent changes you described?
Also, when I tried to simply this process by downloading the dataset onto
RStudio opposed to R (Gui) I received the following...
library(readxl)
> GBM_p
Please always reply-all to keep the list involved.
If you used Save As to change the data format to Excel AND the file extension
to xlsx, then yes, you should be able to read with readxl. I don't recommend
it, though... Excel often changes data silently and in irregularly located
places in your
CSV and TSV are not Excel files. Yes, I know Excel will open them, but that
does not make them Excel files.
Read a TSV file with read.table or read.csv, setting the sep argument to "\t".
On December 26, 2018 7:26:35 PM PST, Spencer Brackett
wrote:
>I tried importing the file without preview an
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
10 matches
Mail list logo
