Portfolio

Data Cleaning Using Panda

Data cleaning is an essential step in the data analysis process, ensuring that your data is accurate, consistent, and reliable for analysis. Pandas, a popular Python library for data manipulation and analysis, provides powerful tools for data cleaning. Here’s an introduction to data cleaning in Pandas:

Import Pandas: Before you start cleaning your data, you need to import the Pandas library. You can do this using the following import statement.

Pandas provides various functions to load data from different file formats such as CSV, Excel, SQL databases, etc.

For example:

Removing Duplicates: Duplicates in the dataset can skew analysis results. Pandas provides the drop_duplicates() method to remove duplicate rows. For example:

Removing unnecessary columns like “not useful”

Cleaning up the “last name” column: removing forward slashes, dots etc.

Standardizing phone numbers by removing various formats and NaNs

Handling Address data by splitting it into separate columns for better readability

Standardizing values in the “paying customer” and “Do Not Contact ” column to “Y” and “N”

Remove All NAN and fill it with blank

Remove rows who don’t want to be contacted.

Also Remove the Rows Where we don’t have any phone number

Reset Index

Note :– “In the end, our data cleaning project has made a big difference. We turned messy data into clear, useful information. By paying attention to details and being careful, we’ve made sure our data is reliable. As we finish up, remember: keeping data clean isn’t just important—it’s the key to understanding and making good decisions.“