Cleaning the file

The file comes out as a tilde delimited file, it needs to be edited to become a CSV.

This is what I used to get a successful upload, with a little manual work in there as well.

import pandas as pd

df = pd.read_csv('File from Unix Name', sep='~')
df.to_csv('output file name.csv', index=False)

I then had to drop the column that remained on the end of the file, but after that it was good to upload.