Python Function: Convert Percentage Strings to Numbers

Easily convert percentage values stored as strings (e.g., “85%”) into numeric values for analysis in Python! 🚀

Why Use This Function? 🤔

• 📊 Data Cleaning: Many datasets store percentages as strings, which are not suitable for calculations.
• 🧹 Preprocessing: Converting these to numbers is essential for machine learning and data analysis.

Function Example 🐍

def str_to_rate(s):
    if pd.isnull(s) == False:
        return float(s.replace('%', ''))
    else:
        return s

How to Use 🛠️

col = "ReplyRate"
df[col] = df[col].apply(str_to_rate)

• 🔄 This will convert all percentage strings in the column to float numbers (e.g., “85%” → 85.0).
• ⚠️ Null values will remain unchanged.