Python Forum
How to split monthly data smoothly into days?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to split monthly data smoothly into days?
#1
have statistical reports, that are presented monthly. I would like to present the same data daily (keeping the total amount for the month). Of course, I can break the total values by the number of days in a month, but then a "step" is formed at the border of the months, which I want to avoid.

I have:

01.01.2000 1000
01.02.2000 800
01.03.2000 1290

I need (daily data is approximate):

01.01.2000 34.3
02.01.2000 32.8
...
31.01.2000 28.2
01.02.2000 28.4
02.02.2000 28.7
.....
29.02.2000 32.6
01.03.2000 32.7
.....
31.03.2000 45.1

How can I do this?
Reply
#2
you can first split each line using space as delimiter into a new list, then split the first word of list using '.' as delimiter.
now you can accumulate totals on first element of the list.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  selecting only october to march from monthly data u Staph 1 1,659 Jul-14-2019, 10:15 AM
Last Post: Larz60+
  selecting customized seasons from monthly time series Staph 3 2,861 Jul-14-2019, 09:40 AM
Last Post: scidam
  How to split data into trainSet and testSet retaining the index continuous Raj 1 2,482 May-02-2018, 09:03 AM
Last Post: ThiefOfTime
  monthly composite of LST comes out incorrect, with error "mean of empty slices" ns423 1 2,874 Mar-18-2018, 06:40 PM
Last Post: ns423

Forum Jump:

User Panel Messages

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