python如何读取excel表格中特定列,如何使用Pandas从Excel中读取某些列-Python

I am reading from an Excel sheet and I want to read certain columns: column 0 because it is the row-index, and columns 22:37. Now here is what I do:

import pandas as pd

import numpy as np

file_loc = "path.xlsx"

df = pd.read_excel(file_loc, index_col=None, na_values=['NA'], parse_cols = 37)

df= pd.concat([df[df.columns[0]], df[df.columns[22:]]], axis=1)

But I would hope there is better way to do that! I know if I do parse_cols=[0, 22,..,37] I can do it, but for large datasets this doesn't make sense.

I also did this:

s = pd.Series(0)

s[1]=22

for i in range(2,14):

s[i]=s[i-1]+1

df = pd.read_excel(file_loc, index_col=None, na_values=['NA'], parse_cols = s)

But it reads the first 15 columns which is the l