readr::read_csv() adds first column X1 with row numbers

1.4k Views Asked by At

I am importing a csv file with read_csv() using the following command:

motus <- read_csv("motus_tables/TEST_metabar_motus_miseq_nov_12S.csv", 
                  col_names = TRUE,
                  progress = show_progress())

The issue is that this adds a first column X1 with numbers for the rows. I don't know why and I don't know how to fix it! I am trying to use this option instead of the read.table because the file I will have to read is huge and the read.table takes forever. I take any other suggestions as well to handle large csv files fast, with a progress bar being a plus!

I am running R v.3.6.2 in RStudio v.1.3

0

There are 0 best solutions below