在執行程式Part1_data_collector.ipynb時發生問題 - Cupoy

在執行程式Part1_data_collector.ipynb時發生問題

昨日執行資料蒐集程式時間過晚，超過了午夜12點，出現下方錯誤訊息。原本以為是要在課程建議的晚上6點後執行就不會有問題，但今日依然發生一樣錯誤。而且使用舊的曾經成功執行備份也出現一樣錯誤，這是代表資料來源有缺失嗎?應該如何處理? 更新季報表... 100%|████████████████████████████████████████████████████████████████████████████████████| 2/2 [00:41<00:00, 20.73s/it] --------------------------------------------------------------------------- KeyError Traceback (most recent call last) C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance) 2894 try: -> 2895 return self._engine.get_loc(casted_key) 2896 except KeyError as err: pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() KeyError: '總資產週轉率' The above exception was the direct cause of the following exception: KeyError Traceback (most recent call last) in 1 # 執行相關指令 [除了存檔名稱外, 請勿修改] 2 stock_list = cs.set_combine(SELECT_CODE, TRAIN_NUM) ----> 3 df = cs.import_dataset(stock_list, RESET_MODE, MAX_CHAR_LENGTH) 4 cs.save_char(df, char_generator, RESET_MODE, MAX_CHAR_LENGTH, 5 file_1d='1d_char.csv', file_2d='2d_char.csv') ~\股票機\20210130_20股票 - 複製20210204backup - 複製\cstock.py in import_dataset(stock_list, reset_mode, char_length) 733 monthly_repeater() 734 print('更新季報表...') --> 735 quarterly_repeater() 736 print('更新每日成交資訊...') 737 daily_repeater() ~\股票機\20210130_20股票 - 複製20210204backup - 複製\cstock.py in quarterly_repeater() 434 break_day = f'{break_day[:-2]}10-01' 435 break_day = datetime.strptime(break_day, '%Y-%m-%d') --> 436 rep_df = quarterly_period_record(break_day, today) 437 df = pd.concat([df, rep_df], axis=0, ignore_index=True) 438 df = df.sort_values(by=['季度', '代號']).drop_duplicates(subset=['季度','代號'], keep='last').reset_index(drop=True) ~\股票機\20210130_20股票 - 複製20210204backup - 複製\cstock.py in quarterly_period_record(start_date, end_date) 414 for col in ['總資產週轉率', '利息保障倍數', '平均銷貨日數', '存貨週轉率', '現金再投資比', '現金流量比', '平均收現日數', 415 '應收款項週轉率', '長期資金佔固定資產比', '固定資產週轉率', '純益率']: --> 416 df[col] = df[col].map(lambda x:np.nan if f'{x}'.find('*')>-1 else x) 417 return df 418 C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py in __getitem__(self, key) 2900 if self.columns.nlevels > 1: 2901 return self._getitem_multilevel(key) -> 2902 indexer = self.columns.get_loc(key) 2903 if is_integer(indexer): 2904 indexer = [indexer] C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance) 2895 return self._engine.get_loc(casted_key) 2896 except KeyError as err: -> 2897 raise KeyError(key) from err 2898 2899 if tolerance is not None: KeyError: '總資產週轉率'