alternatives to pyspark to query a csv file locally (no distributed computation needed)
pandas can do it. It can read in a csv file with a single line and put the data in a dataframe that you can manipulate.