Comments by Member 10445425 (Top 2 by date)

Member 10445425 27-Sep-19 6:10am View

Now I am confused. I had a file in a notepad, I imported this to excel via comma separator and saved as a CSV file. Currently, data looks like this in CSV file. Do i need to do something with this more to call it as CSV?

Installation Manufacturing Sales & Distribution Project Development Other
43934 24916 11744 0 12908
52503 24064 17722 0 5948
57177 29742 16005 7988 8105
69658 29851 19771 12169 11248
97031 32490 20185 15112 8989
119931 30282 24377 22452 11816
137133 38121 32147 34400 18274
154175 40434 39387 34227 18111

Member 10445425 27-Sep-19 4:39am View

Hi Richard, I copied the table from excel to a csv file. when I am using print(data) command in python, it shows me following

Installation Manufacturing Sales & Distribution Project Development Other
0 43934 24916 11744 0 12908
1 52503 24064 17722 0 5948
2 57177 29742 16005 7988 8105
3 69658 29851 19771 12169 11248
4 97031 32490 20185 15112 8989
5 119931 30282 24377 22452 11816
6 137133 38121 32147 34400 18274
7 154175 40434 39387 34227 18111