Reading a tab separated file in R

r tab-delimited
Misha picture Misha · Jul 4, 2018 · Viewed 8.4k times · Source

I'm trying to read a file in R but the fourth record appears as a new line (see attached). After the third line, there's no tab, just two spaces. I'm using this code: 

df = read.delim("text.txt", header = FALSE, stringsAsFactors = FALSE, quote = "")

UPDATE: the third line has "¬" at the end.

enter image description here

Answer

Shinobi_Atobe picture Shinobi_Atobe · Jul 4, 2018

use the sep argument of read.delim to specify the separator. in this case you would need 

df = read.delim("text.txt", header = FALSE, stringsAsFactors = FALSE, quote = "", sep = "\t")

Related questions

writing to a tab-delimited file or a csv file

I have a RMA normalized data ( from the CEL files ) and would like to write it into a file that I could open in excel but have some problems. library(affy) cel <- ReadAffy() pre<-rma(cel) write.…

Read More
Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
Drop data frame columns by name

I have a number of columns that I would like to remove from a data frame. I know that we can delete them individually using something like: df$x <- NULL But I was hoping to do this with …

Read More