Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
creating consecutive rows
#1
Hi,

I have a requirement of creating consecutive rows. My data has ID#, start dt and end date. For example:

Quote:ID start date end date
11 07-01-2010 10-01-2010


I want to create rows like


Quote:ID MM YY
11 07 2010
11 08 2010
11 09 2010
11 10 2010



Data is very huge and there are various dates. If there is overlapping I find from different row for same ID for example 08 2010, i want to keep it only once.

Pls advise.
Reply
#2
What have you tried?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,603 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,083 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 6,963 Mar-02-2021, 01:54 AM
Last Post: Jeremy7
  Python Consecutive characters vijju56 4 4,900 Apr-22-2020, 11:03 AM
Last Post: TomToad
  Assign the sum of 2 consecutive numbers in a list to a varibale Fenaz 3 2,055 Apr-05-2020, 10:30 PM
Last Post: bowlofred
  I need to add consecutive numbers help juniorcoder 1 2,320 Sep-18-2018, 01:01 AM
Last Post: ichabod801

Forum Jump:

User Panel Messages

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