pandas DataFrame中经常出现SettingWithCopyWarning
data = pd.read_csv('D:\wzz\pythonProject\predictAnalysis\TP10.csv' , sep=",")
columns = ['观测日期', '水位', '气温']
X = data[columns]
#X = data[columns].copy()
X.loc[:,'观测日期']=pd.to_datetime(X.loc[:,'观测日期'], format='%Y-%m-%d %H:%M:%S')
shape=X.shape
minDate=X.iloc[:,0].min()
for i in range(shape[0]):
X.loc[i,'观测日期']=(X.loc[i,'观测日期']-minDate).days
print(X)
报错:
解决方案:加入copy
data = pd.read_csv('D:\wzz\pythonProject\predictAnalysis\TP10.csv' , sep=",")
columns = ['观测日期', '水位', '气温']
X = data[columns].copy() #copy可解决问题
y = data['切向累计位移'].copy()
X.loc[:,'观测日期']=pd.to_datetime(X.loc[:,'观测日期'], format='%Y-%m-%d %H:%M:%S')
shape=X.shape
minDate=X.iloc[:,0].min()
for i in range(shape[0]):
X.loc[i,'观测日期']=(X.loc[i,'观测日期']-minDate).days