Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mixed-type-data]

Dataset including variables of different measurement nature (e.g. continuous, categorical, binary, count etc.) analyzed together in one variable set. Use this tag when this presents a challenge for the analysis. Do NOT use to refer to [mixed-model].

1
vote
0answers
18 views

How to adjust continuous and categorical variables for categorical variable?

I am performing a metaanalysis where I am trying to find predictors for an ordinal response variable. Additionally, I want to perform pair-wise correlations on some of the variables. I have a ...
0
votes
0answers
6 views

Regress in two variables against basis functions when one of them might be “sparse”

I'm tasked with the problem of fitting a series of functional forms $\{f_t(S,K)\}$ along the time axis. At each time $t=0,1,\cdots,T$, there are $N_t$ samples $$(F_{t,i}, S_{t,i}, K_{t,i}),\quad i=1,2,...
0
votes
0answers
8 views

Finding most related variables independent of variable type

Problem I am analysing a dataset containing variables of different types: continuous, ordinal and categorical. To prioritise in which order to analyse the variables, I would like to evaluate the ...
0
votes
0answers
8 views

Interaction analysis with categorical predictor and continuous moderator (and continuous outcome)

I'm working on a study in which I collect the following variables (among others), with which I would like to conduct a moderation analysis in R. condition (categorical, 2 levels) - predictor trait ...
0
votes
0answers
24 views

How to validate clusters after calculating Gower distances and Ward's clustering in R

I am trying to apply Ward's clustering on a mixed types dataset, and wanna explain what I did (maybe helpful to others), and I have some questions regarding this analysis, mainly how to validate my ...
1
vote
1answer
37 views

Why does Random Forest not find this simple categorical interaction?

The questions: Why is Random Forest not better at finding an interaction of a simple indicator $\times$ continuous variable? What kind of machine learning model would be better at finding this ...
0
votes
0answers
95 views

Dimension Reduction for mixed variables

I am working with a dataset which consists of both categorical (14 vars) and continuous variables (5). Each categorical variable consists of a minimum of 2 categories up to 106 categories. The aim ...
2
votes
0answers
22 views

Using non-parametric transformation (ranking) on variables for factor analysis in R

I have been wrestling with how to simplify a set of mixed variables (some orthogonal, some numeric) some (of both types) of which are significantly skewed. I have run a factor analysis anyway and ...
1
vote
0answers
16 views

Different conditions on data measurement for ml

Is it possible to train a prediction model (on my case classifier with four classes) between data taken on different conditions? To be more specific I have two data sets and for my task I am allowed ...
0
votes
1answer
16 views

How to perform prediction on a mixed type label (i.e. continuous but optional)

I have a set of simulations in which an event may or may not happen. I recorded the time the event occurs and whether it does. I would like to perform regression on the time variable, including ...
1
vote
1answer
39 views

Duplicated Rows in Mixed Data Type Clustering

I have a dataset which has ~200k rows and looks like the following - ...
1
vote
1answer
57 views

Analysis of impact between 2 observations

I have 2 columns of ~18000 observations. First column contains a value that shows the delay of a filed document (in days) of year 2017. For example: if the document had to be filed on May 5th 2017, ...
0
votes
1answer
33 views

Comparing the results of 2 different type but identical samples from 2 devices

I have 2 columns of of the concentration of fat in fish which is measured by 2 different labs. I need to know if the difference of the results from these 2 labs are statistically significant. The data ...
1
vote
2answers
220 views

Non-negative matrix factorization (NMF) on mixed data using 1-hot encoding

From a standpoint of interpretation, can I use NMF on one-hot encoded categorical data for dimension reduction? I have mixed data and was thinking about one-hot encoding the categorical features and ...
1
vote
0answers
40 views

Avoiding multicollinearity with dummy encoding of ordinal variable

I was having trouble finding this exact circumstance; hopefully I haven't missed an obvious previous answer. I have a target variable, Y (discrete counts), and two ...
0
votes
0answers
33 views

How to compute distances with both categorical and continuous attributes?

I have to handle with a datast containing both categorical attributes (around 25) and continuous attributes (around 25). I would like to do outliers detection. I think that it would be a good idea to ...
0
votes
0answers
11 views

Is it a problem if marginal estimates with instrumental variable approach are way higher than the marginal estimates without instrument?

I am estimating a model with instrumental variable / exclusion variable. I have tested the instrument and it satisfies all the assumptions. The marginal effects of the model without instrument: cmp (...
0
votes
1answer
25 views

Cluster Analysis for mixed data and using a large sample

I wanna perform Cluster Analysis and I have Mixed data (a couple of dummy variables). I've found some information about Gower's distance, but when I tried to use it, R broke down (i guess) because I ...
0
votes
2answers
185 views

binary distance k prototype [closed]

I am using k-prototype for my mixed data set. I've chosen Euclidean Distance for my numeric variables; which (dis)similiraty measure can I chose for my categorical variable? The variables ask e.g. for ...
1
vote
0answers
115 views

How to test for conditional independence with mix of categorical and continuous data

I wish to test for conditional independence between $X$ and $Y$ given $Z$. However $X$ is continuous, while $Y$ and $Z$ are categorical variables. My idea is to test if $P(X|Z = z) = P(X|Y = y, Z = z)...
4
votes
1answer
222 views

Is (a) multicollinearity and/or (b) binary variables an issue for DBSCAN? if so, how can one correct for these issues?

I have read some related questions, such as: Why are mixed data a problem for euclidean-based clustering algorithms?, What data structure to use for my cluster analysis or what cluster analysis to use ...
1
vote
2answers
769 views

Mixed data in Gaussian Mixture Models

Is it possible to use a dataset with mixed variables such as continuous, ordered, and categorical variables and cluster the data using the Gaussian Mixed Model with EM algorithm. I cannot find ...
4
votes
3answers
5k views

Interpreting Silhouette plot for Cluster Analysis

I am running a mixed type data cluster analysis in R and I am trying to interpret the Silhouette Plot. For whatever reason, it is telling me that more clusters is ideal for analysis. Why could this be?...
1
vote
1answer
614 views

Difference Between Cubic Clustering Criterion, Silhouette Score, and Calinski Harabasz

I am clustering a mixed geological data set containing numeric (pump pressure, bit speed, mud temperature), nominal (presence or absence of a specific stones), and ordinal data (relative concentration ...
1
vote
1answer
314 views

PCA on part of dataset

I have read numerous questions/answers on this site and others debating the use of PCA and other dimensionality reduction techniques on mixed data (containing both continuous and categorical variables)...
0
votes
1answer
423 views

How to classify mixed data?

I am trying to do some classification tasks on mixed data set (Hepatitis data set)from UCI ,I will apply SVM and Naive Bayes in R & WEKA, both of them can not handle mixed data directly. Naive ...
0
votes
1answer
167 views

Number of components in Principal Components Analysis with mixed data

How can I decide about the optimal number of components in Principal component analysis when I have mixed data of of categorical and continuous? I'm using ...
3
votes
0answers
858 views

Autoencoder with Mixed Data

Is it reasonable? The categorical features can be binary ("true" or "false") or strings, which are one-hot encoded. Some continuous features may be integers, which are treated as real values. If an ...
1
vote
1answer
392 views

Multidimensional similarity space

Does anyone know about multidimensional similarity space? I am working on mixed data set (numerical and categorical), I want to create multidimensional similarity space, contains pairs of similarity ...
1
vote
0answers
62 views

Running chi-squared test on mixed data

I have a set of data with high dimension = 80. The set contains mixed features: numerical and categorical data. I'd like to extract all relevant features to an output $Y$ (which is categorical as ...
0
votes
1answer
1k views

Can I use Clustering with mixed data type in R? [duplicate]

I know there is same question in cross validated. But it is somewhat different. Clustering of mixed type data with R At there Q&A, as using daisy funtion(), we can use categorical data type in ...
0
votes
0answers
55 views

FA for mixed data types, including dichotomous

I wish to conduct factor analysis on data that I have. The data is collected from a questionnaire and contains different types of data, for example, there are answers to the following questions: <...
0
votes
0answers
414 views

Computing similarity matrix with mixed data

I would like to compute similarity matrix (which I will further use for clustering purposes) from my data (failure data from automotive company). The data consist of these variables: START DATE + ...
1
vote
0answers
343 views

Which dimensionality reduction technique for mixed data? [duplicate]

I have a binary dependent variable and 18 independent variables which I want to use as regressors in a logistic regression. Prior to that, I want to reduce the dimensionality of the data set to shield ...
3
votes
0answers
93 views

Mixture probabilistic model on mixed data

When dealing with homogeneous types of data, we can employ mixtures of gaussians (for continous) or some kind of k-proptotyping (ordinal-nominal). I am investigating around the statistical/machine ...
2
votes
0answers
151 views

Clustering for mixed data including string attributes [duplicate]

Suppose to have a dataset containing feature vectors representing some people. Each feature vector contains mixed type of attributes (e.g. sex, age, height, hair color, favourite film, ...). For ...
0
votes
1answer
126 views

Data Preparation

I faced a mixed data set which contained both continuous and categorical variables (totally more than 200 variables). Now I have chosen 60 variables out of them by the business specification. Then is ...
5
votes
1answer
731 views

Same kernel for mixed/categorical data?

I know it's common practice, but is it right to apply the common kernels to categorical/mixed data? If not, are there alternatives? I'm expecting answers from both theoretical and practical points of ...
6
votes
5answers
1k views

Clustering of variables: but they are mixed type, some are numeric, some are categorical

I have a dataset with 15 variables. Some variables are numeric, continuous. Other variables are boolean, dichotomous (true/false). There's also one variable categorical, nominal. ...
1
vote
2answers
3k views

How to calculate the distance in KNN for mixed data types?

when the data is from different types (numerical and categorical) of course euclidean distance alone or hamming distance alone can't help. so i have 2 approaches: standardize all the data with ...
-1
votes
1answer
457 views

Cluster Analysis for Website Data [duplicate]

I want to perform cluster analysis on the data of a website. The data is mainly visitor history(97000 rows) and has following variables: a)User Device Category b) Traffic Marketing Channel c) Traffic ...
1
vote
0answers
51 views

What is a vector of effects?

The journal article in question is this article (General mixed-data model: extension of general location and grouped continuous models, de Leon and Carriere), on p. 535 (or, based on the PDF file, p. ...
3
votes
1answer
1k views

Detect unusual trends and anomalies using mixed data (categorical and numerical)

I've been asked to detect "unusual trends and anomalies" using data similar to ATM transaction data. Each entry has a mixture of numerical and categorical variables, things like transaction ID, ...
3
votes
1answer
1k views

Is continuous inputs an assumption of factor analysis?

Should we use only continuous inputs for factor analysis (FA)? My data is a mix of continuous and categorical inputs: one of the inputs has only 600, 700 and 1000 as values. I found that principal ...
1
vote
1answer
3k views

PCA/factor analysis of mixed (quantitative + qualitative) data: inconsistent results

I have a dataset composed of 4 variables, 2 being numerical and 2 categorical (ordinal in fact). They all represent 4 types of indicators/measures of the same phenomenon . I want to analyse them in a ...
2
votes
1answer
624 views

Kernels for Categorical or Mixed Data

It appears that when data sets have a combination of categorical and continuous attributes, the common way to apply kernel algorithms to such data sets is to use a one hot encoding scheme for each ...
0
votes
0answers
148 views

Using PCA to find most 'similar' points to a given observation (mixed data)

I am trying to find the most 'similar' points to each other in a dataset of mixed data. I understand that if these were all numeric variables on the same scale, one could simply use Euclidean Distance ...
1
vote
3answers
5k views

Ask for suggestions on clustering methods on a large dataset with mixed types of variables

I need to build segmentation on a large customer dataset with more than 300K records and many variables, including continuous like income and age, ordinal like education level and membership level, ...
3
votes
0answers
2k views

Gower's dissimilarity measure and Ward's clustering method

I have read some threads on this website saying that it is not OK to use Gower's dissimilarity matrix for Ward's clustering algorithm. I have mixed type variables, first I had a dissimilarity matrix ...
23
votes
2answers
22k views

How to use both binary and continuous variables together in clustering?

I need to use binary variables (values 0 & 1) in k-means. But k-means only works with continuous variables. I know some people still use these binary variables in k-means ignoring the fact that k-...