Python Programming Searching CSV Files - Part 04

A little update to the previous video on searching CSV files. I said in the previous video I would show how to search for rows using known information such as the position the data was in to cut down on unnecessary loops.

[killzinsh]

The error redundancy @ 5:55 you can use the .lower() function. So if you type Female it would lower it to female when you are checking. It would look something like this gender = input("Enter gender: ").lower() or if row[2] == gender.lower(). It's just heads up because checking every possible capitalization is just waste of space and time + the code won't look good!

[higiniofuentes]

The difference between the video before and this is only a question to save time!

[tareknabih]

you wrote print(row) so it must print all the list not just males can anyone explain it to me please?

[Shremmer]

Any chance you can do a video on merging different CSV files where you want certain columns from each?

[MubinBro]

how find string in pipe deliiter " | "
ex, assum name as column is has values like this
apple|ball|cat|dog
if want cat, how to do

[siriusgamingrealm]

The words in your program are very tiny as an ant.

[nigelblanchard]

The videos part 3 and part 4 are really duplicates and you dont really expand on how to search for a specific name other than end up with a column or genders ie male or female. It would be useful if you explained how to search for a specific name i.e jane doe or score because as you repeatedly say you may end up having to search thru 1000s or rows and all you have done is produce a search field column of say 1000s of males or females what is the good of that. It does perhaps explain why you have so few viewers and it is shame you dont a follow up as your style is patient but this type of video tutorial does take the beginner very far I am sorry to say. Indeed this is pointless stuff