OHDSI Home | Forums | Wiki | Github

Read concept table in R

vocabularies

(Mehrdad Forouzanfar) #1

Hello,

I am new, trying to implement OMOP. I try to read and upload concept table to the database using R but it doesn’t read all lines correctly and ends up with huge cells, apparently fails to dissect some lines. I couldn’t find the solution in the forum.

I ran this command:
read.table(“CONCEPT.csv”, header=T, fill=T, row.names=NULL,sep="\t")
I have used variety of commands like read.csv with different sep , before/after java run and …

I appreciate your comments!

Best,
Mehrdad


(Mehrdad Forouzanfar) #2

Hello,

it seems “fread” from “data.table” package is the solution. (At least works for me).
Here is the command.
tab <- fread(“CONCEPT.csv”, header=T )

Mehrdad


t