Jul-05-2020, 02:21 PM
I’m new to python / pandas and wanted to see if its possible to automate our existing manual; process using python.
File1 (resource allocations). All resource allocations add up to 100%
Column headings are as follows
Resource email
Area
Team name
Programme Name (programme 1, 2 or 3)
Jan
Feb
Mar
Through to Dec
E.g John would have 3 rows of data if assigned across 3 programmes at 20%,50% and 30%
File 2 ( latest allocations by team against the programmes ) - each team allocations adds to 100%. E.g. Team Spain are 100% on Programme 1. Team Italy are 30% on Programme 1, 50% on Programme 2 and 20% on Programme 3.
Columns in this file are:
Area (World, Europe or Local)
Team name (Spain,Italy, Germany)
Start date - 01/07/2020
Finish date - 31/08/2020
Programme 1
Programme 2
Programme 3
Objective of automation. By looking at team name using file 2, run through file 1 to update July and August columns based upon the latest allocations for the teams. Creating or deleting new rows if required.
E.g If john was previously assigned to all 3 programmes but File 2 shows his latest team is only on programme 2 at 100% than remove 2 rows and ensure the correct programme for that team is displayed with correct % for the columns based upon start and finish dates. In this instance allocations will be updated for months of July and August.
Generate a new cvs with output.
File1 (resource allocations). All resource allocations add up to 100%
Column headings are as follows
Resource email
Area
Team name
Programme Name (programme 1, 2 or 3)
Jan
Feb
Mar
Through to Dec
E.g John would have 3 rows of data if assigned across 3 programmes at 20%,50% and 30%
File 2 ( latest allocations by team against the programmes ) - each team allocations adds to 100%. E.g. Team Spain are 100% on Programme 1. Team Italy are 30% on Programme 1, 50% on Programme 2 and 20% on Programme 3.
Columns in this file are:
Area (World, Europe or Local)
Team name (Spain,Italy, Germany)
Start date - 01/07/2020
Finish date - 31/08/2020
Programme 1
Programme 2
Programme 3
Objective of automation. By looking at team name using file 2, run through file 1 to update July and August columns based upon the latest allocations for the teams. Creating or deleting new rows if required.
E.g If john was previously assigned to all 3 programmes but File 2 shows his latest team is only on programme 2 at 100% than remove 2 rows and ensure the correct programme for that team is displayed with correct % for the columns based upon start and finish dates. In this instance allocations will be updated for months of July and August.
Generate a new cvs with output.