聚类得出各指标平均值（Python）

import pandas as pd
from sklearn.preprocessing import StandardScaler
from sklearn.cluster import KMeans

data = pd.read_excel("data5-1.xlsx")

cluster_columns = ['XXX', 'XXX', 'XXX']
data_cluster = data[cluster_columns]

scaler_cluster = StandardScaler()
data_cluster_scaled = scaler_cluster.fit_transform(data_cluster)

kmeans_cluster = KMeans(n_clusters=5, random_state=42)
kmeans_cluster.fit(data_cluster_scaled)

centers_cluster = scaler_cluster.inverse_transform(
    kmeans_cluster.cluster_centers_)

data['labels'] = kmeans_cluster.labels_

clusters_means_all = data.groupby('labels').mean()
clusters_means_all.to_excel('data5-2.xlsx')