Suppose I have a file called data.cvs which is
3;2
2;1
1;0.1
0.01;-0.9
I can read it by
import csv
data=list( csv.reader(open('data3.csv','r')) )
but for SM it will had the structure af a matrix of string
[['3;2'], ['2;1'], ['1;0.1'], ['0.01;-0.9']]
How could I eliminate the quotes and replace ; by , ? In passing import is not a word in the documentation .
Note that csv means coma separated value. Here, you want a semicolon to be used as a delimiter, so you can do:
sage: data=list( csv.reader(open('data.csv','r'), delimiter=';'))
sage: data
[['3', '2'], ['2', '1'], ['1', '0.1'], ['0.01', '-0.9']]
Note that it is a list of lists of strings, not number. However, the matrix constructor is able to handle this : you can make it a numerical matrix as follows:
sage: matrix(RDF,data)
[ 3.0 2.0]
[ 2.0 1.0]
[ 1.0 0.1]
[0.01 -0.9]
Asked: 2020-05-06 22:36:16 +0200
Seen: 338 times
Last updated: May 06 '20
Copyright Sage, 2010. Some rights reserved under creative commons license. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
