Pandas change to numeric

>>> s = pd.Series(["8", 6, "7.5", 3, "0.9"]) # mixed string and numeric values
>>> s
0      8
1      6
2    7.5
3      3
4    0.9
dtype: object

>>> pd.to_numeric(s) # convert everything to float values
0    8.0
1    6.0
2    7.5
3    3.0
4    0.9
dtype: float64

Source: stackoverflow.com

Python: transform as type numeirc

df['myvar'] = df['myvar'].astype(str)   # Transform as character
df['myvar'] = df['myvar'].astype(float) # Transform as float
df['myvar'] = df['myvar'].astype(int)   # Transform as numeric

Source: stackoverflow.com

Similar codes

4 votes142 views1 answer
Unique values in dataframe column count
Python
-1 vote88 views1 answer
Numpy make 2d array 1d
Python
12 votes103 views2 answers
Read excel file spyder
Python
0 vote101 views2 answers
Python list to string with spaces
Python
12 votes92 views4 answers
Pandas replace values based on condition
Python
0 vote103 views1 answer
Python selenium not returning correct source
Python
8 votes98 views3 answers
Python datetime to unix timestamp
Python
1 vote96 views1 answer
Sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.
Python
3 votes90 views1 answer
Python csv write add new line
Python
0 vote107 views1 answer
Sikuli guide text
Python