I'm running <code>cor()</code> on a <code>data.frame</code>with all numeric values and I'm getting this as the result: <pre class="prettyprint"><code> price exprice... price 1 NA exprice NA 1 ... </code></pre> So it's either <code>1</code> or <code>NA</code> for each value in the resulting table. Why are the <code>NA</code>s showing up instead of valid correlations?

Tell the correlation to ignore the NAs with <code>use</code> argument, e.g.: <pre class="prettyprint"><code>cor(data$price, data$exprice, use = "complete.obs") </code></pre>

cor shows only NA or 1 for correlations - Why?

Tags:

r

correlation

I'm running cor() on a data.framewith all numeric values and I'm getting this as the result:

       price exprice... price      1      NA exprice   NA       1 ...

So it's either 1 or NA for each value in the resulting table. Why are the NAs showing up instead of valid correlations?

747

asked Sep 26 '10 17:09

Dave

1 Answers

Tell the correlation to ignore the NAs with use argument, e.g.:

cor(data$price, data$exprice, use = "complete.obs")

196

answered Oct 12 '22 02:10

dmt

Related questions
                            
                                How to call a function using the character string of the function name in R?
                            
                                Getting frequency values from histogram in R
                            
                                How to remove rows with inf from a dataframe in R
                            
                                Extracting text data from PDF files
                            
                                Examples of the perils of globals in R and Stata
                            
                                Pretty ticks for log normal scale using ggplot2 (dynamic not manual)
                            
                                Vectorized IF statement in R?
                            
                                Hiding NA's when printing a dataframe in knitr
                            
                                Creating a sequential list of letters with R
                            
                                Calling R Function from C++
                            
                                Adding a company Logo to ShinyDashboard header
                            
                                How do I read a Parquet in R and convert it to an R DataFrame?
                            
                                Calculate cumsum() while ignoring NA values
                            
                                Random sample of character vector, without elements prefixing one another
                            
                                Create end of the month date from a date variable
                            
                                jupyter-client has to be installed but “jupyter kernelspec --version” exited with code 127
                            
                                dplyr: put count occurrences into new variable [duplicate]
                            
                                rename the columns name after cbind the data
                            
                                How I can select rows from a dataframe that do not match?
                            
                                filtering data.frame based on row_number()

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With