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 | | |

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-es] Paquetes de R para análisis de encuestas y minería de texto

2020-07-18 Thread Jorge I Velez
Hola Manuel, Mira http://r-survey.r-forge.r-project.org/survey/index.html para la primera pregunta y - https://cran.r-project.org/web/views/NaturalLanguageProcessing.html - https://www.tidytextmining.com/ - https://hub.packtpub.com/9-useful-r-packages-for-nlp-text-mining/ para la

[R-es] Paquetes de R para análisis de encuestas y minería de texto

2020-07-18 Thread Manuel Spínola
Estimados miembros del grupo, Quería preguntarles por sugerencias de paquetes para: 1. Análisis de encuestas o cuestionarios 2. Minería de texto Muchas gracias y slaudos Manuel Spínola -- *Manuel Spínola, Ph.D.* Instituto Internacional en Conservación y Manejo de Vida Silvestre Universidad

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

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

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

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

Re: [R] levels

2020-07-18 Thread andy elprama
Thanks, I will check it out. Op za 18 jul. 2020 om 00:47 schreef Chris Gordon-Smith < c.gordonsm...@gmail.com>: > There is an interesting item on stringsAsFactors in this useR! 2020 > session: > > https://www.youtube.com/watch?v=X_eDHNVceCU=youtu.be > > It's about 27 minutes in. > > Chris