Convert strings into float value while working on csv file

Question

I got CSV files to train but while training error is coming.

ValueError: could not convert string to float: 'CBH'

Column B contains words like CBH, which is not a number. You need to convert only columns I and J. — Barmar
– Barmar, Commented Aug 28, 2020 at 10:34
What do you understand from that error message? Please provide a minimal reproducible example. — AMC
– AMC, Commented Aug 28, 2020 at 10:40

stackz · Accepted Answer · 2020-08-28 10:44:45Z

1

Label Encoding can turn the available values into their own unique value.

import pandas as pd
import sklearn

df = pd.read_csv('file-path')

le = sklearn.preprocessing.LabelEncoding()
le.fit(df['code'])
df = df[le.transform(df['code'])]

# change back
df = df[le.inverse_transform(df['code'])]

Sklearn Label Encoding Documentation

answered Aug 28, 2020 at 10:44

stackz

847 bronze badges

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

Comments

bitranox · Accepted Answer · 2020-08-28 10:36:14Z

0

obviously You try to convert values of row "B" to float. And the Value "CBH" can not be converted to a floating point number.

answered Aug 28, 2020 at 10:36

bitranox

1,96416 silver badges22 bronze badges

Collectives™ on Stack Overflow

Convert strings into float value while working on csv file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related