Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Text file read issues
#17
let's do it properly
import csv

with open('170825  t05 L11O44S3.txt', encoding='utf-16') as f:
    rdr = csv.reader(f, delimiter='\t')
    for line in rdr:
        print(line)
each line will turn to 2-element list. you can join them together again or use separately

Output:
['25 August 2017 09:15:00', '23.19'] ['25 August 2017 09:00:00', '22.98'] ['25 August 2017 08:45:00', '22.76'] ['25 August 2017 08:30:00', '22.62'] ['25 August 2017 08:15:00', '22.41'] ['25 August 2017 08:00:00', '22.34'] ....
or if you prefer single list
import csv

with open('170825  t05 L11O44S3.txt', encoding='utf-16') as f:
    rdr = csv.reader(f, delimiter='\t')
    data = [' '.join(line) for line in rdr]
    print(data)
Output:
['25 August 2017 09:15:00 23.19', '25 August 2017 09:00:00 22.98', '25 August 2017 08:45:00 22.76', '25 August 2017 08:30:00 22.62', '25 August 2017 08:15:00 22.41',...]
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
Text file read issues - by Complex_Potential - Jul-23-2018, 08:06 AM
RE: Text file read issues - by gontajones - Jul-23-2018, 10:16 AM
RE: Text file read issues - by buran - Jul-23-2018, 11:03 AM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 11:32 AM
RE: Text file read issues - by buran - Jul-23-2018, 12:04 PM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 12:18 PM
RE: Text file read issues - by buran - Jul-23-2018, 01:46 PM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 02:13 PM
RE: Text file read issues - by snippsat - Jul-23-2018, 02:20 PM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 02:41 PM
RE: Text file read issues - by Complex_Potential - Jul-24-2018, 02:05 PM
RE: Text file read issues - by gontajones - Jul-24-2018, 02:22 PM
RE: Text file read issues - by snippsat - Jul-24-2018, 02:24 PM
RE: Text file read issues - by Complex_Potential - Jul-24-2018, 03:52 PM
RE: Text file read issues - by buran - Jul-24-2018, 04:03 PM
RE: Text file read issues - by Complex_Potential - Jul-24-2018, 04:10 PM
RE: Text file read issues - by buran - Jul-24-2018, 04:23 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Connecting to Remote Server to read contents of a file ChaitanyaSharma 1 405 May-03-2024, 07:23 AM
Last Post: Pedroski55
  Recommended way to read/create PDF file? Winfried 3 3,102 Nov-26-2023, 07:51 AM
Last Post: Pedroski55
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,815 Nov-09-2023, 10:56 AM
Last Post: mg24
  read file txt on my pc to telegram bot api Tupa 0 1,269 Jul-06-2023, 01:52 AM
Last Post: Tupa
  parse/read from file seperated by dots giovanne 5 1,248 Jun-26-2023, 12:26 PM
Last Post: DeaD_EyE
  Formatting a date time string read from a csv file DosAtPython 5 1,613 Jun-19-2023, 02:12 PM
Last Post: DosAtPython
  How do I read and write a binary file in Python? blackears 6 8,138 Jun-06-2023, 06:37 PM
Last Post: rajeshgk
  Read csv file with inconsistent delimiter gracenz 2 1,354 Mar-27-2023, 08:59 PM
Last Post: deanhystad
  Read text file, modify it then write back Pavel_47 5 1,839 Feb-18-2023, 02:49 PM
Last Post: deanhystad
  Correctly read a malformed CSV file data klllmmm 2 2,258 Jan-25-2023, 04:12 PM
Last Post: klllmmm

Forum Jump:

User Panel Messages

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