Your indices are probably not unique. You could try pd.merge(Historie, Kmeans, on='SKU_NR', how='left')