How can I filter keywords from a csv file using Python [duplicate]

Question

I am trying to write a Python code which opens a csv file, filter keywords from specific columns and display the results.

The csv file has 500 rows and 7 columns separated by comma.

That's my code. Not sure if makes much sense.

with open('csv_file') as csvfile:
    readCSV = csv.reader(csvfile, delimiter=',')
    for row in readCSV:
        Title == row[4]
        Author(s) == row[5]
        Genre == row [7]
        if row[1] == entrada:
            results.append()

    print(Results.format(entrada, results))

Sadra · Accepted Answer · 2022-02-21 17:10:43Z

1

This should work for single column

import pandas as pd

df = pd.read_csv('path/to/file.csv')

print(df.loc[df['Author(s)'].str.contains(keyword)]])

you can search for multiple keywords like this :

keyword="Mat|Tom"

edited Feb 21, 2022 at 17:10

answered Feb 21, 2022 at 16:04

Sadra

2,8622 gold badges24 silver badges34 bronze badges

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

5 Comments

Thay Over a year ago

That worked perfectly, because I create a new file with a single column. Thank you very much! I appreciate your help!

Thay Over a year ago

What if the user wants to search for the ISBN number of a book. In the csv file there is a column for ISBN number of each book.

Sadra Over a year ago

@BecKy wouldnt changing the the column name to 'ISBN' helps? for exact match this also works: df[df['IBSN'] == 'ibsn_to_search'].

Sadra Over a year ago

it means there is no column with that name you can get a sense of your dataframe by print(df.head()), also list columns by print(list(df.columns))

Sadra Over a year ago

I modified the original answer. you can use .loc

Collectives™ on Stack Overflow

How can I filter keywords from a csv file using Python [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related