Back Fill Blanks

Description:

Backward Propagation of Missing Data

Function:

Back_Fill_Blanks(table = string, cols = list)

Parameters:

• Table: Table name on which to perform function

• Column(s): Column(s) to backward fill

Example:

Back_Fill_Blanks(table = df, cols = ["Delta"])

Before

Date	Geo	Business	Plan	Actual	Delta
5/1/2024	Latin America	Energy	900	900
5/1/2024	Latin America	Manufacturing	1050	1100
6/1/2024	Latin America	Energy	1850	2000
6/1/2024	Latin America	Manufacturing	2000	1800
7/1/2024	Middle East & Africa	Healthcare	1200	900	-300
7/1/2024	Middle East & Africa	Energy	1150	1000	-150
8/1/2024	Asia-Pacific	Energy	800	750	-50
8/1/2024	Asia-Pacific	Technology	950	1050	100
9/1/2024	Asia-Pacific	Technology	1500	1300	-200
9/1/2024	Asia-Pacific	Energy	1700	1400	-300

After

Date	Geo	Business	Plan	Actual	Delta
5/1/2024	Latin America	Energy	900	900	-300
5/1/2024	Latin America	Manufacturing	1050	1100	-300
6/1/2024	Latin America	Energy	1850	2000	-300
6/1/2024	Latin America	Manufacturing	2000	1800	-300
7/1/2024	Middle East & Africa	Healthcare	1200	900	-300
7/1/2024	Middle East & Africa	Energy	1150	1000	-150
8/1/2024	Asia-Pacific	Energy	800	750	-50
8/1/2024	Asia-Pacific	Technology	950	1050	100
9/1/2024	Asia-Pacific	Technology	1500	1300	-200
9/1/2024	Asia-Pacific	Energy	1700	1400	-300