/Python/Convert column to numeric pandas

Convert column to numeric pandas

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

Column dataframe to int

df[[column_name]].astype(int)

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

Pandas decimal places

# (1) Round to specific decimal places – Single DataFrame column
df['DataFrame column'].round(decimals=number of decimal places needed)

# (2) Round up – Single DataFrame column
df['DataFrame column'].apply(np.ceil)

# (3) Round down – Single DataFrame column
df['DataFrame column'].apply(np.floor)

# (4) Round to specific decimals places – Entire DataFrame
df.round(decimals=number of decimal places needed)

Source: datatofish.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

1 vote254 views1 answer
Convert integer to datetime in python
Python
1 vote177 views1 answer
Cannot import name 'abc' from 'bson.py3compat'
Python
0 vote202 views1 answer
Day 19: interfaces hackerrank solution in python
Python
12 votes195 views2 answers
Python input integer only
Python
0 vote236 views1 answer
Networkx path between two nodes
Python
10 votes195 views3 answers
Add picture to jupyter notebook
Python
17 votes190 views3 answers
Change column names with number pd dataframe
Python
0 vote196 views1 answer
Time a line of code python
Python
0 vote210 views1 answer
Print greeting in python explication
Python
1 vote221 views1 answer
Discord.py message user
Python