Python Forum

Full Version: csv.read() mangled output
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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