I have done and read a csv file and then plotted the values of a single column using K-means

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from matplotlib import style
from sklearn.cluster import KMeans

data=pd.read_csv(r'Plot_file.csv', encoding='unicode_escape', sep=';')

feature_names = ['Plot_Column]
X = np.asarray(data[feature_names])

from sklearn.cluster import KMeans

labels = KMeans(5, random_state=10).fit_predict(X)
plt.scatter(X[:, 0], X[:, 0], c=labels,
    s=50, cmap='rainbow');

The output looks like this, it is linear because when clustering one column it can only look at the relative distance between the values in that column and will always be linear on any chart as it is only clustering one dimension

enter image description here

How would I go with detecting anomalies in this case?

The column that I am clustering the values from has around 12 thousand rows and varying numbers.


If you have a one dim data, why do you need to use K-means?

In such a case, to detect the outlier I would recommend creating a simple histogram and then based on its shape you can visually find the outliers. To get a proper outlier threshold you can use np.quantile() function.

| improve this answer | |
  • $\begingroup$ the dataframe has a ot of columns but I just want to focus on one. I use K-means because it is part of a research where I just have to check how it performs in one column and if I can detect outliers. $\endgroup$ – be1995 Feb 15 at 15:28
  • $\begingroup$ What is the difference between the data that has multiple columns and you want to use only one of them, and the data that has only one column? In both of the cases, I don't see any particular reason to use K means instead of just a simple histogram. $\endgroup$ – user1877600 Feb 15 at 17:44
  • $\begingroup$ There is nothing different with the other columns. I goal is just to find anomalies within one column. The reason why use k-means and not histogram is because it has to be part of machine learning. I histogram I can even plot it usin excel and not use matplotlib $\endgroup$ – be1995 Feb 16 at 11:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.