Re: [R] Advantages of using SQLite for data import in comparison to csv files

Thanks for your answer. I've thought of the possibility of an index when using a SQLite database, but as you mentioned, I don't really benefit from it in regard of rather small data sets. What I am considering as a problem when using csv files is the occurrence of data redundancy: When I wan't

[R] Advantages of using SQLite for data import in comparison to csv files

of organising the data in csv files? Is it for example possible to select values from a column within a certain range from a csv file using awk? Thanks in advance, Juliet Jacobson __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help

Re: [R] Advantages of using SQLite for data import in comparison to csv files

Thanks for your answer. I hadn't found this possibility by web search. Since sqldf also allows the import of tables from csv files, complex SELECT queries and even joins on tables, I have the impression that there aren't any reasons for using a SQLite database to organise the data for R. But then