Import CSV data into array and turn into integers

[DoctorSmiles]

Hey guys,

I am working on a school project and need to make it so that i can import data from a CSV file into an array and use it to do calculations. I am able to import the file but when i do it imports as strings. I also need that data in an array. This is what i have:

1 2 3 4 5 6 7 8 9 10 11

import csv   x = [] y = []   with open('FinalData.csv') as csvfile:        csvReader = csv.reader(csvfile)        for row in csvReader:                x.append(row[0]), y.append(row[1])           print(x,y)

It will print the arrays but the number values will be strings. Any idea how to change?
Thanks for the help

[sridhar]

In Python you have an option called list for the concept of array.
I couldn't able to get what your expected output will look like.
This might work !

1 2 3 4 5 6 7 8

import csv data =[]    with open('FinalData.csv') as csvfile:        csvReader = csv.reader(csvfile)        data = list (csvReader)            print(data)

[ndc85430]

You need to use the int of float functions to convert the strings to numbers.

[DoctorSmiles]

import csv
data =[]
  
with open('FinalData.csv') as csvfile:   
    csvReader = csv.reader(csvfile)   
    data = list (csvReader)
          
print(data)

Can you explain? i tried adding x = int(x) but i got the error
int() argument must be a string, a bytes-like object or a number, not 'list'

[ndc85430]

That quote is wrong; I didn't write that code.

In any case, the error is self explanatory: you can't pass a list to int, only individual strings. So either iterate over the list calling it in each one or use a list comprehension (or map).

[perfringo]

If floats are OK for calculations then one can use QUOTE_NONNUMERIC with csv.reader.

1 2 3 4 5 6 7

import csv   with open('numbers', 'r', newline='') as f:     reader = csv.reader(f, quoting=csv.QUOTE_NONNUMERIC)     floats = list(*zip(*reader)) # floats value with random sample data, one value per row in 'numbers' file: [5.0, 7.0, 12.0, 65.0, 7.0, 12.0, 65.0]