Stack Overflow
Stack Overflow

Questions tagged [bert-toolkit]

Use this tag if question is related to Basic Excel R Toolkit, calling R functions from Excel. Also add the excel and R tag for a broader audience. Do note: That the bert-rpc tag is another library that normally is not related, hence do not include it.

Basic Excel R Toolkit (BERT) is a toolkit to use R functions from Excel spreadsheet cells.

16 questions
3
votes
0 answers

BERT ggplot2 graphics

I have a question with my code in R, for a function that draws a graph in excel via BERT. library("ggplot2") # link the graphics to the calling cell, so it won't get erased # when another cell draws a plot BERT.graphics.device(cell=T) …
Neža Habjan
  • 41
  • 1
3
votes
1 answer

How can I load a library in R to call it from Excel with bert-toolkit?

Bert-toolkit is a very nice package to call R functions from Excel. See: https://bert-toolkit.com/ I have used bert-toolkit to call a fitted neuralnet (avNNnet fitted with Caret) within a wrapper function in R from Excel VBA. This runs perfect. This…
user2165379
  • 445
  • 4
  • 20
2
votes
1 answer

official module in tensorflow examples at tensorflow.org

I've been following a tensorflow tutorial https://www.tensorflow.org/official_models/fine_tuning_bert In the first code snippet, I saw a lot of imports from official module import numpy as np import matplotlib.pyplot as plt import tensorflow as…
devspartan
  • 594
  • 7
  • 15
2
votes
4 answers

How to write contents of data frame back to range?

I need to perform the following sequence: Open Excel Workbook Read specific worksheet into R dataframe Read from a database updating dataframe Write dataframe back to worksheet I have steps 1-3 working OK using the BERT tool. (the R scripting…
mikecro2
  • 31
  • 2
2
votes
1 answer

Reading an excel array with missing values into R using BERT interface

I am using BERT (Excel/R interface) to implement R functions into Excel. When a function such as eigen is applied to an array of numbers it works fine, but there is an error if there are missing value / strings in the Excel array. I want to remove,…
JLG
  • 37
  • 6
1
vote
4 answers

How to use tf-hub models locally

I,ve been trying to use a BERT model from tf-hub https://tfhub.dev/tensorflow/bert_en_uncased_L-12_H-768_A-12/2. import tensorflow_hub as hub bert_layer = hub.keras_layer('./bert_en_uncased_L-12_H-768_A-12_2', trainable=True) But problem is that it…
devspartan
  • 594
  • 7
  • 15
1
vote
2 answers

AttributeError: module 'tensorflow_core._api.v2.train' has no attribute 'Optimizer' when importing BERT

I'm am getting this error just in the being of importing my packages. I haven't been able to find the correct remedy to fix the issue. Any help is greatly appreciated. From what I can tell it looks to maybe be a Tensorflow issue? from…
Sam Russo
  • 31
  • 1
  • 6
1
vote
0 answers

Low accuracy of multi-classes classification on bert fine tuning model

I have a Chinese product dataset which contains around fifty thousand items and 1240 classes. And I use thirty-five thousand items to fine-tuning the BERT-BASE, Chinese. But I get a very low accuracy(accuracy 0.4%, global_step = 32728) on the…
Zhu Yun
  • 11
  • 2
1
vote
1 answer

BERT-R How to hide some functions from users?

Is it possible to hide functions from being shown in excel but that exist in the functions.R file? At the moment all functions are exposed to excel as R functions but I would like to be able to select which functions are exposed.
user9630195
  • 91
  • 5
1
vote
1 answer

BERT R script, How does environment and scope work?

I am having some issues understanding how BERT is handling R Environments. Ideally I would like to be able to run an R script via VBA, similar to a VBA Sub. I don't think BERT facilitates this. When I run below R script in BERT…
user9630195
  • 91
  • 5
1
vote
1 answer

How does dates handling using Excel scripting interface via BERT work?

I am having trouble understanding of how dates are handled. I understand that Excel handles dates differently from R. I am fine with reading in a date as a numerical value via R functions. For example, in a workbook sheet "Sheet1" cell A1 I can…
user9630195
  • 91
  • 5
1
vote
1 answer

R in BERT won't use na.rm=TRUE in sum function

I installed BERT (R-language to Excel interface). In the functions.R file that is included, i modified the included Add function to use the na.rm argument, as follows. Add <- function( ... ) { sum(..., na.rm=TRUE); } However, it appears that the…
TomCon
  • 13
  • 3
0
votes
0 answers

How compare variable according the dropdown list?

I have a df and I import it : Sub () Dim Path As Variant r = "df = read.csv('df')" Application.Run "BERT.Exec", r End Sub And I have some function like in Bert environment! c_1 <- function (var1,var2) { require(tidyverse) var1 <- enquo(var1) …
n_t
  • 1
  • 4
0
votes
1 answer

BERT delay in shape with graphic

I am having a problem moving a shape created by BERT in my VBA code. If I run the VBA macro that calls Bert to create the chart, and then submit in a second call for the code to move the shape, it works. If I try to combine the code it does not…
Aaron Moynahan
  • 1
  • 1
0
votes
1 answer

How to select range and output of any size?

I am calling an R function in Excel using VBA code Application.run("BERT.Call",..). It is working successfully. But to do this, I need to select the cells for printing output. Suppose I want to get output of Summary() of R in Excel using BERT.Call…
Nikita Dadlani
  • 1
  • 1
1
2