Python

 Ranaming a column in data frame

https://saturncloud.io/blog/how-to-replace-column-values-in-a-pandas-dataframe/#:~:text=Method%201%3A%20Using%20the%20.replace()%20method&text=In%20this%20example%2C%20we%20created,than%20creating%20a%20new%20copy.

Writing the Read data into Excel sheet

• Here if_sheet_exists = 'replace' will overite the data in the sheet if the sheet exists already

import pandas as pd

#Data frame

partspec_insert=df[['PartId', 'PartRev', 'AddedBy']]

#Write the DataFrame to a new sheet in the same Excel file

with pd.ExcelWriter(file, engine='openpyxl', mode='a', if_sheet_exists = 'replace') as writer:

      partspec_insert.to_excel(writer, sheet_name='Processed Data', index=False)

Moving file to destination folder after processing

import os

import shutil

destination_folder_path=r'C:\Users\BK2\Desktop\Test Folder\Processed Files'

shutil.move(file, os.path.join(destination_folder_path, os.path.basename(file)))

Print('Files moved to Destination Folder')

Drop Duplicates from Dataframe

Getting Today Date in Python

https://ioflood.com/blog/python-get-current-date/