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…
I am trying to extract the date from a html node using R. This script used to work fine and I think perhaps the webpage has changed somewhat and now it returns N/A. webpage = read_html('https://www.longpaddock.qld.gov.au/aussiegrass') results = webpage %>%…