Searching through a csv file

main.py

import pandas as pd

# Load the data from the CSV file into a DataFrame
file_path = "data.csv"  # Replace with the actual path to your CSV file
df = pd.read_csv(file_path)

# Get user input for the search criteria
search_input = input("Enter the value you want to search for: ")

# Filter the DataFrame based on the search criteria
result = df[df.apply(lambda row: row.astype(str).str.contains(search_input, case=False).any(), axis=1)]

# Print only the specified columns
columns_to_print = ['txref', 'txid', 'flwref', 'raveref', 'custemail', 'amount', 'currency', 'status', 'paccountfirstname', 'paccountlastname']
print(result[columns_to_print])