Python Forum
Python Resample: How do I keep NaN as NaN?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python Resample: How do I keep NaN as NaN?
#1
When resample from monthly data to quarterly, I want my last value NaN to remain as NaN. How should I tweak my code?

Thank you

[Image: 4NQGL.png]

df=pd.read_excel(input_file, sheet_name='Sheet1', usecols='A:D', na_values='ND', index_col=0, header=0)
df.index.names = ['Period']
df.index = pd.to_datetime(df.index)


q0= pd.Series(df['HS6P1'], index=df.index)

m1 = q0.resample('Q').sum()
Current Output
Period

1989-03-31 212.7
1989-06-30 302.1
1989-09-30 272.1
1989-12-31 163.9

Desired Output
Period

1989-03-31 212.7
1989-06-30 302.1
1989-09-30 272.1
1989-12-31 NaN
Reply


Messages In This Thread
Python Resample: How do I keep NaN as NaN? - by JaneTan - Dec-07-2022, 02:11 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  python resample by day and get weekstart data JaneTan 0 1,619 Dec-15-2022, 03:38 AM
Last Post: JaneTan
  Resample from monthly to weekly works, but not vice versa JaneTan 0 1,216 Dec-14-2022, 12:58 AM
Last Post: JaneTan
  resample grouping pr0blem olufemig 1 2,781 Nov-06-2019, 10:45 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

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