Project Details

"Using the datetime library, I get the current date in the format ""yyyy-mm-dd"". The Pandas library is used to read the ""Union.xlsx"" file. The duplicate GLOSA IDs are then searched using the .duplicated function in the 'GLOSA ID' column, and stored in a new DataFrame. This new DataFrame is checked to see if it contains information; if yes, it is saved in an Excel file. If it contains no information, a message is printed. Finally, the function returns a value of 2 if executed successfully. Otherwise, it returns the error line along with an explanatory message of the error." librarys: sys, pandas, datetime, os, openpyxl