LOG INGET STARTED

Master Data Analysis with Python

In this course, you will be introduced to the DataFrame and the Series, the two primary containers of data within pandas. You will learn the components of these objects and a few basic operations and also know what subset selection methods you should

Sep, 2022
10h
Intermediate
Data Science
1.4K Students

Overview

In this course, you will be introduced to the DataFrame and the Series, the two primary containers of data within pandas. You will learn the components of these objects and a few basic operations and also know what methods of subset selection you should avoid.   You will begin performing calculations on your data. You will begin by learning how to operate on a single column of data, a pandas Series and learn the difference between methods that aggregate (return a single value) and those that do not. After learning how to operate on a single column of data, you'll learn how to operate on multiple columns at the same time by calling methods on a DataFrame. You'll learn how to change the direction of the operations from vertical to horizontal.  You'll also learn about the categorical data type, which is unique to pandas and has the ability to save a tremendous amount of memory. Up to this point in the course, all operations were applied to the entire dataset. You will learn how to apply operations to independent groups within your data instead of the whole. You will also learn how to display the results of grouping in a more human-readable way with pivot tables.  Grouping data can be tricky in pandas and potentially be one of the slowest performing operations. You will learn best practices on how to optimize performance along with the newest syntax available. 

Skills you'll gain

Data AnalysisData SciencePandasPandas DataFramePython

What you'll learn

  • Introduction to the pandas DataFrame and Series 
  • Understanding the different data types available within a DataFrame 
  • Accessing the DataFrame components – the index, columns, and values 
  • Setting a meaningful index in a DataFrame 
  • Completing a five-step process for data exploration 
  • Learn how to select rows and columns simultaneously 
  • Learn how to filter for specific criteria using the boolean selection 
  • Learn a more intuitive procedure for filtering data with the query method 
  • Select subsets of data from DataFrames with just the brackets, loc, and iloc 

Who Should Attend

Prerequisites

  • Anyone, who wants to learn about fundamental concepts of programming. 
  • Anyone, who wants to learn python programming language. 
  • Anyone, who wants to brush up on their programming and python skills. 
  • It is necessary to understand the fundamentals of the Python programming language.  
  • No prior experience with pandas is needed. 

Chapters

Explore a structured set of chapters designed to build your skills step by step, with practical examples and hands-on applications.

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Resources

Module 1.1 - What is Pandas?

Segment 1 - What is Pandas

Segment 2 - Which Version of Pandas to Use

Segment 3 - Pandas Examples

Module 1.2 - The DataFrame and Series

Segment 4 - Introduction to the DataFrame and Series

Segment 5 - DataFrame Components

Segment 6 - Selecting a Series

Segment 7 - Components of a Series

Segment 8 - Getting Help in a Jupyter Notebook

Segment 9 - Exercises

Modules 1.3 - Data Types and Missing Values

Segment 10 - Introduction to Data Types and Missing Values

Segment 11 - Finding the Data Type of Each Column

Segment 12 - Getting More Metadata

Segment 13 - Exercises

Module 1.4 - Setting a Meaningful Index

Segment 14 - Setting an Index of a DataFrame

Segment 15 - Accessing the Index, Columns, and Data

Segment 16 - Accessing the Components of a Series

Segment 17 - The Default Index

Segment 18 - Setting an Index on Read

Segment 19 - Choosing a Good Index

Segment 20 - Exercises

Module 1.5 - Five-Step Process for Data Exploration

Segment 21 - Five-Step Process for Data Exploration

Meet your instructors

Theodore Petrou

Theodore Petrou

View my channel

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.