Convert a pandas column to int

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

Set column datatype pandas

df = pd.read_csv("weather.tsv", sep="\t",  
                 dtype={'Day': str,'Wind':int64})
df.dtypes

Source: cmdlinetips.com

Convert a pandas column to int

# convert Series
my_series = pd.to_numeric(my_series)

# convert column "a" of a DataFrame
df["a"] = pd.to_numeric(df["a"])

Source: stackoverflow.com

Similar codes

2 votes409 views1 answer
How to get element from dictionary python
Python
0 vote344 views1 answer
Python remove all isntances from a list
Python
0 vote389 views1 answer
Listing of django model types
Python Django
12 votes333 views5 answers
Check if item exists in list python
Python
11 votes404 views5 answers
Change default python version mac
Python
28 votes348 views2 answers
Wintp python manage.py createsuperuser
Python
0 vote333 views1 answer
Python web app with redis github
Python
0 vote344 views1 answer
Make sns heatmap colorbar larger
Python
0 vote358 views1 answer
Open chrome in pyhton
Python
0 vote328 views1 answer
How to let someone select a folder in python
Python