Use of queries in CSV files with user input

Question

I have the CSV file:

                                  Movie     Budget  Worldwide Gross  Year
0                                  2012  200000000        791217826  2009
1                               Aladdin  183000000       1050693953  2019
2                   Alice in Wonderland  200000000       1025468216  2010
3                               Aquaman  160000000       1148485886  2018
4                                Avatar  237000000       2847246203  2009

and I have the following code:

opcion = datos[datos["Year"] == 2019 ]

this helped me just show the data from that year...

but my problem is that the year (in this case 2019) needs to be provided by the user (or any other year that they would want to look for) and I dont know how to use int(input()) in order to do that.

thank you

opcion = datos[datos["Year"] == int(input())] or replace the number 2019 with a variable that you read using int(input()) on a separate line. — Henry Ecker
– Henry Ecker ♦, Commented May 21, 2021 at 20:23
thank you! I get this error: Traceback (most recent call last): File "<pyshell>", line 1, in <module> ValueError: invalid literal for int() with base 10: '' i'll try the other way :) — user15772142
– user15772142, Commented May 21, 2021 at 20:30
It worked! I used usuario = int(input('cual es el a? ')) opcion = datos[datos["Year"] == usuario ] opcion... Thank you very much!! — user15772142
– user15772142, Commented May 21, 2021 at 20:36

Corralien · Accepted Answer · 2021-05-21 20:35:51Z

1

A snippet of code to catch exception

try:
    year = input("Enter a year: ")
    opcion = datos[datos["Year"] == int(year)]
    if opcion.empty:
        print(f"No result for year '{year}'")
except ValueError:
    print(f"'{year}' is not a valid date")

answered May 21, 2021 at 20:35

Corralien

121k8 gold badges44 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Use of queries in CSV files with user input

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