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