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


Possibly Related Threads…
Thread Author Replies Views Last Post
  havent programmed in years - confused by why RETURN is not returning stmoose 5 1,128 Mar-26-2023, 05:51 AM
Last Post: buran
  'Age' categorical (years -months -days ) to numeric Smiling29 4 2,869 Oct-17-2019, 05:26 PM
Last Post: Smiling29
  Create a monthly mean column in multiple years fyec 1 3,971 Jun-21-2018, 03:57 AM
Last Post: scidam
  Calculating what year it is when you are 100 years old dankim9000 2 11,946 Apr-26-2017, 08:03 PM
Last Post: dankim9000
  Importing file in dataframe and populating missing column name vvv 1 3,401 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