Pandas read_excel usecols parameter: Pycharm requires int

Viewed 29

Pycharm (v2022.2) is complaining about the usecols input parameter of pd.read_excel. It requires a single int value. The docs on the other hand clearly states that a list-like or callable is allowed.

I used to use something like this before and the code actually works as expected:

pd.read_excel("test.xlsx", usecols="A:C")  # Pycharm: Expected type 'int', got 'str' instead

Also, it is not possible to use a list of int:

pd.read_excel("test.xlsx", usecols=[1, 2, 3])  # Pycharm: Expected type 'int', got 'list[int]' instead 

Is this a bug in Pycharm or did I do anything wrong?

0 Answers
Related