Questions tagged [correlation]

For questions regarding interdependence of variable quantities.

0
votes
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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 ...