import pandas as pd
from pathlib import Path
import glob
import os
import numpy as np
import re
csv_files = []
for csv_path in glob.glob('E:/生意7月/*.xls'):
print(csv_path)
customer_df = pd.read_excel(csv_path,
encoding = 'utf-8', header=5)
csv_files.append(customer_df)
full_df = pd.concat(csv_files)