import pandas as pd import numpy as np from sklearn.linear_model import LinearRegression # 导入数据 def load_data(months): dfs = [] for month in months: df = pd.read_excel(f'武汉{month}气温数据5_修正.xlsx', sheet_name='Sheet1') df['当地时间'] = pd.to_datetime(df['当地时间']) dfs.append(df) return pd.concat(dfs).sort_values('当地时间') # 加载1-3月数据 months = ['1月', '2月', '3月'] full_df = load_data(months) # 按年份分割数据 full_df['年份'] = full_df['当地时间'].dt.year full_df['年-月'] = full_df['当地时间'].dt.to_period('M') #计算有效积温（GDD） def calculate_gdd(df, base_temp=5): df['日均温'] = df['T平均气温'] df['GDD'] = (df['日均温'] - base_temp).apply(lambda x: max(x, 0)) df['累计GDD'] = df.groupby('年份')['GDD'].cumsum() return df full_df = calculate_gdd(full_df) #步骤4：确定历史开花日期；假设樱花开放日期为当年累计GDD首次达到400的日期： def find_bloom_date(df, target_gdd=400): bloom_dates = [] for year in df['年份'].unique(): year_data = df[df['年份'] == year] bloom_day = year_data[year_data['累计GDD'] >= target_gdd].first_valid_index() if bloom_day is not None: bloom_date = year_data.loc[bloom_day, '当地时间'] bloom_dates.append({'年份': year, '开花日期': bloom_date}) return pd.DataFrame(bloom_dates) bloom_dates = find_bloom_date(full_df) print("历史开花日期：", bloom_dates) df=pd.DataFrame(bloom_dates) #改正 df['bloom_dates'] = pd.to_datetime(df['bloom_dates']) 报错 File "<ipython-input-46-b16de62c2a4c>", line 52, in <module> df['bloom_dates'] = pd.to_datetime(df['bloom_dates']) File "C:\pythonuse\lib\site-packages\pandas\core\frame.py", line 2688, in __getitem__ return self._getitem_column(key) File "C:\pythonuse\lib\site-packages\pandas\core\frame.py", line 2695, in _getitem_column return self._get_item_cache(key) File "C:\pythonuse\lib\site-packages\pandas\core\generic.py", line 2489, in _get_item_cache values = self._data.get(item) File "C:\pythonuse\lib\site-packages\pandas\core\internals.py", line 4115, in get loc = self.items.get_loc(item) File "C:\pythonuse\lib\site-packages\pandas\core\indexes\base.py", line 3080, in get_loc return self._engine.get_loc(self._maybe_cast_indexer(key)) File "pandas\_libs\index.pyx", line 140, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 162, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1492, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1500, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'bloom_dates'