How to write data of type DataFrame using asksaveasfile dialog

user_5327929 0
Viewed 2484

I am trying to save my data from an input csv file and write it to another csv file. I know how to write the dataFile using the to_csv method and using a pre-determined file to write into(output.csv). How do I do it via asksaveasfile dialog method. Any help is appreciated.

import csv
import pandas as pd
import os
import tkinter as tk
from tkinter import filedialog


SAVING_PATH = 'C:/Users/Desktop/'
root = tk.Tk()
root.withdraw()
file_path = filedialog.askopenfilename() 
dataFile=pd.read_csv(file_path,usecols=['Name','Email','Gender'])
dataFile.to_csv(os.path.join(SAVING_PATH,r'output.csv'))
dataFile = filedialog.asksaveasfile(mode='w', defaultextension=".csv")
pandas csv python
1 Answers

Nevermind I fixed the problem already. 

import csv
    import pandas as pd
    import os
    import tkinter as tk
    from tkinter import filedialog

    root = tk.Tk()
    root.withdraw()
    file_path = filedialog.askopenfilename() 
    dataFile=pd.read_csv(file_path,usecols=['Name','Email','Gender'])
    SAVING_PATH = filedialog.asksaveasfile(mode='w', defaultextension=".csv")
    dataFile.to_csv(SAVING_PATH)
user_53279290
Related