Pandas object to float

Pandas dataframe convert string to float

df_raw['PricePerSeat_Outdoor'] = pd.to_numeric(df_raw['PricePerSeat_Outdoor'], errors='coerce')

Source: stackoverflow.com

Convert column to numeric pandas

# convert all columns of DataFrame
df = df.apply(pd.to_numeric) # convert all columns of DataFrame

# convert just columns "a" and "b"
df[["a", "b"]] = df[["a", "b"]].apply(pd.to_numeric)

Source: stackoverflow.com

Convert dataframe to float

df["data"] = df["data"].astype(float)

Source: app.dataquest.io

Pandas object to float

df['DataFrame Column'] = df['DataFrame Column'].astype(float)

Source: datatofish.com

Object to int and float conversion pandas

In [39]:

df['2nd'] = df['2nd'].str.replace(',','').astype(int)
df['CTR'] = df['CTR'].str.replace('%','').astype(np.float64)
df.dtypes
Out[39]:
Date         object
WD            int64
Manpower    float64
2nd           int32
CTR         float64
2ndU        float64
T1            int64
T2            int64
T3            int64
T4           object
dtype: object
In [40]:

df.head()
Out[40]:
        Date  WD  Manpower   2nd   CTR  2ndU   T1  　　T2   T3     T4
0   2013/4/6   6       NaN  2645  5.27  0.29  407   533  454    368
1   2013/4/7   7       NaN  2118  5.89  0.31  257   659  583    369
2  2013/4/13   6       NaN  2470  5.38  0.29  354   531  473  　　383
3  2013/4/14   7       NaN  2033  6.77  0.37  396   748  681    458
4  2013/4/20   6       NaN  2690  5.38  0.29  361   528  541    381

Source: stackoverflow.com

Similar codes

0 vote181 views1 answer
\xa python
Python
-2 votes184 views2 answers
Float() argument must be a string or a number, not 'dict_values'
Python
4 votes175 views1 answer
What makes the bot talk? is there a word i have to say?
Python
0 vote189 views1 answer
Convert .tiff image stack to unit8 format
Python
6 votes195 views2 answers
ModelForm
Python
0 vote205 views1 answer
Strftime python multiple formats
Python
0 vote210 views1 answer
How to get data from json web api in python
Python
0 vote220 views1 answer
Django allauth Reverse for 'password_reset_confirm' not found. 'password_reset_confirm' is not a valid view function or pattern name.
Python
8 votes218 views3 answers
Jinja templates tables
Python
36 votes184 views6 answers
Move files in python
Python