查找sql中涉及的表名称
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 |