I decided to load the files into a DataFrame with a single column and then do the processing before splitting it into separate columns and this works just fine.

@Hyper Guy​ thanks for the link, I didn't try that but it seems like it would resolve the issue.