Filtering Excel Document Data Based On Numerical Values

[eddywinch82]

Hi Sandeep,

Thankyou so much for sorting this out for me, you have almost cracked it !

What needs to be added, or changed in the code i.e. :-

So that only the following Data Displays, not all the other Data :-

Output:
                                                   Aircraft-combined
Venue             BID Date                DISPLAY/                  
ANNAN             606 No Date             DISPLAY                 DS
BERLIN            587 2008-05-12 00:00:00 DISPLAY                  D
COTTESMORE        757 No Date             DISPLAY                 DS
DUXFORD           613 2008-08-15 00:00:00 DISPLAY                  D
EAST FORTUNE      406 No Date             DISPLAY                DHS
GUERNSEY          582 2008-09-10 00:00:00 DISPLAY                DHS
HAMPSTHWAITE      828 No Date             DISPLAY                  D
JERSEY            581 2008-09-10 00:00:00 DISPLAY                DHS
KEMBLE            316 2008-06-21 00:00:00 DISPLAY                 DS
                      No Date             DISPLAY                DHS
                  461 No Date             DISPLAY                  D
PENARTH           303 No Date             DISPLAY                  D
PLYMOUTH HOE      528 2008-06-28 00:00:00 DISPLAY                  D
PORTRUSH          76  2008-09-05 00:00:00 DISPLAY                DHS
                      2008-09-06 00:00:00 DISPLAY                DHS
ROMSEY            175 2008-08-31 00:00:00 DISPLAY                  D
                      No Date             DISPLAY                DHS
ROUGHAM           551 No Date             DISPLAY                 DL
SANICOLE          69  No Date             DISPLAY                DHS
SCARBOROUGH       610 2008-05-25 00:00:00 DISPLAY                 DS
SHAWBURY          188 2008-07-24 00:00:00 DISPLAY                 DS
SHUTTLEWORTH      529 No Date             DISPLAY                  D
SOUTHPORT         584 No Date             DISPLAY                DHS
SUNDERLAND        333 2008-07-25 00:00:00 DISPLAY                 DH
                      No Date             DISPLAY               SHSD
TARRANT RUSHDEN   132 No Date             DISPLAY                DHS
TWINWOOD AIRFIELD 934 2008-08-30 00:00:00 DISPLAY                  D
                      No Date             DISPLAY                  D
WHITBY            125 2008-08-22 00:00:00 DISPLAY                DHS
                      2008-08-23 00:00:00 DISPLAY                DHS
WIGTON            144 2008-07-26 00:00:00 DISPLAY                DHS
WINDERMERE        138 2008-07-25 00:00:00 DISPLAY                DHS
                      2008-07-26 00:00:00 DISPLAY                DHS
WOODSTOCK         362 2008-09-13 00:00:00 DISPLAY                  D

​

But in the 'pretty' version Font in Jupyter Notebook ? And also I want all Solo, 'D' in the Aircraft-combined Column Rows got rid of i.e. :-

BERLIN 587 2008-05-12 00:00:00 DISPLAY D

WOODSTOCK 362 2008-09-13 00:00:00 DISPLAY D

etc

Regards

Eddie