/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

0 vote170 views1 answer
Ascii value of pi symbol in python
Python
2 votes175 views3 answers
Python list unique in order
Python
3 votes187 views2 answers
Convert mb to gb python
Python
0 vote233 views1 answer
Access kwargs in template django
Python Django
1 vote181 views1 answer
Create square matrix python
Python
10 votes179 views3 answers
Python import function from file
Python
39 votes197 views5 answers
Dataframe create
Python
73 votes178 views6 answers
Python round to two decimals
Python
1 vote169 views1 answer
Mypy ignore line
Python
0 vote195 views1 answer
Find where df series is null and print
Python