/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 vote346 views1 answer
Flask send email gmail
Python
7 votes347 views3 answers
Python calendar
Python
0 vote329 views1 answer
Check version of package poetry
Python
18 votes356 views3 answers
Select specific rows from dataframe in python
Python
35 votes439 views6 answers
How to remove spaces in string in python
Python
0 vote356 views1 answer
Blender python add collection to scean collection
Python
2 votes346 views1 answer
Python pip graphviz
Python
82 votes319 views6 answers
Activate python venv in windows
Python
0 vote324 views1 answer
Python switch case 3.10 Structural Pattern Matching
Python
17 votes379 views5 answers
Random python range
Python