Pandas - Write to Exisitng Excel File - Sorted List - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: Data Science (https://python-forum.io/forum-44.html) +--- Thread: Pandas - Write to Exisitng Excel File - Sorted List (/thread-11795.html) |
Pandas - Write to Exisitng Excel File - Sorted List - dj99 - Jul-26-2018 hi friends how can i write my sorted list to an exisitng excel file ie sheet name and column number from openpyxl import load_workbook import pandas as pd from pandas import ExcelWriter from pandas import ExcelFile df = pd.read_excel('python.xlsx', sheet_name='Sheet1') z= list(df.names) #Column Name is imported into a List > ['Sean', 'Joyce', 'Ruby', 'Pamela'] print(sorted(z,key=len)) #sorted_words=(sorted(z,key=len)) #sorted_words.to_excel('test.xlsx')thank you for your help RE: Pandas - Write to Exisitng Excel File - Sorted List - Vysero - Jul-26-2018 Well without seeing the error its hard to say what the problem is. I would start debugging by checking the type of what your trying to write to make sure its what to_excel() function is expecting. I am not sure what exactly it is you are trying to do. It seems as thought you are attempting to take the Column names from python.xlsx, sort them and write them to a different excel file; is that correct? I have never used Pandas or messed with excel files before but I can tell you this much; to_excel() is expecting type ExcelWriter ie: # Specify a writer writer = pd.ExcelWriter('example.xlsx', engine='xlsxwriter') # Write your DataFrame to a file yourData.to_excel(writer, 'Sheet1') # Save the result writer.save() RE: Pandas - Write to Exisitng Excel File - Sorted List - dj99 - Jul-27-2018 Hello, thank you for your help I included the new code but an error came up z.to_excel(writer, 'Sheet1') AttributeError: 'list' object has no attribute 'to_excel' Yes i wanted to output my sorted list into an excel file RE: Pandas - Write to Exisitng Excel File - Sorted List - Vysero - Jul-27-2018 Sure, that error makes sense right because z is a list where to_excel() only works on ExcelWriter() type. So just pack it back into the proper type. The sooner you learn to start type checking and figuring out what the functions your attempting to use are expecting (in terms of type) the better. RE: Pandas - Write to Exisitng Excel File - Sorted List - dj99 - Jul-29-2018 Hi, is there an example that can show me how to type cast, i have not been able to find anything. That applie to my example. I sorted my list I just want to write my list to excel sheet now |