Python Forum
replace nan values by mean group by date.year, date.month
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
replace nan values by mean group by date.year, date.month
#3
(Jul-06-2019, 01:10 AM)scidam Wrote: Your code should be something like this:

data_pd.fillna(data_pd.groupby([data_pd.Dateobs.dt.year, df.Dateobs.dt.month]).transform('mean'), inplace=True)

hi Mr first thank you for your reply, i appreciate it
i tried this
result=data_pd.fillna(data_pd.groupby([data_pd.Dateobs.dt.year, data_pd.Dateobs.dt.month]).transform('mean'), inplace=True)
print (result)
and i am getting the following result:
Output:
None Process finished with exit code 0
still the same problem its not replace null value by mean
is there anything else i should try
thank you
Reply


Messages In This Thread
RE: replace nan values by mean group by date.year, date.month - by wissam1974 - Jul-06-2019, 01:32 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [Numpy] Load date/time from .txt to 'datetime64' type. water 4 575 Mar-01-2024, 11:16 PM
Last Post: Gribouillis
  Function to Select a Date standenman 2 944 May-08-2023, 07:12 PM
Last Post: standenman
  Pandas read csv file in 'date/time' chunks MorganSamage 4 1,700 Feb-13-2023, 11:24 AM
Last Post: MorganSamage
  Sort by month in a plot ph4n70m1988 0 1,051 Dec-11-2022, 06:14 AM
Last Post: ph4n70m1988
  replace sets of values in an array without using loops paul18fr 7 1,719 Jun-20-2022, 08:15 PM
Last Post: paul18fr
  Sorting list from FTP by Date lastyle 2 2,586 Nov-02-2021, 05:46 PM
Last Post: ibreeden
  Does a pandas have a date without a time? AlekseyPython 6 4,928 Feb-10-2021, 09:24 AM
Last Post: Naheed
  Changing Time Series from Start to End of Month illmattic 0 1,870 Jul-16-2020, 10:49 AM
Last Post: illmattic
  How Do I Only Get the Year from Date and Isolate Data for Year? WhatsupSmiley 2 2,177 Apr-14-2020, 11:45 AM
Last Post: snippsat
  why is the ticker and date different junkone 1 1,652 Apr-02-2020, 06:34 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

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