How do I remove unnecessary redundant data from a dataset

Question

I have a data set with 100 clumns and 18854 rows. How do I eliminate redundant data?

Answer 1

You can use dimensionality reduction methods such as PCA.

dimensionality reduction is the process of reducing the number of random variables under consideration by obtaining a set of principal variables.

PCA is a statistical procedure that uses an orthogonal transformation to convert a set of observations of possibly correlated variables (entities each of which takes on various numerical values) into a set of values of linearly uncorrelated variables called principal components.