Use pandas.Series.isnull
on the column to find the missing values and index with the result.
import pandas as pd
data = pd.DataFrame({'ticker': ['aapl', 'msft', 'goog'],
'opinion': ['GC', nan, 'GC'],
'x1': [100, 50, 40]})
data = data[data['opinion'].isnull()]