I have a small Excel file with the data as it the below print screen shows:
which are imported by Python through a .csv file by the following code:
import csvwith open(r"C:\Users\ac324485\Downloads\Daily files\File.csv") as csvfile: rows = list(csv.reader(csvfile)) data_header = rows data_rows = rows[1:]for x in data_header: print(x)for x in data_rows: print(x)
BTW you may give this a try...
Open in new window