Northern Haserot

440-703-3100
Login Sign up

Cleaning the file

Modified on: Tue, Dec 12 2023 8:30 AM

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.



Was this answer helpful?