How can I filter by numbers in an excel sheet using Python codes?

Question

I am trying to filter out the data from my excel sheet using Python. When I filter by car "Make" and "Model," it works fine, but when I add a "Year," it does not return any data(Empty). It works with me only if I add any text at the beginning of each cell for the "Year" Column. How can I get the program to filter without adding text to every cell in the "Year" column.

here is function code][1]

user7864386 · Accepted Answer · 2022-02-19 08:17:29Z

2

car_year is user input and input are strings in Python. Presumably "Year" is dtype int column, so df['Year']==car_year returns a Series of Falses. To get your desired outcome, convert car_year to int:

car_filter = df[(df['Make']==car_make) & (df['Model']==car_model) & (df['Year']==int(car_year))]

answered Feb 19, 2022 at 8:17

user7864386

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I filter by numbers in an excel sheet using Python codes?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related