生意参谋流量来源数据处理

import os
import pandas as pd



l = []

for root, dirs, files  in os.walk('E:\shuju'):
    for file in files:
        if '店铺流量来源' in file:
            day = file[-14: -4]
            terminal = file[8: 10]
            df = pd.read_excel(os.path.join(root, file),skiprows