woodpecker | Woodpecker is a community fork of the Drone CI system | Continous Integration library

First off, it's important to know why you're missing data, and to see if you can possibly impute rather than just drop.

If you still want to drop, you can use df = df.dropna(how='any').

The reason why Excel shows "N/A" as the value for missing data is because that's Excel's way of showing missing data. It doesn't mean that the value of the cell that is missing data is N/A--that would be a string containing an N, a slash, and an A. Instead, you can try df = df[~df['Year'].isnull()] as an alternative method for selecting non-null values.

Remove the min-width and use flex-shrink:0;

Just create a step down loop on each level for bird, color and size. Then create a temporary container and continually merge it:

I have changed some rules. Could you check it?

Try to use window functions with case:

You could first write a query that returns list_ids “having” both types of woodpeckers. (Group by list_id and write a condition in the having clause that will return the ids).

Something like