Hi,
I've created a CSV file that has no header. Each row represents a customer order and each cell in that row contains an item from that order. An order can have 1 item or up to 45 items in an order. The problem is that Excel is placing a lot of commas at the end of each row and I'm trying to use the CSV file in a machine learning algorithm w/in Python and it doesn't like the commas. Any idea how to remove them? I've Googled exhaustively for a solution but nothing has worked.
What my file looks like now (Excel doesn't show you the commas but when I open the file in Notepad ++, you can see all of them (see 2nd screenshot below))
When the CSV file is opened in Notepad ++, you can see all of the commas:
I've created a CSV file that has no header. Each row represents a customer order and each cell in that row contains an item from that order. An order can have 1 item or up to 45 items in an order. The problem is that Excel is placing a lot of commas at the end of each row and I'm trying to use the CSV file in a machine learning algorithm w/in Python and it doesn't like the commas. Any idea how to remove them? I've Googled exhaustively for a solution but nothing has worked.
What my file looks like now (Excel doesn't show you the commas but when I open the file in Notepad ++, you can see all of them (see 2nd screenshot below))
When the CSV file is opened in Notepad ++, you can see all of the commas: