If there are multiple dates for an ID then only min and max date should be present as shown.

1.00/5 (1 vote)

See more:

I have data in dataframe in this following format:

    Row_1 AB123, 01-mar-2011, 30-mar-2011, data1, data2 
    Row_2 CD123, 01-mar-2011, 30-mar-2011, data1, data2 
    Row_3 CD123, 01-apr-2011, 30-apr-2011, data1, data2 
    Row_4 EF123, 01-nov-2011, 30-nov-2011, data1, data2

Need the final row to be:

    Row_1 AB123, 01-mar-2011,30-apr-2011,data1,data2 
    Row_2 CD123, 01-mar-2011,30-mar-2011,data1,data2
    Row_4 EF123, 01-nov-2011, 30-nov-2011,data1,data2

What I have tried:

Tried to use for loop to check each record and then use if loop to check for each condition

Posted 21-Aug-21 2:45am

Chandan Nagaraj 2021

Updated 21-Aug-21 3:16am

Add a Solution

Comments

Patrice T 21-Aug-21 8:49am

Try to show your code.

Richard MacCutchan 21-Aug-21 9:26am

You need to build a new table with only one entry for each id. For each record in the original table you would check the two dates and only store the earliest and the latest.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	60
Richard MacCutchan	55
Graeme_Grant	35
Andre Oosthuizen	10
Wonde Tadesse	10

Pete O'Hanlon	2,305
OriginalGriff	1,683
Graeme_Grant	1,160
Richard Deeming	893
Dave Kreskowiak	839