Search CSV file by row column

Question

Hi I was wondering if there is a way to search a CSV file without importing CSV module to search by row and column.

Also how could I use re.findall to find instances of a word in a column or row

For example the genre is Horror and the movie title starts with The ..so I'd need to find the total amount of "The" movies in the horror genre

Thanks

pandas is probably the best way to handle csv's and search columns or rows. if you don't want to import the csv module, are you unwilling to import pandas? — Ollie in PGH
– Ollie in PGH, Commented Apr 24, 2021 at 14:27
I'd like to search by row colum without importing csv or using panda — brian.p
– brian.p, Commented Apr 24, 2021 at 14:44

pacdev · Accepted Answer · 2021-04-24 14:51:13Z

1

This may be not the best solution but it works. Let's imagine you have a films.csv file with film name and author like this:

title, author
The dogs, author1
The cats, author2
Cars, author1
Houses, author3
The apples, Jobs

If you want to count the number of occurrences of film name starting by "The":

with open('films.csv', 'r') as f:
    data = f.read()
n = len(re.findall("The*", data))

answered Apr 24, 2021 at 14:51

pacdev

5911 gold badge5 silver badges16 bronze badges

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

1 Comment

Thanks pac for your help