Python Forum
Reading floats and ints from csv-like file
Thread Rating:
  • 1 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Reading floats and ints from csv-like file
#9
Modify the code, to get more detailed output of the occurring error.
Without a detailed error message, it's hard to find an error.

import csv
import os
 
filename  = os.path.abspath('/media/dfuu/Data/mt4/EU-1H.txt')
 
def read_csv_data(filename):
    try:
        buffer = None
        with open(filename) as csvfile:
            buffer = csv.reader(csvfile, delimiter=',')
            for row in buffer:
                print(row)
    except csv.Error as e:
        print('Error reading {filename}')
        print(e)
    
if __name__ == '__main__':
    read_csv_data(filename)
Maybe you've still problem with parsing the text.
In your first example it looks like a ByteOrderMark for utf-8.

You can ship around this problem, if you open the file with the right encoding.
with open(filename, encoding='utf-8-sig') as csvfile:
But before you do thins, look first which error you get.
Otherwise it's guessing and guessing is not good in programming.
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
Reply


Messages In This Thread
RE: Reading floats and ints from csv-like file - by DeaD_EyE - Sep-05-2017, 08:20 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
Sad problems with reading csv file. MassiJames 3 791 Nov-16-2023, 03:41 PM
Last Post: snippsat
  When is it safe to compare (==) two floats? Radical 4 877 Nov-12-2023, 11:53 AM
Last Post: PyDan
  Reading a file name fron a folder on my desktop Fiona 4 1,054 Aug-23-2023, 11:11 AM
Last Post: Axel_Erfurt
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,215 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Reading a file JonWayn 3 1,185 Dec-30-2022, 10:18 AM
Last Post: ibreeden
  Reading Specific Rows In a CSV File finndude 3 1,073 Dec-13-2022, 03:19 PM
Last Post: finndude
  Excel file reading problem max70990 1 959 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Replace columns indexes reading a XSLX file Larry1888 2 1,057 Nov-18-2022, 10:16 PM
Last Post: Pedroski55
  [split] why can't i create a list of numbers (ints) with random.randrange() astral_travel 7 1,668 Oct-23-2022, 11:13 PM
Last Post: Pedroski55
  Failing reading a file and cannot exit it... tester_V 8 1,916 Aug-19-2022, 10:27 PM
Last Post: tester_V

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020