需要从用户动态获取文件

Question

我正在编写一个代码，我希望用户提供文件的位置，它将运行我所编码的检查。 在这里，我硬编码的excel路径，但我希望它是动态的。你知道吗

我试图编写代码并动态读取，但出现了一个错误：

from tkinter import *
from tkinter.ttk import *
import pandas as pd
import csv
from tkinter.filedialog import askopenfile

root = Tk()
root.geometry('200x100')


def open_file():
    file = askopenfile(mode ='r', filetypes =[('Python Files', 
    '*.csv')])
      if file is not None:
         content = file.read()
            print(content)

btn = Button(root, text ='Open', command = lambda:open_file())
btn.pack(side = TOP, pady = 10)
prac = askopenfile(mode ='r', filetypes =[('Python Files', 
'*.csv')])
 content = prac.read()

content["latlong"] ='FALSE'
content.loc[(content["LONGITUDE"] >= 70.0000) & 
(content["LONGITUDE"] <= 
98.0000) & (content["LONGITUDE"] != 'nan') & 
 (content["LATITUDE"] != 
'nan'), ["latlong"]] = 'TRUE'
 file.to_csv("C:/Users/patesari/Desktop/python 
 work/practice1.csv")
 writer = content[content["latlong"]=='TRUE']
 writer.to_csv('C:/Users/patesari/Desktop/python 
 work/newfile1.csv', 
 index=False)
 writer = content[content["latlong"]=='TRUE']
 writer.to_csv('C:/Users/patesari/Desktop/python
 work/outputfiles/latlong1.csv', index=False)
 mainloop()

但这个密码给了我错误：内容[“latlong”]=“假” #TypeError:“str”对象不支持项分配。 此代码对我来说运行良好，但我已对路径进行了编码：

def latlong_func():
data = pd.read_csv(r'C:/Users/patesari/Desktop/python 
work/Gap1`.csv')
df = pd.DataFrame(data,columns=['SUPPLIER_ID','ACTION'])
data["latlong"] ='FALSE'
data.loc[(data["LONGITUDE"] >= 70.0000) & (data["LONGITUDE"] 
<= 98.0000)&
(data["LONGITUDE"] != 'nan') & (data["LATITUDE"] != 'nan'), 
["latlong"]] 
= 'TRUE'
data.to_csv("C:/Users/patesari/Desktop/python 
work/practice1.csv")
writer = data[data["latlong"]=='TRUE']
writer.to_csv('C:/Users/patesari/Desktop/python 
work/newfile1.csv', 
index=False)
writer = data[data["latlong"]=='TRUE']
writer.to_csv('C:/Users/patesari/Desktop/python 
work/outputfiles/latlong1.csv', index=False)

如果我使用tkinter，需要更正什么。我要的是哪段代码 如果不使用tkinter，则应适用

Answer 1

您应该使用askopenfilename来获取文件名，而不是打开的文件对象。文件名可以与pd.read_csv(filename)一起使用，而不是使用prac.read()

所以首先我做了一个函数

def latlong_func(filename):
    data = pd.read_csv(filename)

    # rest

所以它得到了文件名并和熊猫一起使用。你知道吗

后来我做了一个函数

def get_filename():

    filename = askopenfilename(filetypes =[('Python Files', '*.csv')])

    if filename:
        lbl['text'] = filename
        latlong_func(filename)
    else:
        lbl['text'] = 'not selected'

获取文件名并执行latlong_func(filename)。它还会在窗口的Label中显示文件名。你知道吗

此功能分配给按钮

btn = tk.Button(root, text='Open', command=get_filename)

---

完整代码：

import tkinter as tk
import pandas as pd
from tkinter.filedialog import askopenfilename


def latlong_func(filename):
    # filename instead of r'C:/Users/patesari/Desktop/python work/Gap1.csv'
    data = pd.read_csv(filename)

    #df = pd.DataFrame(data, columns=['SUPPLIER_ID','ACTION'])

    data["latlong"] = 'FALSE'
    data.loc[
        (data["LONGITUDE"] >= 70.0000) & (data["LONGITUDE"] <= 98.0000) &
        (data["LONGITUDE"] != 'nan') & (data["LATITUDE"] != 'nan'),
        ["latlong"]
    ] = 'TRUE'

    data.to_csv("C:/Users/patesari/Desktop/python work/practice1.csv")

    writer = data[data["latlong"]=='TRUE']
    writer.to_csv('C:/Users/patesari/Desktop/python work/newfile1.csv', index=False)
    writer.to_csv('C:/Users/patesari/Desktop/python work/outputfiles/latlong1.csv', index=False)


def get_filename():

    filename = askopenfilename(filetypes =[('Python Files', '*.csv')])

    if filename:
        lbl['text'] = filename # display filename in Label
        latlong_func(filename)
    else:
        lbl['text'] = 'not selected'


#  - main  -

root = tk.Tk()
root.geometry('200x100')

lbl = tk.Label(root, text='Select filename')
lbl.pack(side='top', pady=10)

btn = tk.Button(root, text='Open', command=get_filename)
btn.pack(side='top', pady=10)

root.mainloop()