Re: [R] Help with read.csv.sql()

2020-07-18 Thread Rasmus Liland
On 2020-07-18 18:09 +0100, Rui Barradas wrote: | Às 17:59 de 18/07/2020, H escreveu: | | On Fri, Jul 17, 2020 at 6:28 PM H wrote: | | | | | | The problem I am having is that | | | the csv files have header rows | | | with column names that are | | | slightly different from the column | | | na

Re: [R] [External] Re: read.csv fails in R console in Ubuntu terminal but works in RStudio after R 3.6.3 upgrade to R 4.0.2?

2020-07-18 Thread Sam H
This issue was now solved in TTR::stockSymbols() by package author https://github.com/joshuaulrich/TTR/commit/98dec2b5aa68c3cee750397c7d11b164895e0140 Thanks for all the help and ideas. Best, Sam On Fri, Jul 17, 2020, 13:54 Sam H wrote: > Hello, > > Thank you very much to you all to look into

Re: [R] Help with read.csv.sql()

2020-07-18 Thread William Michels via R-help
Do either of the postings/threads below help? https://r.789695.n4.nabble.com/read-csv-sql-to-select-from-a-large-csv-file-td4650565.html#a4651534 https://r.789695.n4.nabble.com/using-sqldf-s-read-csv-sql-to-read-a-file-with-quot-NA-quot-for-missing-td4642327.html Otherwise you can try reading thr

Re: [R] Help with read.csv.sql()

2020-07-18 Thread Rui Barradas
Hello, The documentation says the following. field.types A list whose names are the column names and whose contents are the SQLite types (not the R class names) of the columns. So argument field.types is a named list.  - The list members names are the column names of the table to be read.  

Re: [R] Help with read.csv.sql()

2020-07-18 Thread H
On 07/18/2020 11:54 AM, Rui Barradas wrote: > Hello, > > I don't believe that what you are asking for is possible but like Bert > suggested, you can do it after reading in the data. > You could write a convenience function to read the data, then change what you > need to change. > Then the functi

Re: [R] Help with read.csv.sql()

2020-07-18 Thread Rui Barradas
Hello, I don't believe that what you are asking for is possible but like Bert suggested, you can do it after reading in the data. You could write a convenience function to read the data, then change what you need to change. Then the function would return this final object. Rui Barradas Às 16

Re: [R] Help with read.csv.sql()

2020-07-18 Thread H
On 07/17/2020 09:49 PM, Bert Gunter wrote: > Is there some reason that you can't make the changes to the data frame > (column names, as.date(), ...) *after* you have read all your data in? > > Do all your csv files use the same names and date formats? > > > Bert Gunter > > "The trouble with having