Posts by Theorp • 83 points
8 posts
-
0
votes0
answers201
viewsQ: Inner Join - Allocate vector to R
I am trying to make an inner_join between two tables by a common "state code" column. However, it is giving an error of "allocate vector of size 1.4 Gb". Code: arquivo_antigo_filtrado<-…
-
-2
votes1
answer47
viewsQ: Successfully recorded bank warning - R
Hello! I am currently recording/updating my tables in the database with the R language: dbWriteTable(con, "tabela",tabela, row.names=FALSE, overwrite = TRUE) This my script that updates the tables…
-
3
votes1
answer89
viewsQ: Last characters of a data.frame column in R
I have a table within a date.frame, and I need to get only the last two characters of that table, how do I do that? bs.: I was trying to do it using str_sub, but in it I can only define which…
-
0
votes0
answers39
viewsQ: R link between tables by date.frame
Hello! I have two tables in the database and they are linked by a FK, as I create a third data.frame with the data of both tables linked by FK. I mean, I have: dataframe1 <- tbl(con,…
-
1
votes0
answers37
viewsQ: Invalid character in R
I turn the [ ] character into an A letter, within a R data.frame. It works perfectly, though, when I create a ". bat" to run this algorithm automatically by windows tasks it displays the following…
-
0
votes0
answers23
viewsQ: Dimensional Table/Fact in R
Currently I have 4 data.frames that have ID and other data, and I intend to use dimensional model (known as star) to create a fact table with all the Ids. But the only way I thought about developing…
-
2
votes2
answers110
viewsQ: Auto increment in R
How do I generate an auto incremental ID field (1,2,3...) in a data.frame in R that in a new column? meuDataFrase<- as_tibble(unique(tabelImportada$ColunaX)) I need to create a new column on that…
-
1
votes1
answer49
viewsQ: Performance of conditionals in R: how to accelerate this process?
I am working with a data.frame with more than 29 million lines, and I need to do some validations exchanging the data if necessary, but I am using ifelse which is extremely slow, there is some way…