Sort Excel Sheet Hacktoberfest_Inputt.xls

achoudh5 / Manipulating_Excel_Sheet

Real world application of Manipulating Excel Sheet using python.

Apache License 2.0

8 stars 14 forks source link

Sort Excel Sheet Hacktoberfest_Inputt.xls #20

Open Ishita-Mehta opened 3 years ago

Ishita-Mehta commented 3 years ago

Addressing Issue #11

Added a folder 'Sort Excel File' with excel_sorter.py

This script reads input excel file, sorts according to Source and Destination column and then outputs a new excel file with sorted rows. This is achieved using pandas library.

achoudh5 commented 3 years ago

Hi @Ishita-Mehta

Can you import this as a module in zip.py and make zip.py a one stop shop for the user ? Imagine user being not so software friendly, you don't want them to run so many files on cli. Let me know if it makes sense, incase you have any question make a comment and tag me.

Ishita-Mehta commented 3 years ago

Hi @achoudh5 Sorry for the delay. Had a busy week at work. I've committed the following changes:

Corrected in the error in excel_sorter.py.
Added a init.py file to the directory to make it a package.
Imported the package in zip.py and called the function from the main() function of zip.py

Please let me know if anything else is to be done. Thanks!