import numpy as np
import pandas as pd
path = r"D:\OCdata\winequality-white.csv"
data = np.array( pd.read_csv(path,header=None))
print(data.shape)
y = data[:,-1]
print(y.shape)
print(np.unique(y,return_counts=True))
for i, ele in enumerate(y):
data[i,-1] = int(ele + 1)
y = data[:,-1]
print(np.unique(y,return_counts=True))
data = pd.DataFrame(data=data)
data.to_csv(r"D:\OCdata\winequality-white-1.csv",header=None,index=None)