import pandas as pd
import datetime
today=str(datetime.date.today())filepath='/Users/kangyongqing/Documents/kangyq/202303/分析模版/sql表引用提取/'
file1='01試聽課明細.txt'
newfile=file1.title().split('.')[0]with open(filepath+file1,'r') as file:content=file.read().lower()print(content)df=pd.DataFrame({'表名':content.split('from')})
df['表名']=df['表名'].str.split().str[0]
df=df[~df['表名'].isin(['select','('])]
df=df.drop_duplicates()
df=df.sort_values(by='表名').reset_index(drop=True)
print(df)
df.to_excel(filepath+f'{newfile}解析{today}.xlsx')讀取txt格式的sql文檔，按from分列取表名，結果如下：
| 表名 | |
| 0 | dim_pub_date |
| 1 | dim_tutor |
| 2 | dim_tutor_send |
| 3 | dwd_tut_publish_timetable_ss_daily |
| 4 | dwd_tut_tutor_course_ss_daily |
)
