Python Forum
Replacing missing years in the dataframe
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Replacing missing years in the dataframe
#1
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
Reply


Messages In This Thread
Replacing missing years in the dataframe - by sangeethasivakumar - Mar-17-2018, 06:31 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  havent programmed in years - confused by why RETURN is not returning stmoose 5 1,194 Mar-26-2023, 05:51 AM
Last Post: buran
  'Age' categorical (years -months -days ) to numeric Smiling29 4 2,966 Oct-17-2019, 05:26 PM
Last Post: Smiling29
  Create a monthly mean column in multiple years fyec 1 4,047 Jun-21-2018, 03:57 AM
Last Post: scidam
  Calculating what year it is when you are 100 years old dankim9000 2 12,041 Apr-26-2017, 08:03 PM
Last Post: dankim9000
  Importing file in dataframe and populating missing column name vvv 1 3,479 Feb-26-2017, 02:32 PM
Last Post: sparkz_alot

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020