We are seeking a skilled Python Developer to create a script or macro for data cleaning in Excel. The script should efficiently remove specific columns, sort data, round numerical values, and filter information based on department criteria. The ideal candidate will have experience working with Excel files and Python libraries, such as Pandas, to streamline and automate these tasks. If you are passionate about data management and have a strong background in Python, we would love to hear from you!
Problem: I download about 30 excel files each week and have to:
-manually remove columns
– round data to the nearest .25
– remove weeks (the file is for two weeks, some weeks I need “week 1” and some weeks I need “week 2”. I will need only week 1 rows that correspond with those dates and in week 2, I only need the last day of the week and the previous 7 days.
I have a script from chatgpt I just need you to map it and make it work
