search

cbrownley / foundations-for-analytics-with-python

459 stars 681 forks source link

Script still splits final two rows on comma within dollar values #1

Open jaykinghorn opened 7 years ago

jaykinghorn commented 7 years ago

Hello. I hope this is the correct place to provide feedback. In the exercise Read and Write a CSV file (Part 2) the script in the book still splits the final two dollar amounts in the supplier data that contain a comma to indicate thousands. I've re-typed the script from the book, run it from your supplied scripts from the book repository and run it a third time from the current script on the site and continue to receive the same error. The cost data is split across two columns, pushing date into a sixth and seventh column. Is there a subtlety I've missed?

Thanks,

Jay

anemochore commented 4 years ago

You should modify the CSV file opened in Excel, not in text editor, and then save the file as CSV in Excel too.