How do I convert data from .csv file into a NumPy array and use statistics to find the mean of the data? [duplicate]

Question

I want to convert the data from the .csv file into a NumPy array and then find the mean of the data.

import csv
import numpy as np
import statistics as stat
with open('pima-indians-diabetes.csv') as csvfile:
    readCSV = csv.reader(csvfile, delimiter=',')
    for row in readCSV:
        x = np.array(row[1])
        z = stat.mean(x)
        print(z)

numpy should have own function to read .csv or .tab data.

furas
– furas

2019-04-22 00:06:06 +00:00
Commented Apr 22, 2019 at 0:06 — furas
– furas, Commented Apr 22, 2019 at 0:06
use numpy.loadtxt with delimiter=','

furas
– furas

2019-04-22 00:07:42 +00:00
Commented Apr 22, 2019 at 0:07 — furas
– furas, Commented Apr 22, 2019 at 0:07

Matt VanEseltine · Accepted Answer · 2019-04-22 00:06:55Z

0

numpy arrays have a mean method built-in.

>>> import numpy
>>> data = [3, 6, 3, 5, 3, 2]
>>> numpy.array(data).mean()
3.6666666666666665

To get in the csv, see the genfromtxt function: https://docs.scipy.org/doc/numpy/reference/generated/numpy.genfromtxt.html

answered Apr 22, 2019 at 0:06

Matt VanEseltine

1482 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

B. Adams Over a year ago

I attempted to find the mean using the NumPy method, but I got the error "cannot perform reduce with flexible type".

B. Adams Over a year ago

Thanks Matt VE, that solved my problem.

Collectives™ on Stack Overflow

How do I convert data from .csv file into a NumPy array and use statistics to find the mean of the data? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related