Importing Data from CSV without Byte Order Markers

Asked Oct 06 '18 at 14:29

Active Oct 06 '18 at 14:48

Viewed 67 times

I am importing data from a csv. The first line of data is bringing in "ï»¿0". The first line in the csv is 0 and I made sure that nothing was in front of the numbers. How can i get rid of ï»¿ ?

with open('C:\\Users\jez40\Desktop\Tide_Data.csv', 'r') as data_file:
     data = csv.reader(data_file, delimiter=',')
     for i in data:
     t = i[0]

here are the first few lines of the csv:
0, 1388.143433
5, 1388.143433
10, 1388.14624
15, 1388.147217
20, 1388.150024

edited Oct 06 '18 at 14:48

artomason

3,625
5
20
43

asked Oct 06 '18 at 14:29

user3475905

Can you share your csv or a sample of it? – devdob Oct 06 '18 at 14:31
0,1388.143433 5,1388.143433 10,1388.14624 15,1388.147217 20,1388.150024 The first few lines – user3475905 Oct 06 '18 at 14:32
are those rows or columns or what? can you add them to your question so everyone can see. – devdob Oct 06 '18 at 14:34
Is it a Word document? A Unicode byte order mark? – Jongware Oct 06 '18 at 14:34
Please edit your question and add that information to it. Comments are not a good place to include code. – artomason Oct 06 '18 at 14:35
this is a csv file i made in excel but the data that i posted is copied/ pasted from notepad++ – user3475905 Oct 06 '18 at 14:36
it looks like after changing the encoding to utf-8, i did not get the BOM. Thank you – user3475905 Oct 06 '18 at 14:39
I was just about to suggest that. If you feel you have answered your own question, feel free to post an answer for others. – artomason Oct 06 '18 at 14:40
1

Check the answer here https://stackoverflow.com/questions/34399172/why-does-my-python-code-print-the-extra-characters-%C3%AF-when-reading-from-a-tex. – devdob Oct 06 '18 at 14:40

Importing Data from CSV without Byte Order Markers

0 Answers0