# Questions tagged [correlation]

For questions regarding interdependence of variable quantities.

**0**

votes

**0**answers

6 views

### How to pass the Dynamic value for the same request in jmeter?

GetRequest
Parameter Value
In Jmeter, I have a scenario, that i need to fetch the job_id from the GET Request . so solution is using REGEX for fetching and using it for next requests. But for same ...

**0**

votes

**1**answer

13 views

### How to make Wildfly behave similar to spring-cloud-sleuth

As our internal IDP we are using Keycloak 6.0.1, which relies on Wildfly 16.
The majority of our components are spring boot thingies, in which we use spring cloud sleuth + some gelf configuration to ...

**-1**

votes

**1**answer

66 views

### Why is the correlation coefficient of these two list equal to 1?

I have two list a and b as follows:
a = [4,4,4,1.1]
b = [4,4,4,1.2]
It is clear that the last value in both the list is different, still why do I get the correlation co-eff (from numpy) to be ...

**0**

votes

**1**answer

42 views

### Sorted Correlation List [on hold]

Using R Studio 1.2.1335 on Fedora 30. I have used cor_numcols <- cor(numcols[1:37],numcols$SalePrice,use="complete.obs") to create my data set and it is by default sorted by the column names. I ...

**1**

vote

**1**answer

35 views

### How to calculate p values for entire table of spearman rho values in R

I used the following code to get an entire table of Spearman Rho correlations in R from a CSV file with only 1 data type (numbers):
> myDataset <- read.csv(file.choose())
> attach(myDataset)
...

**1**

vote

**1**answer

17 views

### How to stop duplicate correlations in table of Spearman Rho correlations in R?

I used the following code to make a table of Spearman Rho correlations for a CSV file with 2+ columns in R:
> myDataset <- read.csv(file.choose())
> attach(myDataset)
> ...

**-1**

votes

**0**answers

19 views

### How to calculate Cronbach's alpha using data from a correlation matrix in SAS?

I have a correlation matrix, how can I calculate Cronbach's alpha of my factors using SAS? I don't have the original data set, just the correlation matrix, N, mean and std.
I have a correlation ...

**2**

votes

**1**answer

21 views

### Does corr function in DataFrame object return restricted matrix with size 190X190?

I have been trying to produce corr matrix based spearman using pandas DataFrame. all the results grant me matrix 190X190 although i inserted 200+ nd.array into the DataFrame object.
import pandas ...

**2**

votes

**1**answer

40 views

### How to compare a column against every other column in a SQL query with a wide table?

I'm trying to implement a query in AWS Athena where I compute the Pearson Correlation coefficient of a selected column against every other column in a matrix, and return a sorted list.
The data is ...

**-1**

votes

**1**answer

42 views

### How to find and plot correlated variables in R?

I'm reviewing factors related to cancer and hoping to find how they're related to one another. After I input my .xslx file into R, I'm at a loss how to use that list of data to find the z-scores for ...

**0**

votes

**0**answers

6 views

### XGBoost model accuracy issue

Please, can you help me ? I have numerical and categorical data. And I have to predict a continue dependent variable : the "area". The maximum correlation to the area is 23% : it's the correlation of ...

**0**

votes

**0**answers

17 views

### “Correction for Continuity” Error when Running Exploratory Factor Analysis in R with Categorical Items

I am trying to run an exploratory factor analysis using the "psych" package in R. This factor analysis is an analysis of individual items with categorical scores, so I am attempting to run this factor ...

**0**

votes

**0**answers

14 views

### How to make Apache Spark Correlation compute autocorrelations?

I have a series and I'm trying to compute ist autocorrelation coefficients. Unfortunately, Apache Spark provides only a Correlation API, and I cannot understand, how to force it to compute autocorrs.
...

**0**

votes

**1**answer

44 views

### How to get a correlation matrix from a pairwise correlation data.frame?

I have a pairwise correlation dataframe which looks like this (this is just the head) :
var1 var2 corr
1 OTU3978 UniRef90_A0A010P3Z8 0.846
2 OTU4011 UniRef90_A0A010P3Z8 0.855
...

**1**

vote

**0**answers

17 views

### How to test significance of vector with correlation coefficients [migrated]

I am new to R so please apolozige if I should use wrong terms etc.
Let's say I investigated married couples as subjects, and (amongst other) tested if their amount of consumed alcohol is correlated ...

**0**

votes

**0**answers

25 views

### How to reduce my dataset in order to plot it with igraph?

I have a dataset with the correlations between genes and OTUs. I want to plot these correlations with the igraph library in R in order to know what genes are correlated with which OTU. Then, I will ...

**-1**

votes

**0**answers

15 views

### Question regarding a canonical correlation analysis

In what case would a canonical correlation analysis result in the pairs of canonical variates having high correlations, but the redundancy for both data sets being low?

**0**

votes

**1**answer

31 views

### Conditional correlations using an IF statement - Python

I am trying to conduct an IF statement in order to evaluate conditional threshold correlations. The equation is as follows:
I tried doing an IF statement, but it doesn't work. I kind of managed to do ...

**0**

votes

**0**answers

15 views

### Matrix Multiplication to Perform Correlations

Hi I currently have two dataframes. I am trying to perform a correlation between them. df1 has a shape of (17400, 132) and df2 has a shape of (17400, 1155). I want to know the correlation between the ...

**0**

votes

**1**answer

18 views

### Correlations between dataframe and list of dataframes in R

I want to calculate correlations between a dataframe and a list of dataframes. Here is my sample:
library(lubridate)
v1 = seq(ymd('2000-05-01'),ymd('2000-05-10'),by='day')
v2 = seq(2,20, length = 10)...

**1**

vote

**1**answer

28 views

### corrplot: Changing to times new roman corrplot() output

I've like to create an image using corrplot() function in corrplot package in times new roman without success. I try to use par(family="Times"), but doesn't work and in help of the function don't have ...

**0**

votes

**1**answer

39 views

### how to compute correlation between two samples

I'm trying to compute the correlation between two samples (rows) in DataFrame type. I've found some codes that compute the correlation between features(columns), eventually, it converts the matrix to ...

**-1**

votes

**0**answers

21 views

### How can I reduce dimension of input data using correlation?

I'm working on modeling rheologic, so I have as input 24 physicochemical parameters and 1 output. The neural network is giving me predictions with MAPE=30%, so I want to reduce the input's dimension ...

**0**

votes

**1**answer

31 views

### How can I create a correlation graph and legend in R?

In the code below, I would like to share the shape of the graph that changes when rho.AB is -0.9, 0 and 0.9, on a graph using a loop. And I want to express the legend as well. Please could you help me....

**0**

votes

**1**answer

23 views

### Use pandas to plot highest correlations

I have been plotting correlations via heatmaps with the following code. However, there are too many variables. Is it possible to plot the highest correlations ( over .5 and -.5) on a graph?
plt....

**0**

votes

**0**answers

12 views

### I want to combine the graphs through the for LOOP and add a legend

In the code below, I would like to share the shape of the graph that changes when rho.AB is -0.9, 0 and 0.9, on a graph using LOOP. And I want to express the legend as well. please help me....
mu.A = ...

**-1**

votes

**0**answers

17 views

### automatically compute a range of lags for all columns in a df and compute each lag correlation with a target column

I am trying to determine, for each feature column in a dataframe, the optimal lag which has the highest correlation with a target column in that same dataframe
To do this, I'm trying to construct a ...

**1**

vote

**0**answers

27 views

### Why I am getting an error when running the vif() function in R?

I am checking multicollinearity for my data and am using 3 tests which are Spearman correlation, the condition number and Variance Information Factors (VIF). When I am trying to run the VIF code in R ...

**0**

votes

**0**answers

29 views

### Testing Heteroscedasticity for a correlation coefficient in R Studio

I am trying to test a table of correlation numbers on heteroscedasticity. A snapshot of the table I am working with looks like this:
Days Left
Until Clearing avg_cor
1 -3619 0....

**0**

votes

**0**answers

16 views

### How to figure out correlation between two columns and create data frame? [duplicate]

I am figuring out the correlation between two columns.
import pandas as pd
df = pd.DataFrame({'Number1': [1,2,1,1,2,1],
'String1': ['A','B','A','B','B','B']})
output looks like this
df
...

**0**

votes

**0**answers

16 views

### Calculating a R2 value for logistic growth Function:

Here is a simple dataset. I would like to estimate the R2 value for this best fit logistic growth curve. Any ideas on how to do this?
######Logistic growth model in ggplot2
library(tidyverse)
...

**0**

votes

**0**answers

17 views

### Python. Pandas. How to sort a single column of correlation table?

I have the following corr() result:
df.corr()['CLV']
Aug 0.173970
Sep -0.026968
Oct 0.009116
Nov 0.014982
Dec -0.004958
Jan 0.062557
Feb -0.155615
Mar 0.126143
CLV 1.000000
...

**1**

vote

**1**answer

40 views

### tidyverse - Correlations among multiple columns grouped by other column

I want to get a correlation matrix across several variables in tidyverse. However, I want to do this grouped by another column. E.g. suppose I have a data frame df with columns year and I want to see ...

**0**

votes

**0**answers

24 views

### Is there an R function for finding a relationship between a binary outcome and multiple categories within multiple variables

Hypothetical example to try to better explain my question. Say I have thousands of houses and a binary result for each, in this case whether or not a house was purchased for at least the original ...

**0**

votes

**0**answers

25 views

### what is pandas rolling window

I am trying to understand how rolling window works in the case of correlation between series.
For the example let's take two series :
se1 = pd.Series([1,2,3,4,5,6,7,8,9])
se2 = pd.Series([1,2,3,4,5,...

**0**

votes

**1**answer

22 views

### How can I jump factor-data in a correlation function?

I'm an absolute beginner and I want to calculate correlations in my data set.
A couple of columns are factor data, so I want to jump those columns, as apparently it is not possible to calculate ...

**1**

vote

**0**answers

37 views

### Getting the correlation with significance of one variable with the rest of the dataset, by time, in data.table

I stole this example from the following post: LINK
set.seed(1)
TDT <- data.table(Group = c(rep("A",40),rep("B",60)),
Id = c(rep(1,20),rep(2,20),rep(3,20),rep(4,20),rep(5,20)),...

**1**

vote

**1**answer

15 views

### How do I apply threshold labels against the R (correlation strength) values in Anaconda Python?

I have unstacked a correlation matrix so I can create a list of the correlating pairs and their correlation strength (R). I now want to add a column that applies category labels against each value ...

**0**

votes

**0**answers

25 views

### Accessing a dataframe in the column of a dataframe in R

I want to get the correlation of a variable with all the other variables in my dataset. To do this I tried the following:
library(data.table)
df <- fread(
"A B D E iso year
...

**1**

vote

**1**answer

19 views

### How to get the correlated values of a dataset in a seperate column if the index and the columns are same

I imported a dataset into my python script and took the correlation. This is the code for correlation:
data = pd.read_excel('RQ_ID_Grouping.xlsx' , 'Sheet1')
corr = data.corr()
After the correlation ...

**0**

votes

**0**answers

20 views

### How do I add significance asterisks next to my values in a correlation matrix heat map?

I found this code online at http://www.sthda.com/english/wiki/ggplot2-quick-correlation-matrix-heatmap-r-software-and-data-visualization
It provides instructions for how to create a correlation ...

**0**

votes

**1**answer

25 views

### Regex - Unable to capture boundaries

I am having challenges capturing the dynamic value using regular expression in JMeter.
Tried the below Regex but it did not work. Have no idea how to handle | |
RegEx: dataItem|sm|(.+?)==
...

**1**

vote

**0**answers

17 views

### Display time correlation with Pine Script

I try to find similar period in the past to the actual period for a serie. So I want to display time correlation with Pine-script by calculation for each preceeding period the correlation on 20 values ...

**0**

votes

**1**answer

42 views

### Is there a way to correlate n arrays?

I need to correlate n arrays that I have combined into a list which looks like:
array_corr = [array([a1]), array([a2]), array([a3]), .... array([an])]
corr_mat = np.corrcoef([array_corr])
But I am ...

**-1**

votes

**1**answer

23 views

### Correlation between two set of variables

I would like to have a correlation matrice between two sets of variables. In the first set I have 9 variables, in the second one I have 24 variables. The second set of variables include the 9 ...

**1**

vote

**1**answer

49 views

### How to find correlation between 2 variables but cross different timeline ('lagged correlation')

Suppose that I'm selling stuffs that are complementary goods with each other.
And I'm trying to figure out correlation between item sales, but on different date of sales.
(Cuz I think sales of item01 ...

**0**

votes

**0**answers

55 views

### How to iterate through multiple data frames in a dictionary

I've created a dict that appears to consist of multiple data frames parsed by location. However, when I try to iterate through the dict to run correlations by location, it appears as if it's running ...

**0**

votes

**0**answers

40 views

### CSRFTOKEN value is not passing in response code of my lr script

I have correlated the csrftoken value but the recording and replay response is not matching.
Recording:
Request :
POST /maximo/ui/maximo.jsp HTTP/1.1
Host: maximopp.dqe.com
Connection: keep-alive
...

**0**

votes

**0**answers

8 views

### Correlation calculation - clustered variables

Originally, I have 7 variables: 1 entrance exam score, 6 final grade scores. I have calculated the correlations between the variables, using kendal correlation with holm correction. Hierarchical ...

**1**

vote

**1**answer

35 views

### How to get a pariwise correlation dataframe from a matrix?

I have a matrix on which I compute the correlations between my columns. I created a function which gives the result in the form of correlation matrix (because of the apply() function), but I would ...