Convert string in pandas dataframe to integer

Question

I have a data frame with a column for number of reviews the dataframe column is listed in this format

816 ratings
1,139 ratings
5 ratings
22,3456 ratings

Id like to convert this to an integer so I can sort the dataframe. My output should be

I tried

df=df['num_reviews'].str.extract('(\d+)').astype(float)
df

however this converted everything after the comma into a decimal. (i.e. 22,3456 returns 22.0) and using .astype(int) gave me errors due to fields having NaN

when i use that i get this following error "cannot convert float NaN to integer" your code worked however if i use float so thank you! I just need to be able to sort — Shay Agarwal
– Shay Agarwal, Commented Nov 2, 2020 at 22:57

mujjiga · Accepted Answer · 2020-11-02 23:11:51Z

1

df['num_reviews'].str.replace(r'\D+', '').replace('','0').astype(float)

Test case:

df = pd.DataFrame({
    'num_reviews': ["816 ratings", "1,139 ratings", 
                    "5 ratings", "no ratings", "22,3456 ratings"]
})
print (df['num_reviews'].str.replace(r'\D+', '').replace('','0').astype(float))

Output:

0       816.0
1      1139.0
2         5.0
3         0.0
4    223456.0

answered Nov 2, 2020 at 23:11

mujjiga

17.1k2 gold badges37 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert string in pandas dataframe to integer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related