Формат | Размер | Скачать |
---|
Название | : | |
Продолжительность | : | |
Пользователь | : | id 904684429523 |
Дата публикации | : | ript src= |
Просмотры | : | layer\/3b96d06c\/www-embed-player.vflset\/www-embed-player.js |
Понравилось | : | 1,383 |
Не понравилось | : | 10 |
Awesome content! Very well demostrated! Комментарий от : @mycountryfarm |
How do i merge two datasets A and B but data set B is a small data that has to go and replace certain cells in A Комментарий от : @taruvingatakudzwa151 |
Very clear and succinct. All the info I needed clearly explained. 👍🏾 Комментарий от : @shambo9807 |
YESSSSS THANK YOUUUUU Комментарий от : @lahirukudaligamage13 |
Thank you for the good lesson; explained very clearly. Комментарий от : @caynaan901 |
Directly answered what I was looking for - Thank you! I have used 'drop_na()' as oppose to 'na.omit()' for the most part, but always good to know alternative ways of doing things. Комментарий от : @ezhankhan1035 |
hi, i'm trying to do cov. with two groups of values, but one has NAs and R doesn't allow me to remove themwhan i do the cov, and if i rewrite the two groups without NA they are different in lenght, so cov can't be done, what i can do? ;( Комментарий от : @francesco8150 |
How to deal with the missing data for catergory variable, please? Комментарий от : @organ1181 |
and how do i do if it only shows other characters but not "NA", sir? Комментарий от : @hoax9784 |
good stuff Комментарий от : @whitfieldlewis837 |
Hello i have a question! Should you always remove missing values in dataset (especially for public data)? Or do we need to consider the proportion of missing data, missing value type (MCAR, MAR, NMAR), and skewness of the data? I’m really struggled with this particular issue (not the technique, but the judgement as to remove missing values or not), Please shed me a light and thanks! Комментарий от : @atthoriqpp |
na.omit is removing the whole row. what if I do not remove the whole row? Is there any way I can plot geom_line without omitting na? The plot needs to ignore the point where there is a na? Комментарий от : @tirthanandi6122 |
Tabulated value and calculated value in t-test normal distribution by plot in R programming Комментарий от : @mdiqbal7168 |
R programming for t-test two tail tabulated value in plot Комментарий от : @mdiqbal7168 |
Thank you so much! You have been such a good help. Комментарий от : @roshnyabraham7941 |
Excellent work Комментарий от : @atifdai313 |
What if I had two entries for each SUBJECT and I want to filter both of their entries if one of their entries in another collumn is NA? ps: great video as always! Комментарий от : @larissacury7714 |
How to Undefined In place of NA? Комментарий от : @16kush |
Thank you very much! Комментарий от : @claytontherrien7583 |
I am trying to use ggscatter but I have many NAs in y column and no correlation coefficient appears. Is there any way of ignoring these NAs or changing them to "0"? please help me, thank you. Комментарий от : @lsjenny2198 |
hello, great videos thanks! question, if I wanted to get the NA values in a separate subset instead of omitting or removing them, what can I do? Комментарий от : @jayw6886 |
I have been following your tutorials for a couple of days now. I want to say thank you, they are truly direct and straight to the point. I wish that you would offer consultation to students even if you decide to charge a price on it. Because sometimes one might get stuck and not know what to do. Комментарий от : @careenevans |
# 1. Load R packages > library("quantstrat") > > # 2. Stock Instrument Initialization > > # 2.1. Initial Settings > start.pf <- '2010-01-02' > start.date <- '2010-01-03' > end.date <- '2016-12-30' > Sys.setenv(TZ='UTC') > init.eq <- 10000 > # 2.2. Data Downloading or Reading > > # Data Downloading > getSymbols(Symbols='BMW',src='yahoo',from=start.date,to=end.date) [1] "BMW" Warning message: BMW contains missing values. Some functions will not work if objects contain missing values in the middle of the series. Consider using na.omit(), na.approx(), na.fill(), etc to remove or replace them. i don't want to see these errors how should i fix it Комментарий от : @durduozkarc6345 |
Könntest du das auch noch mal in Deutsch aufnehmen? :D Комментарий от : @Rhena |
The problem is that depending on the package na.rm does not work. It seems that each package has its own way to consider NAs. This is stressful when you are used to SAS. Комментарий от : @mariasaraiva9675 |
Thanks for this video Комментарий от : @fostkangben |
please help me in this .....my result saying argument y missing with no defualt library(MASS) library(maxLik) library(matrixcalc) mu1=2 ;mu2=2;sig1=1;sig2=1;sai=mu1-mu2;mu=c(mu1,mu2) sigma=matrix(c(sig1,0,0,sig2),2,2,byrow=TRUE) n=10;nr=mvrnorm(n,mu,sigma) t1=sum(nr[1]);t2=sum(nr[2]);t3=sum((nr[1])^2);t4=sum((nr[2])^2) t5=sum(nr[1]*nr[2]) ;c0=-t1-t2-n*log(2*3.14) negl= function(x,y,z,w){ term1= (t3-2*(y+x)*t1+n*(x+y)^2)/(2*z) term2=(t4-2*y*t2+n*y^2)/(2*w) negl1= -c0 + (n/2)*log(z) + (n/2)*log(w) + term1 + term2 return(negl1) } v1=c(0,2,3,1) maxBFGS(negl, grad=NULL, hess=NULL, start=v1, fixed=NULL,control=NULL,constraints=NULL,finalHessian=TRUE,parscale=rep(1, length=length(start))) Комментарий от : @meenakshigautam4249 |
I like all your Video Комментарий от : @tmitra001 |
# LOAD LIBRARIES library(quantmod) library(xts) # FUNCTIONS # ROLLING BETA pcbeta = function(dF){ r = prcomp( ~ dF$x[-1] + dF$y[-1]) return(r$rotation[2, 1] / r$rotation[1,1]) } rolling_beta = function(z, width){ rollapply(z, width = width, FUN = pcbeta, by.column = FALSE, align = 'right') } # GET TICKER DATA SPY = getSymbols('SPY', adjust=T, auto.assign=FALSE) AAPL = getSymbols('AAPL', adjust=T, auto.assign=FALSE) # IN-SAMPLE DATE RANGE in_start_date = '2011-01-01' in_end_date = '2011-12-31' in_range = paste(in_start_date, '::', in_end_date, sep='') # RETRIEVE IN-SAMPLE DATA x_in = SPY[in_range, 6] y_in = AAPL[in_range, 6] dF_in = cbind(x_in, y_in) names(dF_in) = c('x','y') # OUT-OF-SAMPLE DATE RANGE out_start_date= '2012-01-01' out_end_date = '2012-12-31' out_range = paste(out_start_date, '::', out_end_date, sep='') # RETRIEVE OUT-OF-SAMPLE DATA x_out = SPY[out_range, 6] y_out = AAPL[out_range, 6] dF_out = cbind(x_out, y_out) names(dF_out) = c('x', 'y') # CALCULATE RETURNS (IN AND OUT OF SAMPLE) returns_in = diff(dF_in) / dF_in returns_out = diff(dF_out) / dF_out # DEFINE ROLLING WINDOW LENGTH window_length = 10 # FIND BETAS betas_in = rolling_beta(returns_in, window_length) betas_out = rolling_beta(returns_out, window_length) # FIND SPREADS spreadR_in = returns_in$y - betas_in * returns_in$x spreadR_out = returns_out$y - betas_out * returns_out$x names(spreadR_in) = c('spread') names(spreadR_out) = c('spread') # FIND THRESHOLD threshold = sd(spreadR_in, na.rm=TRUE) plot(data$spread, main = "AAPL vs. SPY In-Sample", cex.main = 0.8, cex.lab = 0.8, cex.axis = 0.8) abline(h = threshold, lty = 2) abline(h = -threshold, lty = 2) abline function not work why? Комментарий от : @durduozkarc6345 |
Hello, How do handle NaN in R? Комментарий от : @shanti3310 |
Sir, in your statisticsglobe website, where do we start? As a beginner to R, I'd like to know as to where to start. Thanks Комментарий от : @azad2546421 |
How does this work the other way round? For example, I want all values in my dataframe to become NA if they are below 0.4. Thank you! Комментарий от : @aloysduistermaat7046 |
Your videos are amazing and easy to understand! Thank you!!! Комментарий от : @eapen4irm |
excellent joachim, perfectly explained Комментарий от : @arunbioinfo1100 |
Love it, thank you one more time dude! Love the way you prepared your lessons ´cause they are really short, focus on an specific context and finally you gave us multiple solutions for an scenario, so thats the way it must be. Комментарий от : @anthonyfernandezgonzalez8262 |
Informative and well explained Комментарий от : @DavidKaranjamdavis |
how do you handle or replace NA values in a dataset where dates and other numeric information is missing . Комментарий от : @Michelle-mv1gg |
@Statistics Globe Vielen Dank für das tolle Video. Das hat wirklich geholfen :) Leider habe ich immer noch ein Problem, und ich hoffe wirklch sehr, dass du meine Frage beantworten kannst. An welche Stelle setzte ich das na.rm = TRUE in einem komplexeren Code? Ich bekomme immer eine Fehlermeldung und ich schätze (laut Internetrecherche) dass diese etwas mit den NA zu tun hat: Fehler in KhatriRao(sm, t(mm)) : (p <- ncol(X)) == ncol(Y) is not TRUE. Doch wenn ich na.rm = TRUE verwende, behauptet R dies sei ein unbenutztes Argument. Ich vermute ich habe es an die falsche Stelle geschrieben. Das ist mein Code: fit2 <- lme4::lmer(stroop$rt ~ 1 + stroop$trialnum + (1 + stroop$trialnum|stroop$pno), data = stroop) LG, Paula (Der Datensatz hat über 26000 Zeilen und über 2600 NAs) Комментарий от : @Paula-uj8ps |
Hi can I ask a question please Комментарий от : @Jonpaulim |
Can you just remove NA's from a specific column within a data set? For example, if I have a column such as "wind chill" which has a lot of blanks when its not cold outside, I don't want to erase all of that data from the data set if I am looking at another column/vector of interest. Thanks! Комментарий от : @Jay19876 |
How can You make a new data frame that excludes all the NA values Комментарий от : @lh4818 |
how about if I only want to remove rows with all values are NA? Комментарий от : @jenevavergara4125 |
when you ran na.omit(airquality) before mean(airquality$ozone) already rows with NAs were deleted, giving you a complete numeric dataset, then why mean(airquality$ozone) is returning NA again.... Комментарий от : @sun27g |
Thanks. Very helpful Комментарий от : @eyadha1 |
Thanks you,tutorial was very helpful Комментарий от : @mugangakivumbi |
THank you very much for this video (Just subscribed). How do you remove 'NA" from a data set that has no numeric values. Say I just had to Columns( Name and Hair Color) and some of the Hair colors were NA.. how would I omit that? Комментарий от : @frankjr3787 |
After omitting the NA the nos of rows still show the numbers in the original data set . Though I see that the number of row in the data after committing the rows is 111. which code can I use to get this 111 as nrow() gives me the original numbers Комментарий от : @lavinaarora3697 |
How can I delete a certain row only if the amount of NA's surpasses a certain threshold? E.g. when I have like 100 slope coefficients, but only one value is missing, it sounds a bit harsh to delete the whole row. How can I tell R to only delete the row, if there's let's say more than 10 NA's? Комментарий от : @borknagarpopinga4089 |
thank you so much ❤❤❤ Комментарий от : @siddheshgosavi3552 |
Thank you so much for the well-explained video. Keep on posting them please. You are doing a great job! Комментарий от : @shirinisabekova5504 |
Thanks for this video. Комментарий от : @negijivlogs4626 |
very simple to follow sir. Комментарий от : @jababnamgay6366 |
How to handle missing values in category variables not mentioned ?? Комментарий от : @anandacharya9919 |
is that possbile to change na from a particular rows like I have created Code : airquality[is.na(airquality[52:61, c(1, 2)])] = 7 but it not working then I create code like this one : airquality[is.na(airquality[52:61, c(airquality$Ozone)])] = "Sherry" this one is also not working Комментарий от : @shaheryarshafi |
Thank you, Maybe you can even help me further... How can I exclude single missing values from cases runinng Confirmatory Factor Analysis , without deleting the whole cases? I think the "na.rm=TRUE"-function should be the right one, but it seems that this doesnt work with the CFA-function (lavaan). When I do this, R still excludes the whole cases from the analysis. I would be so thankful, if anyone could help me! Комментарий от : @TinaHelen |
When I try sum(is.na(data)) I am getting error as argument y is missing Комментарий от : @manjunathroyal2133 |
I was looking for how to working with the missing data, not to remove entire row that has NA, there are other columns for each row containing NA Комментарий от : @hezzia4427 |
Hey maybe you can help me. On university we have a project and we need to remove all the NA's from our data but the problem is I don't know how to remove Na's if they are "words" instead of "numbers". For example -> you get the variable "house" and then "new house", "old house", "big house", "small house" and then there are also some NA's . I tried it with complete.cases but it didn't work and also with "factor" so I decided to do it one by one and the parts with numbers were easy. Комментарий от : @Janine5748 |
Thank you so much. Easiest method to remove NAs. Комментарий от : @jababnamgay6366 |
Sir, I would like to mutate a column named Daily revenue , which is added with promotion_revenue and non_promotion_revenue. However, there are some rows consists of NA in promotion_revenue whereas $30 in non_promotion_revenue. When I compute, the mutated column (Daily Revenue) will show the daily revenue in NA, even if there is number in one of the columns. I ady applied na.rm = TRUE in the summarize code summarize(daily_revenue = sum(total_rev, na.rm = TRUE)) , it doesn't work. Комментарий от : @daphne_moo |
Excellent explanation! You are a fantastic teacher! Комментарий от : @multitaskprueba1 |
Thanks it is very informative. Комментарий от : @sameenabanu5931 |
Bravo! So well explained! Thank you Комментарий от : @dominiquebarrette9621 |
I LOVE YOU AAAAAAAAAA Комментарий от : @victorresende3140 |
How can I remove NA values only if it is in a certain colunm. Комментарий от : @sofiac4058 |
you can get an other access with this link www.youtube.com/watch?v=G2ra7Ku3eGM&t=132s Комментарий от : @ayeledesalegn5367 |
How do you save omitted data in excel? Комментарий от : @zeusbhattacharya3122 |
Thanks Комментарий от : @oluwadolapobifarin105 |
Gibt es von dir auch ein Video wie ich das mit dem Befehl "listwise deletion" handeln kann? Комментарий от : @punchline9131 |
great Комментарий от : @SumanGhosh-vn3tx |
hi, can write a code to replace missing value "NA" with mean Комментарий от : @mohammadbasheer6192 |
hi, your video demonstration is very useful. keep it up ! Комментарий от : @malakasamaraweera6736 |