r Questions

Efficient conversion of json data in R

March 17, 2024
ECII
2 Answers

I use R to process log files of zigbee2mqtt which logs entries like this head(data) [1] "info 2024-03-11 14:08:01: MQTT publish: topic 'zigbee2mqtt/TempBadEG', payload '{"battery":17,"humidity":50.1,"linkquality":105,"temperature":17.25,"voltage":2500}'" [2] "info 2024-03-11 14:08:04: MQTT publish: topic 'zigbee2mqtt/MotionBadOben', payload '{"battery":20,"battery_low":true,"illuminance":37914,"illuminance_lux":12369,"led_control":"off","linkquality":69,"occupancy":false,"occupancy_timeout":60,"tamper":false,"temperature":17,"update":{"installed_version":262147,"latest_version":262146,"state":"idle"},"voltage":2600}'" [3] "info 2024-03-11 14:08:04: MQTT…

VIEW QUESTION

Trouble with connecting R to MySQL database using tcpl R package

March 16, 2024
nasjam
2 Answers

I have a database stored in MySQL and need to connect to it in R using the tcpl R package. I tried connecting using the following: tcplConf(user='root', password= YOUR_PW, db='prod_internal_invitrodb_v4_1', drvr='MySQL', host='localhost') This however keeps giving an error: Error: Failed…

VIEW QUESTION

Html – Taking Screenshots from Stackoverflow using R

March 14, 2024
stats_noob
2 Answers

I am working with the R programming language. Suppose I take the answer from this stackoverflow post (from u/Michael Hardy): https://math.stackexchange.com/a/62963/1296713 Using R and the hyperlink (i.e. https://math.stackexchange.com/a/62963/1296713 ), I want to take this answer (only the answer, not the…

VIEW QUESTION

Javascript – How to use Tooltip with virtualSelectInput in R Shiny to show filter values if text is long and hidden by ellipsis

March 8, 2024
shubham
2 Answers

I've a R shiny application in which I am using virtualSelectInput to show list of values for my filter. But some of my text values are long and the dropbox hides them by ellipsis(...). I see that the Virtual Select…

VIEW QUESTION

Javascript – How to expand numeric input validation when generating a table using rhandsontable?

March 5, 2024
Village.Idyot
2 Answers

I started using hot_validate_numeric() of the rhandsontable package and it is proving to be very useful for user input validation. Per the below MWE code, the user can only input numeric values ranging from 1 to 10, and if the…

VIEW QUESTION

Html – How can I scrape a table from the website in the question

February 22, 2024
MCP_infiltrator
2 Answers

I am trying to copy a table from a webpage, there are going to be many as I am trying to get the versions of the data for each dataset, I am trying to get at least one table but…

VIEW QUESTION

Parse simple JSON into dataframe with R

February 20, 2024
tic-toc-choc
2 Answers

A seemingly simple JSON file that I would like to parse with R: tmp_extract <- "{"encrypted_values":[{"name_a":"value_a"}, {"name_b":"value_b"}, {"name_c":"value_c"}]}" An attempt with jsonlite::fromJSON produces a dataframe with as many columns as there are names and only a value per column. tmp_extract…

VIEW QUESTION

Twitter-api – R – Use Twitter API to get every tweet from an account

February 15, 2024
Indescribled
2 Answers

My goal is to get EVERY tweet ever for any twitter account. I picked the NYTimes for this example. The code below works, but it only pulls the last 100 tweets. max_results does not allow you to put a value…

VIEW QUESTION

Postgresql – is there a way to use lubridates:floor_date() in a postgres backend with non-standart units like '2 month'? or good alternatives?

February 15, 2024
mcmurphy
2 Answers

is there a way to use lubridates:floor_date() in a postgres backend with non-standart units like '2 month'? or good alternatives?? I have a lazy tbl with a date column and want to group this column by x months. Like so..…

VIEW QUESTION

Photoshop – Stacked barplot from 2 dataframes using 3 variables

February 2, 2024
Kristina
2 Answers

I am looking to create a bar plot in R combining data from 2 different dataframes plus using a third variable as fill. The data: all_spp <- data.frame(NAME=c("A", "B", "C", "D"), spp=c(9, 5, 8, 6), cat=c("I", "II", "III", "IV") )…

VIEW QUESTION