You can set the column index using index_col parameter available while reading from spreadsheet in Pandas.
Here is my solution:
Firstly, import pandas as pd:
import pandas as pdRead in filename using pd.read_excel() (if you have your data in a spreadsheet) and set the index to 'Locality' by specifying the index_col parameter.
df = pd.read_excel('testexcel.xlsx', index_col=0)At this stage if you get a 'no module named xlrd' error, install it using
pip install xlrd.For visual inspection, read the dataframe using
df.head()which will print the following output
Now you can fetch the values of the desired columns of the dataframe and print it
