python dataframe query with spaces in column name

Starting with Pandas v. 0.25, it is possible to refer to columns with names containing spaces if you enclose the column name in backticks within the query.

Using Pandas 0.25.2:

>>> df = pd.DataFrame({'a a': [1, 0], 'b b': [1, 1]})
>>> df
   a a  b b
0    1    1
1    0    1
>>> df.query('`a a`==`b b`')
   a a  b b
0    1    1

From the API docs: https://pandas.pydata.org/pandas-docs/version/0.25/reference/api/pandas.DataFrame.query.html

In your case, the usage would be:

dfResult.query('`Column A` in @ExcludeData')

I wouldn't use query function. I would use the square bracket notation:

dfResult = dfResult[dfResult['Column A'].isin(ExcludeData)]

As pointed out by @ayhan, it's not supported right now. However, you can make sure to read your columns without space.

In [51]: df
Out[51]: 
    A  B
0   1  2
1   3  5
2   4  8
3   5  5
4   4  4
5   5  2
6   9  8
7   8  9
8   4  6
9   2  3

In [52]: df.columns
Out[52]: Index([u' A', u'B'], dtype='object')

In [53]: pd.read_csv(pd.io.common.StringIO(df.to_csv(index=False)),sep='\s*,').query('A in [2,3]') 
Out[53]: 
   A  B
1  3  5
9  2  3