Jan-13-2020, 09:55 PM
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.
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.