import pandas as pd
import os
import glob
import tkinter as tk
from tkinter import filedialog
import numpy as np
import matplotlib.pyplot as plt
# 获取文件夹路径实例化
root = tk.Tk()
root.withdraw()
# 获取文件夹路径
f_path = filedialog.askopenfilename()
#COD = pd.read_excel(f_path)#根据文件路径获取excel文件
f_path即是读取的文件路径