import pandas as pd def prepare_csv_data(): """ Function to process the CSV data for easier lookup. This is not used in the main app, but shows how the CSV data would be processed. """ import requests import io # Download the CSV response = requests.get("https://hebbkx1anhila5yf.public.blob.vercel-storage.com/crop_diseases_treatments-DF4R6CPNHW63YU8EkBgGg0uw1lvwq5.csv") df = pd.read_csv(io.StringIO(response.text)) # Process the data df["Crop_lower"] = df["Crop"].str.lower() df["Disease_lower"] = df["Disease"].str.lower() # Save processed data df.to_csv("processed_treatments.csv", index=False) return df