Convert values within column to a specific type, despite column containing nulls

user_5942100 0
Viewed 35

Looking to convert values within column to a specific type, despite column containing nulls. The column I wish to convert is ['id'] and this contains a mix of values labeled as string as well as null values. I wish to convert all the values to int within this column.

Data:

    id  type    date
    1   yes     Q1
    1   yes     Q2
        maybe   Q3
        no      Q4
    5   no      Q1
    5   ok      Q2

Desired:

    id  type    date
    1   yes     Q1
    1   yes     Q2
        maybe   Q3
        no      Q4
    5   no      Q1
    5   ok      Q2

Doing:

df["id"] = df["id"].astype('int64')

However, because column id contains nulls, I am seeing an error.

I wish to convert all the values to int within this column.

pandas dataframe numpy python
1 Answers

Try this:

df = pd.DataFrame()
df["id"] = [1, "10", None, None, 5, 5]
df.id = df.id.astype(int, errors="ignore")
df.id

Print out:

0       1
1      10
2    None
3    None
4       5
5       5
user_71170030
Related