图形化打开文件操作
import tkinter as tk
from tkinter import filedialog
import pandas as pd
'''打开选择文件夹对话框'''
root = tk.Tk()
root.withdraw()
#获得选择好的文件路径
Filepath = filedialog.askopenfilename()
data = pd.read_excel(Filepath,sheet_name =1)
data.head()
图形化打开文件操作
import tkinter as tk
from tkinter import filedialog
import pandas as pd
'''打开选择文件夹对话框'''
root = tk.Tk()
root.withdraw()
#获得选择好的文件路径
Filepath = filedialog.askopenfilename()
data = pd.read_excel(Filepath,sheet_name =1)
data.head()