Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Panel Data Cleaning Drop Identity
#1
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,

Max
Quote
#2
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.
Quote

Top Page

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

Forum Jump:


Users browsing this thread: 1 Guest(s)