I have a function that relies on cutting the datetime using temporal bins. Unfortunately, it's behaving differently in Ubuntu and Windows. Here's a reproducible example of the error (Instead of getting 2023-01-03 00:00:00 we get 2023-01-03). datetimes <- seq(from =…
I am working with the R programming language and trying to learn about how to use Selenium to interact with webpages. For example, using Google Maps - I am trying to find the name, address and longitude/latitude of all Pizza…
I have multiple csv files (1 file for each city) having following structure. An example of two out of many files: CSV File 1: City_Name Pop PopDen Lit MI 45000 280 78 MI 37000 310 89 ... ... CSV File…
I'm trying to extract some data for a little research project in real estate economics and would like to get the price, the lot area, the description, the location, etc., out of <script type="application/ld+json">. I know I can use CSS…
I'm running R code in a .qmd file using VS Code and plot results using r.plot.useHttpgd. In various cases I get an *** caught segfault *** error. Reproducible example library(spatstat) plot(amacrine) # This works fine plot(unmark(amacrine)) # It crashes here…
I'm creating some slides using Quarto and the revealjs format. There is some analysis text in the left-hand side column which I'd like to have a background colour. The background box should extend to a set length rather than finish…
I've setup an image pushed to the ECR and then is used by my lambda function. My scripts include a custom runtime in R, my lambda function, and a bootstrap file to change the working directory to $LAMBDA_TASK_ROOT. I'm a…
I am trying to query the Cameo database. If I use the URL https://cameo.mfa.org/api.php?action=query&pageids=17051&prop=extracts&format=json, then I get, online, a valid output. However, if I use: library(httr) library(jsonlite) base_url <- "https://cameo.mfa.org/api.php" query_param <- list(action = "query", pageids = "17051", format =…
I am working with the R programming language. For the following website : https://covid.cdc.gov/covid-data-tracker/ - I am trying to get all versions of this website that are available on WayBackMachine (along with the month and time). The final result should…
The problem is that putting queries together, I got this "error: cannot insert multiple commands into a prepared statement". What can I do? q1=" set search_path to care; SELECT COALESCE(c.date,a.date,jq.date,jn.date) reportmonth,registration,emailverified,application,submitted,eligible,jqtest,selected,joined from ( SELECT date_trunc('month', createdon)::date as date, count(1) as…