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
#2
(Sep-04-2017, 05:06 PM)Krookroo Wrote: [...]code to get the values and get rid of the commas and EOL characters [...] My main goal is to just have something working
I haven't read your whole post, but if I'm understand correct, you're over-complicating things
# -*- coding: latin-1 -*-

import re

sample = """��1.12005000,1.11800000,14574
1.11947000,1.11811000,8285
1.12035000,1.11749000,7979
1.11812000,1.11597000,18181
1.13148000,1.11499000,30360
1.13176000,1.12344000,57786
1.12441000,1.11997000,24175
1.12261000,1.12067000,14455
1.12466000,1.12198000,10255
1.12643000,1.12209000,29588
"""

print(re.findall(r"[\d.]+", sample))
If that solves your problem, and you still have other questions, it would help to break them down.
Output:
$ python testit.py  ['1.12005000', '1.11800000', '14574', '1.11947000', '1.11811000', '8285', '1.12035000', '1.11749000', '7979', '1.11812000', '1.11597000', '18181', '1.13148000', '1.11499000', '30360', '1.13176000', '1.12344000', '57786', '1.12441000', '1.11997000', '24175', '1.12261000', '1.12067000', '14455', '1.12466000', '1.12198000', '10255', '1.12643000', '1.12209000', '29588']
Reply


Messages In This Thread
RE: Reading floats and ints from csv-like file - by micseydel - Sep-04-2017, 05:52 PM

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,056 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,915 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