Gain insights into data wrangling using Python. Learn about cleaning, transforming, and organizing data with libraries like NumPy, pandas, and scikit-learn for data science and machine learning projects.

pandas.tar.gz

Data Wrangling

Data wrangling is cleaning, transforming, and organizing data for further analysis. In this course, you will learn how to use Python to effectively wrangle and prepare data for use in data science and machine learning projects.

Throughout the course, you will learn about the common challenges that arise when working with data and how to overcome them. You will use Python and several libraries commonly used in data wrangling, including NumPy and pandas. Then, you will learn how to use pandas to clean, transform, and aggregate data. Moreover, you will also use scikit-learn, a library for machine learning, to identify outliers in our data.

By the end of the course, you will be able to use Python to effectively wrangle and prepare data for use in data science and machine learning projects. With these tools at your disposal, you can efficiently apply machine learning models and get realistic predictions after applying various wrangling techniques to the dataset.

Data Wrangling With Python

Sometimes we can store data inside other data sources, such as Excel files. We can also store this data online and access it through a URL.

To import such data, we use the `read_excel()` pandas function.





import pandas as pd
excel_df = pd.read_excel("https://github.com/CourseMaterial/DataWrangling/blob/main/housing.xlsx?raw=true")
print(excel_df.tail())

Learn to import an Excel dataset into a DataFrame.

About This Course

Introduction to Data Wrangling

Reading Data

Standardization

Syntax Errors and Irrelevant Data

Duplicate and Missing Data

Filtering and Sorting

Splitting, Combining, and Merging

Handling Outliers

Exporting Data

Humanitarian Aid Project

Conclusion

Loading an Excel Dataset into a DataFrame

Loading Excel files