Posts by George Santiago • 139 points
7 posts
-
2
votes2
answers24
viewsQ: Include "." or "," from right to left of integers
I have an array with the following integer values (or strings): x <- c("1781818", "178181800", "92561781818", "1781810") I’d like to put a semicolon to separate the last two digits, so they stay…
rasked George Santiago 139 -
1
votes1
answer87
viewsQ: Simultaneous threading (parallel processing) in R and serialized recording in Sqlite
Hey there, guys. I am trying to develop a code that makes it possible to perform parallel processing (parser) of HTML files using the R Language and, consecutively, record the data extracted from…
-
1
votes1
answer329
viewsQ: Insert two commands (INSERT and UPDATE) into the same instruction in Sqlite, via R Language
Hello, everybody I have a problem in knowing how to insert two commands (INSERT and UPDATE) in the same instruction in Sqlite, via R Language. I don’t know if this is impossible due to Sqlite or R’s…
-
2
votes1
answer259
viewsQ: How to handle errors during web scraping?
Hello, everyone. During the Web Scraping process, I started to come across some errors that occur during the request process. Currently, I have identified 4 types of frequent errors: Error in…
-
0
votes1
answer373
viewsQ: Convert monetary values "R$" to double type
Hello, I have several CSV files, in which were stored in some columns monetary values in real ex: "R$ 1.986,00". However, I intend to pass all CSV to Sqlite and then analyze the data in Power BI.…
-
3
votes2
answers195
viewsQ: Create a calendar dimension with the month before Sys.date.
Hello, the scrip below creates a CSV with a Calendar dimension from the year 2015 to the current month. It turns out that I would like the function to return the month before the execution. Ex: If…
-
3
votes1
answer102
viewsQ: Navigate between pages from a web page bar
How to browse pages that are in a web page bar? Specific case: When performing a query on the TCM-Ba website, on the page that records the expenses of municipalities, it is possible to access some…