CODEWITHSUNDEEP
pythonpython-3.x
Tetra
Tetra

Reputation: 15

Decimal error in list

I'm trying to input a csv file that I can then use to do calculations:

import csv
data=[]
file=input ("Enter file name: ")
with open(file,"r") as f:
      reader=csv.reader(f)

            for row in reader:
                  data.append([x.strip(";") for x in row])
            print(data)

print("Calculate COV")
lst= data
spl= [x.split(";") for y in lst for x in y]
flattened = [float(x) for y in spl for x in y if x]   
print (flattened)

But I keep getting this when I use decimal numbers:

[['13', '25;12', '97;13', '12;13', '47;13', '44;13', '09;12', '86;12', '78;12', '91;12', '93;12', '91;13', '11'], ['12', '92;13', '42;13', '58;13', '7;13', '62;13', '7;13', '31;12', '86;12', '59;12', '81;13', '46;12', '9'], ['13', '39;13', '5;13', '29;13', '26;13', '38;13', '45;13', '46;11', '95;12;12', '57;13', '22;12', '88'], ['12', '48;13', '76;13', '7;13', '77;13', '08;13', '48;13', '25;12', '31;12', '56;12', '56;12', '95;13', '38'], ['12', '52;14', '07;14', '46;14', '13;13', '98;14', '07;13', '92;12', '7;13', '01;12', '79;13;13', '13']]

When I should have this:

[13.25, 12.97, 13.12, 13.47, 13.44, 13.09, 12.86, 12.78, 12.91, 12.93, 12.91, 13.11, 12.92, 13.42, 13.58, 13.7, 13.62, 13.7, 13.31, 12.86, 12.59, 12.81, 13.46, 12.9, 13.39, 13.5, 13.29, 13.26, 13.38, 13.45, 13.46, 11.95, 12.57, 13.22, 12.88, 12.48, 13.76, 13.7, 13.77, 13.08, 13.48, 13.25, 12.31, 12.56, 12.56, 12.95, 13.38, 12.52, 14.07, 14.46, 14.13, 13.98, 14.07, 13.92, 12.7, 13.01, 12.79, 13.0, 13.13]

Upvotes: 0

Views: 89

Answers (2)

Padraic Cunningham
Padraic Cunningham

Reputation: 180482

Try this:

import csv
data=[]
import re
with open("out.csv","r") as f:
        reader=csv.reader(f,delimiter=";")
        for row in reader:
              print row
              data+=[x.split(",") for x in row]
        print(data)

print("Calculate COV")

flattened = [float(x) for y in data for x in y]

Upvotes: 1

Bill Lynch
Bill Lynch

Reputation: 81986

It's really not clear how you are trying to use the CSV module. First, by default, the csv module is going to use comma separated values, not semicolon separated values.

But either way, let's try writing some code:

import csv

class MyDialect(csv.excel):
    delimiter = ';'

with open('in.csv', 'r') as f:
    reader = csv.reader(f, MyDialect())
    data = list(reader)

data = [[float(elem.replace(',', '.')) for elem in line] for line in data]

for line in data:
    print line

in.csv

13,25;12,97;13,12;13,47;13,44;13,09;12,86;12,78;12,91;12,93;12,91;13,11
12,92;13,42;13,58;13,7;13,62;13,7;13,31;12,86;12,59;12,81;13,46;12,9
13,39;13,5;13,29;13,26;13,38;13,45;13,46;11,95;12;12,57;13,22;12,88
12,48;13,76;13,7;13,77;13,08;13,48;13,25;12,31;12,56;12,56;12,95;13,38
12,52;14,07;14,46;14,13;13,98;14,07;13,92;12,7;13,01;12,79;13;13,13

stdout

[13.25, 12.97, 13.12, 13.47, 13.44, 13.09, 12.86, 12.78, 12.91, 12.93, 12.91, 13.11]
[12.92, 13.42, 13.58, 13.7, 13.62, 13.7, 13.31, 12.86, 12.59, 12.81, 13.46, 12.9]
[13.39, 13.5, 13.29, 13.26, 13.38, 13.45, 13.46, 11.95, 12.0, 12.57, 13.22, 12.88]
[12.48, 13.76, 13.7, 13.77, 13.08, 13.48, 13.25, 12.31, 12.56, 12.56, 12.95, 13.38]
[12.52, 14.07, 14.46, 14.13, 13.98, 14.07, 13.92, 12.7, 13.01, 12.79, 13.0, 13.13]

Upvotes: 2

Related Questions