Search a word by lastname from a text file and print the output which has similar lastname in python

Question

Text file data : sponsors.txt file that has stored data with their names and donations

John Smith,230.5
Sally Jones,380
Mary Smith,104.55
David McDougal,165.7
Sally Matthews,184.5
Peter Evans,300.25

Expected Output :

Please enter a search string: Smith
Search returned 2 results:
John Smith,230.5
Mary Smith,104.55

MyCode:

def read_sponsor_data(file_path, word):
    with open(file_path, 'r') as file:
        content = file.read()
        name_count = content.count(list_sponsor)
        if word in content:
            print('Search returned', name_count, 'results:')
        else:
            print('Search returned no results.')
        for i in range(0, name_count):
            print(content)
    file.close()


if search_sponsor == 1:
    list_sponsor = input("Please enter a search string: ")
    read_sponsor_data("sponsors.txt", list_sponsor)
else:
    print("Invalid Input")

My Output :

Please enter a search string: Smith
Search returned 2 results:
John Smith,230.5
Sally Jones,380
Mary Smith,104.55
David McDougal,165.7
Sally Matthews,184.5
Peter Evans,300.25
John Smith,230.5
Sally Jones,380
Mary Smith,104.55
David McDougal,165.7
Sally Matthews,184.5
Peter Evans,300.25

`for i in range(0, name_count): print(content)` that prints the entire file `name_count` files right? You want to perform a line-by-line search to get the rest of the data you're looking for — Jean-François Fabre, Dec 30 '22 at 20:17
check this (regex but same principle): https://stackoverflow.com/questions/1921894/grep-and-python — Jean-François Fabre, Dec 30 '22 at 20:19
Furthermore, it should be `name_count = content.count(word)` — Swifty, Dec 30 '22 at 20:20

Yevhen Kuzmovych · Answer 1 · 2022-12-30T20:34:00.513

1

file.read() reads the whole file as a string. This string has the inputed name 2 times. Then you print this whole string 2 times. You probably need file.readlines() or iterate over file (i.e. over lines):

def read_sponsor_data(file_path, word):
    with open(file_path, 'r') as file:
        matched_lines = [l for l in file if word in l]

    if matched_lines:
        print('Search returned', len(matched_lines), 'results:')
        for l in matched_lines:
            print(l)
    else:
        print('Search returned no results.')

edited Dec 30 '22 at 20:34

answered Dec 30 '22 at 20:20

Yevhen Kuzmovych

10,940
7
28
48

I prefer `name_count > 0`. I think it's more explicit – Yevhen Kuzmovych Dec 30 '22 at 20:30
fair enough but more pythonic: check if list is not empty with `if matched_lines:`, compute length later if needed. Your call anyway – Jean-François Fabre Dec 30 '22 at 20:30
i want to iterate over file so i can get my expected output. – Jack Janmejay Dec 30 '22 at 21:15
all i want is when i enter a substring like smith it iterate the file and show the two names and their values as per substring. Any helpful Tips??? – Jack Janmejay Dec 30 '22 at 21:17
Doesn't the code in my answer produce the result you mention in your question? – Yevhen Kuzmovych Dec 30 '22 at 21:59

Search a word by lastname from a text file and print the output which has similar lastname in python

1 Answers1