- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2023 06:20 AM
Hi,
I have a "simple" R script that I need to import into Databricks and am running into errors.
For example:
TipoB <- Techtb %>% dplyr::filter(grepl('being evaluated', Comentarios))
#TipoB$yearsSpec <- NA
TipoB$yearsSpec <- str_replace(TipoB$Comentarios,'[^♂]*being evaluated[^0-9]*',"")
TipoB$yearsSpec <- str_replace(TipoB$yearsSpec,'[ | \\n| \\t][^♂]*',"")
TipoB$yearsSpec <- str_replace(TipoB$yearsSpec,",",".")
TipoB$yearsSpec <- str_replace(TipoB$yearsSpec,"\\+","")
TipoB$yearsSpec <- str_replace(TipoB$yearsSpec,"YRS","")
TipoB$yearsSpec <- str_replace(TipoB$yearsSpec,"~","")
TipoB$yearsSpec <- as.numeric(TipoB$yearsSpec)
I manage to create the TipoB table normally. But then I can't create new columns as I do on Rstudio. I even tried to create an empty column before inserting the data but it did not work. I get this error:
SyntaxError: invalid syntax
File "<command-2335304911107903>", line 1
TipoB$yearsSpec <- NA
^
SyntaxError: invalid syntax
I can read the TipoB table so I know it is there. But why would I not be able to use the "$" symbol? Can anyone help and show me where I'm messing up?
Thanks a lot!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 10:41 AM
when you create a cluster, you will need to select aa DBR version. look for "Databricks Runtime version"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2023 10:44 PM
Hi, Could you please provide some more details on the configuration of the DBR version? R studio version? etc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 04:09 AM
R studio version 2022.12.0.
R latest version available on 08/FEB/2023.
I don't know where to find the DBR version and configuration. Can you direct me?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 10:41 AM
when you create a cluster, you will need to select aa DBR version. look for "Databricks Runtime version"

