import numpy as np
import pandas as pd
import os
import sys

df=pd.read_csv("search_db_input.csv",header=None)
bs=[]
com_bs=[]

for i in np.arange(len(df)):
    df_i=df[0][i]
    bs.append(df_i)

bs.sort(key=lambda x: x.lower())

for j in np.arange(len(bs)):
    bs_j=bs[j]
    command=f"find plot -name '{bs_j}*.png' | sort"
    com_bs.append(command)
    
BS=pd.DataFrame(com_bs)
BS.to_csv("search.sh",header=None, index=False)

os.system("bash search.sh")