I created a pandas dataframe in python and I want to transfer it to a xlsx excel file
I used the code below and It had no errors.
I also named the excel file "test.xlsx" but I dont know where can I find that excel file,
please let me know if I had to create an empty xlsx file named test before running or any thing else!
data = pd.DataFrame(list, columns = ['column1', 'column2', 'column3', 'column4'])
out = pd.DataFrame(data, columns=['column1', 'column2', 'column3', 'column4'])
out.to_excel('test.xlsx')
The file will be saved in the current working directory.
You can find out the current working directory by "import os" to import the os related commands and "os.getcwd()" to get the current working directory info.
In future, its always better to provide full path to file while saving data to file, you can mention the full path via "out.to_excel("D:\\directory1\\directory2\\file1.xlsx")" or "out.to_excel("D:/directory1/directory2/file1.xlsx")"
Both "\\" and "/" works as path separator.
This will work
1.Install openpyxl module like pip install openpyxl
#Create an Excel Writer with your prefered output name
# call to_excel() function on the DataFrame with the Excel Writer as argument
# save the file
data = pd.DataFrame(list, columns = ['column1', 'column2', 'column3', 'column4'])
data1 = pd.ExcelWriter('output.xlsx')
data.to_excel(data1, index=False, header=True)
data1.save()
Assuming Melina Safarinasab is using Windows, one can do the following
from os import path
df.to_excel(path.join('C:\\Users\\Melina\\Desktop', 'test.xlsx'), index=False)
If one wants to change the directory, don't forget the "\\".
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Programming Languages
- Python