Having trouble reading an Excel file and printing results with a specific value in the column filter containing em-dashes/hyphens. Any other column filter value works fine. Looking for assistance to make this query work. The Excel file data is shown below, filtered by the 'Category' column which appears as an em-dash once opened.
The contents of Excel file test.xlsx are filtered based on the 'Category' column
| Name | Age | Category |
|---|---|---|
| Tom | 15 | cata |
| Joseph | 21 | catb |
| Krish | 22 | cata |
| John | 32 | Cat – AB |
import pandas as pd
from pathlib import Path
DATA_DIR = Path.cwd() / r'E:'
excelA = DATA_DIR / 'Test.xlsx'
df = pd.read_excel(excelA)
values1 = df1
# The code below fails due to the em dash but it works if you replace catg = ['cata'] with them
catg = ['Cat – AB']
df_new = df[df['Category'].isin(catg)]
print(df_new)