Python Forum
Panel Data Cleaning Drop Identity
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Panel Data Cleaning Drop Identity
Dear all,

I am struggling to drop the complete identity in a Panel data set when the identity has a missing time value in the given range.
In this example I would like to drop every row of the idenity because the year 1993 is missing.

1990 Idenity1
1991 Idenity1
1992 Idenity1
1994 Idenity1

Thank you and have a nice Weekend.

Kind regards,

1. Please post what you have tried
2. Do you mean Pandas dataset? Not familiar with Panel
3. So all 4 of those rows would be dropped because 1993 is missing. That is odd enough there may not be a simple single command to do this. Suggest looping through the dataset and verifying criteria, dropping rows as needed
4. Alternatively, create a second dataset and only add rows to that dataset when the criteria are met. Build it up like this or delete it out as in 3.

Possibly Related Threads…
Thread Author Replies Views Last Post
  Drop rows from data with zero value Devilish 3 1,697 Dec-27-2018, 02:06 AM
Last Post: Devilish

Forum Jump:

User Panel Messages

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