I am working with a file that has the column headers in rows 1-28, and then has the data starting at row 29. The data in row 29 is pipe delimited. I've tried the following, which didn't work:
pd.read_csv(file_name, sep='|', index_col=False)
Any ideas?