Learn how to use the powerful Python pandas library to analyze and manipulate data.
What you will learn
Perform a multitude of data operations in Python’s popular pandas library including grouping, pivoting, joining and more!
Group, aggregate and summarise your data.
Learn everything there is to know about pandas – from absolute scratch!
Gain a deep and hands-on understanding of pandas data structures.
Practice reading data from the web, pickles, Excel files right within pandas.
Description
This course is designed for individuals with little or no experience with the Pandas library for Python. Pandas is a powerful and flexible open-source data analysis and manipulation tool that is widely used in data science and data analysis. This course will provide a comprehensive introduction to the library, starting with basic concepts and gradually building up to more advanced topics.
The course will begin by introducing the basics of Pandas, including its data structures (Series and DataFrames) and the various ways to import and export data. You will learn how to perform basic data cleaning and preprocessing tasks, including handling missing values, renaming columns, and filtering and sorting data. You will also learn how to use Pandas to perform basic statistical operations and data visualization.
As the course progresses, you will dive deeper into more advanced topics, such as merging and joining data, groupby operations, and advanced indexing techniques. You will also learn how to use Pandas to work with time series data, including how to handle and manipulate date and time data.
Throughout the course, you will work with real-world data sets, giving you hands-on experience with the tools and techniques covered. You will also complete a number of practical exercises and projects, allowing you to apply what you’ve learned to real-world problems.
By the end of this course, you will have a solid understanding of the Pandas library and be able to use it confidently to perform data analysis and manipulation tasks. Whether you’re a beginner looking to start a career in data science or an experienced data analyst looking to improve your skills, this course is the perfect starting point.
Prerequisites: This course is designed for absolute beginners, and it will be helpful if you have basic knowledge of Python programming.
Course Outline:
- Introduction to Pandas
- Pandas Dataframes and Series
- Indexes in Pandas
- Conditional Filtering in Pandas
- Update Rows and Columns in Pandas
- Add/Remove Columns of Data
- Master Data Sorting in Pandas
- Clean & Save DataFrames
By the end of this course, you will be able to:
- Understand the basics of the Pandas library and its data structures
- Import and export data using Pandas
- Perform basic data cleaning and preprocessing tasks
- Use Pandas to perform basic statistical operations and data visualization
- Merge and join data using Pandas
- Use the groupby function in Pandas
- Apply advanced indexing techniques in Pandas
- Work with time series data using Pandas
- Apply your knowledge to real-world projects
Content