- Pandas - Install Python and Pandas
- Basic Data Structures in Pandas
- Loading and Saving Data using Pandas
- Exploring Data using pandas
- Correlation Analysis using pandas
- Handling Categorical Data and Unique Values using pandas
- Data Visualization using pandas
- Handling Missing Data in Python
- Strategies for Handling Missing Data
- Handling Missing Data - Example - Part 1
- Handling Missing Data - Example - Part 2
- Handling Missing Data - Example - Part 3 (Non-numeric Values)
- Handling Missing Data - Example - Part 4
- Data Transformation and Feature Engineering
- Converting Data Types in Python pandas
- Encoding Categorical Data in Python pandas
- Handling Date and Time Data in Python pandas
- Renaming Columns in Python pandas
- Filtering Rows in a DataFrame in Python
- Merging and Joining Datasets in Python pandas
- Sorting and Indexing Data for Efficient Analysis in Python

# Handling Missing Data - Example - Part 1

In the previous lesson, we learned about various strategies to handle missing data. Let’s now work through our example to handle missing values. Here’s our missing data report:

Let’s work through each column containing missing data.

**Loan Amount**

This is a numerical field and an important one. We can delete all rows which have a loan amount missing. Alternatively, the missing values can be filled with either the mean or median of the existing loan amounts. The choice between mean and median depends on whether the data is skewed or not. If there are outliers (very high or very low loan amounts), median is a better choice as it is less affected by outliers. Below we show how you can delete rows with missing values or fill the missing values using Median. You can continue with either approach in your analysis.

```
# Remove rows where 'LoanAmount' is missing
loan_data_cleaned = loan_data.dropna(subset=['LoanAmount'])
# You can check the shape of the dataframe to confirm the rows were dropped
print(loan_data_cleaned.shape)
loan_data_cleaned
```

```
# Fill missing values with median
# Create a copy of the original DataFrame
loan_data_copy = loan_data.copy()
# Convert 'LoanAmount' to numeric in the copied DataFrame, non-numeric values will become NaN
loan_data_copy['LoanAmount'] = pd.to_numeric(loan_data_copy['LoanAmount'], errors='coerce')
# Calculate the median of the 'LoanAmount' column in the copied DataFrame
median_loan_amount = loan_data_copy['LoanAmount'].median()
# Fill missing values in 'LoanAmount' of the copied DataFrame with the calculated median
loan_data_copy['LoanAmount'].fillna(median_loan_amount, inplace=True)
# Optional: Check if there are any missing values left in 'LoanAmount' of the copied DataFrame
print(loan_data_copy['LoanAmount'].isnull().sum())
```

In the Jupyter notebook, we have only shown the first method, i.e., remove rows with missing LoanAmount values.

Similarly, let’s work with the other missing data also.

**Loan Duration Days:** Let’s fill it with the number of days between loan start date and loan end date.

**Loan Amount Category:** If the loan amount is 1000 and below, we will fill ‘Small’. If it is 2000 and below but more than 1000, its ‘Medium’. If it is above 2000, it is ‘Large’.

**Total Loans By Customer:** Let’s fill it with median.

**Customer Loyalty:** There are only two categories: Returning, or New. If a user has only 1 loan, fill New. If it has more than 1 loan, fill ‘Returning’.

#### Related Downloads

## Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.