Help python data cleaning

I’m trying to clean the city and zip code for a new project after scraping the data.
How could I extract zip code only and search for the state in a data frame ?
Thank you for your help,
Company City
0 Company 1 Le Mans (72)
1 Company 2 Paris 13e (75)
2 Company 3 La Défense (92)
3 Company 4 Bordeaux (33)
4 Company 5 Nantes (44)

Show us what code you’ve written so far and how it is failing.