Need Help With Filtering Data For Excel Files Using Pandas

[eddywinch82]

I have sorted out, the issue about only certain rows being shown.

I found a post where it said how to set, the maximum number of rows shown.

So I typed :-

pd.options.display.max_rows = 1000

And the other required Data, now displays.

I have noticed that in the BID Column, which I now include. In the Data I wan't to keep, the Bid Numbers are the same in both rows, i.e. the same VENUE . So what should I type, to remove rows, where there is only 1 of a Bid Number ? Except where in the A/C Column the values are DHS or DSS ?

So How do I drop the rows, where there