read.csv, header on first line, skip second line [duplicate]

by

This should do the trick:

all_content = readLines("file.csv")
skip_second = all_content[-2]
dat = read.csv(textConnection(skip_second), header = TRUE, stringsAsFactors = FALSE)

The first step using readLines reads the entire file into a list, where each item in the list represents a line in the file. Next, you discard the second line using the fact that negative indexing in R means select all but this index. Finally, we feed this data to read.csv to process it into a data.frame.

More Related Contents:

  1. How can I read the header but also skip lines – read.table()?
  2. Specify custom Date format for colClasses argument in read.table/read.csv
  3. ‘Incomplete final line’ warning when trying to read a .csv file into R
  4. Invalid multibyte string in read.csv
  5. How to read only lines that fulfil a condition from a csv into R?
  6. Specifying colClasses in the read.csv
  7. Why am I getting X. in my column names when reading a data frame?
  8. read.csv doesn’t seem to detect factors in R 4.0.0
  9. How to check if CSV file has a comma or a semicolon as separator?
  10. How to detect the right encoding for read.csv?
  11. Combine several data frames in the global environment by row (rbind)
  12. Imported a csv-dataset to R but the values becomes factors
  13. Weird error in R when importing (64-bit) integer with many digits
  14. Finding y-hat in R [closed]
  15. ggplot2 line chart gives “geom_path: Each group consist of only one observation. Do you need to adjust the group aesthetic?”
  16. How can I match fuzzy match strings from two datasets?
  17. Remove parentheses and text within from strings in R
  18. Explain ggplot2 warning: “Removed k rows containing missing values”
  19. How to efficiently use Rprof in R?
  20. How to drop columns by name pattern in R?
  21. Angle between two vectors in R
  22. double dots in a ggplot
  23. Specifying column names in a data.frame changes spaces to “.”
  24. Function to split a matrix into sub-matrices in R
  25. Collect All user inputs throughout the Shiny App
  26. Change the default colour palette in ggplot
  27. Row-wise sort then concatenate across specific columns of data frame
  28. Amazon Product API with R
  29. Convert a dataframe to an object of class “dist” without actually calculating distances in R
  30. How can I resolve the “No Font Name” issue when importing fonts into R using extrafont?

Leave a Comment