Posts by Bruno Rigueti • 305 points
9 posts
-
0
votes1
answer719
viewsQ: Extract and include SQL data with R
I am designing an SQL database that will have tables that store collected data and a table that stores calculated indexes of this data to be later exposed on a Dashboard. I intend to calculate these…
-
2
votes2
answers5191
viewsQ: HTML and SQL connection
I’m designing a database where I have a table with calculated data indices from other tables. I am also designing an HTML Dashboard to expose these indexes. My database is stored on a Mysql server.…
-
4
votes1
answer186
viewsQ: Schedule automatic updates on R
I have an algorithm on designed in R that retrieves data from a database, does some statistical calculations and produces a Dashboard with kpis and graphs generated from these calculations. But…
rasked Bruno Rigueti 305 -
0
votes1
answer197
viewsQ: Integration between R and HTML
I would like to know how I export the results of a code in R to a panel developed in HTML?
-
3
votes2
answers11355
viewsQ: Select column of a data.frame --- Database Division in R
I imported a table as a database to handle in R. However, I need to do some calculations with just a few columns of this table. How do I select only these columns for calculations?
rasked Bruno Rigueti 305 -
3
votes1
answer511
viewsQ: Calculation with Matrices in R
What functions should I use to make the following calculations with matrices in R: - Find the transposed matrix; - Find the inverse matrix; - Find the identity matrix; - Finding the determinant of a…
rasked Bruno Rigueti 305 -
2
votes2
answers658
viewsQ: Obtain coefficients "a" and "b" of the Linear Regression Model in R
In a Simple Linear Regression model - y = a + bx - we have the angular coefficient "b" and the intercept "a". I wonder how I do to get these coefficients in R?
rasked Bruno Rigueti 305 -
2
votes1
answer1375
viewsQ: Import Excel Tables into R
I would like to know which is the best library to import excel tables to be manipulated in R. I would like one that supports all extensions, mainly the . xlsm.
rasked Bruno Rigueti 305 -
2
votes1
answer2467
viewsQ: Multiple Regression with R
I have a table with some columns of factors that vary over time. With multiple regression I can evaluate the influence of a group of factors on the variation of 1. How can I do this in R?
rasked Bruno Rigueti 305