Questions tagged as 'r'

Tagged questions
2
answers

How to calculate the percentage of NA in a data frame in R?

Hello, I'm working with a large data frame - 1000 variables and 60,000 rows - and I need to calculate the percentage of NA and whitespace for each of the variables separately. What is the best way to do this in R?     
asked by 08.09.2018 / 23:58
1
answer

Convert monetary values "R $" to double type

Hello, I have several CSV files, in which some monetary values have been stored in real columns: "R $ 1,986.00". However, I want to pass all CSVs to SQLite and then parse the data in Power BI. So, instead of exporting the CSV data to SQLite in t...
asked by 28.11.2017 / 22:17
1
answer

Using the function lm, from R, to solve the problem autocorrelation

I'm working with the function. lm (y ~ x) Simple regression, due to tests I checked autocorrelation, so the blibliography indicates a transformation. Something like: Y = B1 * (1-p) + B2 (X- (p * X [-1])) What would be the applicat...
asked by 28.04.2018 / 21:11
1
answer

plot time series graph where x shows every year

When plotting the normal time series plot (series), some years are understood that exist, but do not appear. Would you have a way to display each year of the time series horizontally on the x axis?     
asked by 29.04.2018 / 23:29
1
answer

How to create a data frame from a database based on the difference of two dates in a column of another categorical variable in software R

I have the following database as an example and the result I expect: In case the values in the new dataframe refer to the days, which is the difference of the last date of a category from the first of the same category.     
asked by 17.04.2018 / 00:11
1
answer

How to compare 3 different variances? [closed]

I have 3 different samples of size 5, mean 100 and standard deviation 12. How do I compare the 3 variances at the same time? I know I need to make a new table, but I have no idea how to do it.     
asked by 16.09.2017 / 20:05
1
answer

Adjust function with LaplacesDemon

I'm trying to adjust the y ~ o/(x*(x+t)^k) function through a Bayesian technique using the LaplacesDemon function. However, the values obtained for the parameters, are considered good, as well as the errors ( SD ) obtained...
asked by 09.05.2017 / 01:18
1
answer

Create a sequence of useful days in R

I have a data frame the following columns: Date (Days of the week only, no holidays, over several years) Month Year ... I want to create a workday sequence. So I wanted a function that read the smallest day of the first month and the largest...
asked by 09.05.2017 / 00:20
1
answer

Extract and include SQL data with R

I'm designing a database in SQL that will have tables that store collected data and a table that stores calculated indexes of that data for later display on a dashboard. I want to calculate these indexes with the language R. I would like to know...
asked by 31.07.2017 / 14:19
1
answer

Integration between R and HTML [closed]

I would like to know how do I export the results of an R-code to a panel developed in HTML?     
asked by 15.07.2017 / 04:23