How to read only lines that fulfil a condition from a csv into R?

by

You could use the read.csv.sql function in the sqldf package and filter using SQL select. From the help page of read.csv.sql:

library(sqldf)
write.csv(iris, "iris.csv", quote = FALSE, row.names = FALSE)
iris2 <- read.csv.sql("iris.csv", 
    sql = "select * from file where `Sepal.Length` > 5", eol = "\n")

More Related Contents:

  1. Specify custom Date format for colClasses argument in read.table/read.csv
  2. ‘Incomplete final line’ warning when trying to read a .csv file into R
  3. Invalid multibyte string in read.csv
  4. Specifying colClasses in the read.csv
  5. Why am I getting X. in my column names when reading a data frame?
  6. read.csv doesn’t seem to detect factors in R 4.0.0
  7. How to check if CSV file has a comma or a semicolon as separator?
  8. read.csv, header on first line, skip second line [duplicate]
  9. How to detect the right encoding for read.csv?
  10. How to plot with a png as background? [duplicate]
  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. Append lines to a file
  14. How can I read the header but also skip lines – read.table()?
  15. Weird error in R when importing (64-bit) integer with many digits
  16. How to read large (~20 GB) xml file in R?
  17. Error: could not find function … in R
  18. Sample from vector of varying length (including 1)
  19. Histogram with Logarithmic Scale and custom breaks
  20. Using R to list all files with a specified extension
  21. Get last row of each group in R [duplicate]
  22. Set certain values to NA with dplyr
  23. Faster weighted sampling without replacement
  24. Error in file(file, “rt”) : cannot open the connection [duplicate]
  25. What’s the difference between `1L` and `1`?
  26. How to deal with “data of class uneval” error from ggplot2?
  27. Get date difference in years (floating point)
  28. Numbers as column names of data frames
  29. Harnessing .f list names with purrr::pmap
  30. Recommended package for very large dataset processing and machine learning in R [closed]

Leave a Comment