failed to convert string to int in csv file using pandas

Question

I am new in pandas and having a problem Failed to convert String to float while reading csv file using pandas,i have used so far

pd.read_csv('Book2.csv',delimiter=',', index_col=0, skiprows=1,converters={'Open Price (Rs.)':float})

and tried dtype also

MaxU - stand with Ukraine · Accepted Answer · 2017-06-23 23:06:25Z

2

Check line 1873 in the CSV file - it has a header line (column labels).

answered Jun 23, 2017 at 23:06

212k37 gold badges402 silver badges436 bronze badges

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

Comments

Mr_U4913 · Accepted Answer · 2017-06-23 23:05:25Z

1

You can do

modelFeatures = [contains all the columns' names you use]
df = df[modelFeatures].astype(float)

answered Jun 23, 2017 at 23:05

Mr_U4913

1,3548 silver badges12 bronze badges