How to fix numpy string error

Question

I am using numpy to create an array out of a .csv file. This file's top row is made up of text, so I copied this command from the article I was using to leave it out when using float(I have left in the whole code for context. The command is the [1:] in the last line)

import numpy as np
import csv
with open("atest.csv", 'r') as f:
    wines = list(csv.reader(f, delimiter=";"))
    print(wines[:3])
wines_array = np.array(wines[1:], dtype=np.float)

However, I still get this error message:

    wines_array = np.array(wines[1:], dtype=np.float)
ValueError: could not convert string to float: 'fixed acidity'

This indicates that it has not left out the top row. Does anyone have any help?

EDIT

This is my .csv file:

"fixed acidity";"volatile acidity";"citric acid";"residual sugar";"chlorides";"free sulfur dioxide";"total sulfur dioxide";"density";"pH";"sulphates";"alcohol";"quality"
7.4;0.7;0;1.9;0.076;11;34;0.9978;3.51;0.56;9.4;5
7.8;0.88;0;2.6;0.098;25;67;0.9968;3.2;0.68;9.8;5

The first line is all one row in my file.

^ That, and you really should be using something like np.loadtxt or genfromtxt or pandas. — cs95
– cs95, Commented Dec 29, 2017 at 13:33

3141 · Accepted Answer · 2017-12-29 14:33:57Z

1

It turned out that python wasn't parsing the file properly, so I switched libraries to pandas and slightly modified and used the code suggested by the user COLDSPEED in the comments. The error appears to be individual to me.

Here is the line of code I used: import pandas as pd; v = pd.read_csv('atestred.csv', error_bad_lines=False).values

edited Dec 29, 2017 at 14:33

answered Dec 29, 2017 at 14:29

3141

4091 gold badge6 silver badges23 bronze badges

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

2 Comments

cs95 Over a year ago

Make sure to add the code you used, so as to help other users with the same problem.

3141 Over a year ago

One sec @COLDSPEED

Collectives™ on Stack Overflow

How to fix numpy string error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related