My project is a Flask application where the user can upload a CSV file in the UI. The CSV file contains three colums of data: Name, RFID, and Barcode. The problem is I need a way to read this CSV file even if there is no header that describes what each column is. Also, the CSV columns can be in any format, for example:
Name, RFID, Barcode
or
Barcode, RFID, Name
I need my backend to automatically detect what each column is, even without a header file, this is the problem I am running into.
Does anyone have any ideas?