Nov-24-2023, 04:45 PM
I'm trying to learn how to use Pandas to manipulate csv's and excel files.
One thing I'm trying to do is read a list of colors from a csv list, then ask the user for a color input.
Then I want to compare the user input to the data read from the color csv list.
The problem I have is when I type in a color I know that is on the list, like say "Aqua" or "Yellow" for example, I will get the message "This value is not on the list."
Is there some sort of type conversion or other comparison I need to be doing?
Code for reference.
One thing I'm trying to do is read a list of colors from a csv list, then ask the user for a color input.
Then I want to compare the user input to the data read from the color csv list.
The problem I have is when I type in a color I know that is on the list, like say "Aqua" or "Yellow" for example, I will get the message "This value is not on the list."
Is there some sort of type conversion or other comparison I need to be doing?
Code for reference.
import pandas as pd
df = pd.read_csv('color_list_csv.csv', header = None)
print(df)
User_Color_Input = input("Please enter a Color: ")
if 'User_Color_Input' in df.values :
print("\nThis value exists in Dataframe")
else :
print("\nThis value does not exist in Dataframe")
df.to_excel('color_list_output.xlsx', index = False)This is the color list I'm using for reference, its a single column in csv file.
