how to python mismatched stock symbols for preferred shares code example

Example: how to python mismatched stock symbols for preferred shares

QuantumOnline     -       ALP-Q    
 S&P               -       ALP-Q    
 NYSE              PR      ALPPRQ   
 NYSE Amex         p       ALPpQ    
 Bloomberg        /P       ALP/PQ   
 Charles Schwab   /PR      ALP/PRQ    
 E-Trade           p       ALPpQ    
 Fidelity          PR      ALPPRQ   
 Google Finance    -       ALP-Q    
 JPMorgan          PR      ALP PRQ  
 LPL Financial     '       ALP'Q        
 MarketWatch      .PR      ALP.PRQ  
 Quicken           PR      ALP PRQ  
 TD Ameritrade     -       ALP-Q    
 Vanguard         _p       ALP_pQ   
 Yahoo!           -p       ALP-pQ