Project Details

"The dynamic path ruta_pend4 is set for the ""Pendientes4.xlsx"" file, which will be located in the output folder corresponding to the current day within the project folder structure. The slope file ""Pendientes4.xlsx"" is read into a DataFrame called df_pend4 using the 'openpyxl' engine. The path to read the ""Sheet3"" sheet from the ""NATIONWIDE 5.0 MODIFICADA1.xlsx SLOPE Plantilla_ESTADO"" file is defined and read into a DataFrame called df_H3. A new column called ""Regional Mapping"" is inserted into the DataFrame df_pend4. This column is inserted after the ""Bogotá Filter #2"" column. A cross-reference is made between the df_pend4 and df_H3 DataFrames, and the ""Regional Mapping"" column in df_pend4 is updated with the corresponding df_H3 values according to the branch of establishment. A new column called ""Bogotá Process Assignment"" is inserted into the DataFrame df_pend4. This column is inserted after the ""Regional Assignment"" column. An iteration is performed on the rows of the DataFrame df_pend4 to determine the assignment of processes in Bogota. The ""Bogotá Process Assignment"" column is updated in df_pend4 with the corresponding values based on the logic defined in the code. The ""Pendientes4.xlsx"" file is updated with the changes made to the DataFrame df_pend4. 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." library: sys, pandas, datetime, os, openpyxl