I have not tried this yet. Please tell me if this works
I believe that pandas may not be the answer. Perhaps you could use the native csv module?
You could use this code:
import csv
with open('databooks.csv', 'r', newline='') as data:
csvreader = csv.reader(data) # Creates an iterator that returns rows as lists
# If your CSV has a header, you can skip it or store it:
header = next(csvreader)
for row in csvreader:
print(row) # Each row is a list of strings