Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
csv.read() mangled output
#1
I have a problem where tabulated data seems
to be malformed by the csv.read(0 function.
The input data called from the file is dis-
played below:


pressure, 1011521, *nixepochtime, 1525432927808
pressure, 1011510, *nixepochtime, 1525432807594
pressure, 1011485, *nixepochtime, 1525432687379
pressure, 1011465, *nixepochtime, 1525432567158
pressure, 1011452, *nixepochtime, 1525432446813
pressure, 1011428, *nixepochtime, 1525432369208
pressure, 1011403, *nixepochtime, 1525432206811
pressure, 1011348, *nixepochtime, 1525432109999

The snippet below produces the output shown further
down. The first part of the output appears as expected,
then suddenly about the last 10 lines of the input file
are displayed for a second time but with added characters.

The code snippet below is where the malformation occurs.

with open('barometer.txt', 'r') as pressure:

    formatted_file = csv.reader(pressure, delimiter = ',')
      
    for line in formatted_file:
        print (line)
It produces the output displayed below.

[' pressure', ' 1011521', ' *nixepochtime', ' 1525432927808']
[' pressure', ' 1011510', ' *nixepochtime', ' 1525432807594']
[' pressure', ' 1011485', ' *nixepochtime', ' 1525432687379']
[' pressure', ' 1011465', ' *nixepochtime', ' 1525432567158']
[' pressure', ' 1011452', ' *nixepochtime', ' 1525432446813']
[' pressure', ' 1011428', ' *nixepochtime', ' 1525432369208']
[' pressure', ' 1011403', ' *nixepochtime', ' 1525432206811']
[' pressure', ' 1011348', ' *nixepochtime', ' 15254321099991521', ' *nixepochtime', ' 1525432927808]', '']
[" ['pressure'", ' 1011510', ' *nixepochtime', ' 1525432807594]', '']
[" ['pressure'", ' 1011485', ' *nixepochtime', ' 1525432687379]', '']
[" ['pressure'", ' 1011465', ' *nixepochtime', ' 1525432567158]', '']
[" ['pressure'", ' 1011452', ' *nixepochtime', ' 1525432446813]', '']
[" ['pressure'", ' 1011428', ' *nixepochtime', ' 1525432369208]', '']
[" ['pressure'", ' 1011403', ' *nixepochtime', ' 1525432206811]', '']
[" ['pressure'", ' 1011348', ' *nixepochtime', ' 1525432109999]]']

If you have potential insight or suggestions
my ears are listening.

Mel Blanchard
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  No output for the code to read emails avani9659 6 4,248 Aug-14-2018, 08:30 AM
Last Post: avani9659

Forum Jump:

User Panel Messages

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