python-pandasHow to use column names with spaces in queries

Usage example

import pandas as pd

#Apartments
apartments = pd.DataFrame(columns=['Area m2', 'Age', '#Rooms'])

apartments['Area m2'] = [105, 224, 49, 20]
apartments['Age'] = [3, 5, 1, 1]
apartments['#Rooms'] = [2, 4, 1, 1]

print("All apartments")
print(apartments)

small_apartments = apartments.query('`Area m2` < 25')
print("Small")
print(small_apartments)

lucky = apartments[apartments.Age == apartments['#Rooms']]
print("Lucky")
print(lucky)

output

All apartments
   Area m2  Age  #Rooms
0      105    3       2
1      224    5       4
2       49    1       1
3       20    1       1
Small
   Area m2  Age  #Rooms
3       20    1       1
Lucky
   Area m2  Age  #Rooms
2       49    1       1
3       20    1       1