Mar-17-2018, 06:31 AM
To replace the missing year and the corresponding columns with zeros. My dataframe looks like this,
Year Churn_Count Churn_Rate Customer_Count
2008 1071.0 0.800149 4114
2012 0.0 0.000000 6
2013 233.0 0.174075 824
2014 101.0 0.075458 410
I need to fill the missing year in between 2008 to 2014 ,
for example, 2009,2010, 2011 is missing how to fill these year in between and corresponding columns with zeros
Year Churn_Count Churn_Rate Customer_Count
2008 1071.0 0.800149 4114
2012 0.0 0.000000 6
2013 233.0 0.174075 824
2014 101.0 0.075458 410
I need to fill the missing year in between 2008 to 2014 ,
for example, 2009,2010, 2011 is missing how to fill these year in between and corresponding columns with zeros