Missing Data Generation trai

[awanishyadavv]

Hi

I want to generate missing data if data is not contineously missing.........for example

Year	Country1	Country2	Country3
1	586	Null	Null
2	452	Null	Null
3	415	Null	Null
4	325	475	Null
5	958	856	985
6	Null	954	965
7	758	Null	856
8	Null	Null	991
9	245	1452	456

For country 1 data is missing in between two valid points, so i want to replace with average growth rate in values.

For country 2 data is data is missing for 1,2 &3 year since this data is missing from starting year i do not want to replace it with any value. but for year 7 & 8 data is not missing from starting year then i want jto replace with average growth rate in values.

Similarly for country 3 data is missing from starting year then i do not want to replace it with any value.

[binu_acs · Accepted solution]

@awanishyadavv @The country field values are growth rates?

[awanishyadavv · Accepted solution]

 Growth Per year = (end year - starting year) / starting year.
Average Growth rate = (sum of Growth per year) / no of growth per 

Ex----- 

Year	Country1	Growth rate per year(Country 1)	Country2	Growth rate per year(Country 2)	Country3	Growth rate per year (Country 3)
1	586	(452-586)/586	Null		Null
2	452	(415-452)/452	Null		Null
3	415	(325-415)/415	Null		Null
4	325	(958-325)/325	475		Null
5	958		856		985
6	Null		954		965
7	758		Null		856
8	Null		Null		991
9	245		1452		456

[binu_acs · Accepted solution]

@awanishyadavv I assumed the country fields have the growth rates,

[awanishyadavv]

Although I provided only minimal data, you worked and gave me some insight ,
Referencing your solution I was able to resolve the complete database.

Thankyou, love from India