This is still a bug! If I read the documentation it said clearly For example, a valid list-like usecols parameter would be [0, 1, 2] or ['foo', 'bar', 'baz'].
If I use it as described I get ValueError: Usecols do not match columns, columns expected but not found: ['Col3', 'Col1'].
usecase: https://stackoverflow.com/a/78681763/12621346
If I would read according old column names and rename it to new names this works only with index 1, 2, 3 and not column names.
Rel #580
This is still a bug! If I read the documentation it said clearly For example, a valid list-like usecols parameter would be [0, 1, 2] or ['foo', 'bar', 'baz']. If I use it as described I get ValueError: Usecols do not match columns, columns expected but not found: ['Col3', 'Col1'].
usecase: https://stackoverflow.com/a/78681763/12621346 If I would read according old column names and rename it to new names this works only with index 1, 2, 3 and not column names.