Create and Alter DataFrame Indexes from Pluralsight

In this course, you'll dive into DataFrame indexing with pandas. Follow Abby, a marketing analyst, as she navigates her marketing dataset. You'll learn reindexing, .loc, .iloc, data filtering techniques, and more through interactive demos.

This course will focus on skills needed to clean data using pandas DataFrames in Python. You'll follow Abby the marketing analyst while she explores customer data as she gets ready for a marketing campaign for her company, MadeUp Inc.

In this course, Create and Alter DataFrame Indexes, you’ll gain the ability to reference data in a pandas DataFrame using indexes, which is useful when you're trying to access or filter data in a DataFrame for data exploration and cleansing.

First, you’ll explore pandas DataFrames and indexes.

Next, you’ll discover how to create and recreate indexes on DataFrames.

Then, you’ll see how to access rows of a DataFrame with different syntaxes.

Finally, you’ll learn how to filter DataFrames for rows that match or contain certain string values.

When you’re finished with this course, you’ll have the skills and knowledge of creating and altering DataFrame indexes needed to access and filter data in DataFrames for data exploration and cleansing.

What's inside

Syllabus

Course Overview

Create and Recreate Indexes on DataFrames

Access Rows in a DataFrame

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops core skills for data exploration and cleansing, which are highly relevant in industry

Suitable for beginners who want to build a strong foundation in pandas DataFrame indexing

Provides interactive demos for practical application of DataFrame indexing techniques

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Create and Alter DataFrame Indexes with these activities:

Review basic data manipulation concepts

Show steps

Refresh your knowledge of basic data manipulation concepts, ensuring you have a solid foundation for working with pandas DataFrames.

Browse courses on Data Manipulation

Show steps

Review a tutorial on basic data manipulation
Complete a quiz on data manipulation concepts

Review basic Python syntax

Show steps

Solidify your understanding of Python syntax, ensuring you have a strong foundation for working with pandas DataFrames.

Browse courses on Python Syntax

Show steps

Review a Python tutorial on basic syntax
Complete a quiz on Python syntax

Organize your course materials for easy reference

Show steps

Help you stay organized and find information quickly, maximizing your learning efficiency.

Show steps

Create a structured folder system
Categorize and name your files logically
Maintain a consistent file naming convention

Five other activities

Expand to see all activities and additional details

Show all eight activities

Create a cheat sheet of pandas DataFrame indexing methods

Show steps

Provide you with a quick reference guide for DataFrame indexing methods, enhancing your efficiency in data manipulation.

Show steps

List all the DataFrame indexing methods
Describe the purpose of each method

Join a study group for additional support

Show steps

Provide you with opportunities to discuss the course material, ask questions, and learn from others.

Show steps

Connect with classmates
Schedule regular study sessions

Practice subsetting DataFrames with multiple criteria

Show steps

Help you master complex DataFrame subsetting techniques, making your data analysis more precise and efficient.

Show steps

Review the pandas DataFrame tutorial on subsetting with multiple criteria
Complete the guided exercise on subsetting with multiple criteria
Apply the techniques to a real-world dataset

Complete exercises on creating and altering DataFrame indexes

Show steps

Reinforce your understanding of DataFrame indexing by practicing creating and altering indexes.

Show steps

Solve 10 practice exercises on creating DataFrame indexes
Complete 15 practice exercises on altering DataFrame indexes

Develop a data cleaning script using pandas DataFrame indexing

Show steps

Allow you to apply your DataFrame indexing skills to a practical data cleaning scenario, improving your ability to prepare data for analysis.

Browse courses on Data Cleaning

Show steps

Choose a real-world dataset with common data cleaning challenges
Apply DataFrame indexing methods to clean the data
Write a detailed report explaining your data cleaning process

Career center

Learners who complete Create and Alter DataFrame Indexes will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data analysts uncover valuable insights that can guide business decisions. Data analysts apply analytical techniques, statistical methods, and machine learning algorithms to large datasets. They turn raw data into actionable insights that can help businesses improve operations, increase efficiency, and make better decisions. This Create and Alter DataFrame Indexes course can help you learn data indexing and manipulation skills which are foundational to data analysis. If you wish to become a data analyst, this course may be useful.

See salaries and explore the career path for Data Analyst

Data Scientist

Data scientists build, maintain, and use data models to solve business problems. They collaborate with domain experts to understand the business need, collect and clean data, and develop models that can make predictions or provide insights. This course may be useful if you wish to build a foundation in data indexing and manipulation needed for data science.

See salaries and explore the career path for Data Scientist

Business Analyst

Business analysts combine technical skills with business knowledge to analyze data and provide insights that help businesses make better decisions. They work with stakeholders to understand the business need, collect and clean data, and develop recommendations based on their analysis. This course may be useful if you wish to gain the data indexing skills required to thrive as a business analyst.

See salaries and explore the career path for Business Analyst

Market Researcher

Market researchers collect, analyze, and interpret data about markets, consumer behavior, and industry trends. They use this information to help businesses make informed decisions about product development, marketing campaigns, and overall business strategy. This course can be useful for market researchers who wish to enhance their data indexing skills.

See salaries and explore the career path for Market Researcher

Financial Analyst

Financial analysts collect, analyze, and interpret financial data to make recommendations on investments. They use their knowledge of accounting, economics, and finance to evaluate companies and make investment decisions. This course may be useful for financial analysts who wish to gain the data indexing skills needed to succeed in their role.

See salaries and explore the career path for Financial Analyst

Software Engineer

Software engineers design, develop, and maintain software systems. They work with clients to understand the business need, design and implement software solutions, and test and debug software products. This course may be useful for software engineers who wish to gain the data indexing skills required for software development.

See salaries and explore the career path for Software Engineer

Product Manager

Product managers lead the development and launch of new products. They work with engineers, designers, and marketing teams to define product requirements, prioritize features, and track progress. This course may be useful for product managers who wish to build a foundation in data indexing and manipulation, which can be helpful for understanding customer needs and tracking product usage.

See salaries and explore the career path for Product Manager

Operations Research Analyst

Operations research analysts use mathematical and analytical techniques to solve business problems. They work with businesses to improve efficiency, productivity, and profitability. This course may be useful for operations research analysts who wish to learn data indexing skills which can be useful for data analysis and modeling.

See salaries and explore the career path for Operations Research Analyst

Statistician

Statisticians collect, analyze, and interpret data to provide insights into complex issues. They use statistical methods to design experiments, analyze data, and draw conclusions. This course can be useful for statisticians who wish to gain the data indexing skills needed for data analysis and modeling.

See salaries and explore the career path for Statistician

Actuary

Actuaries use mathematical and statistical techniques to assess risk and uncertainty. They work with insurance companies, pension funds, and other financial institutions to develop and manage risk management strategies. This course may be useful for actuaries who wish to gain the data indexing skills needed for data analysis and modeling.

See salaries and explore the career path for Actuary

Data Engineer

Data engineers design, build, and maintain data systems. They work with data scientists and other stakeholders to understand the data needs of the organization and develop solutions to meet those needs. This course may be useful for data engineers who wish to gain the data indexing skills needed for data management.

See salaries and explore the career path for Data Engineer

Database Administrator

Database administrators manage and maintain databases. They work with database users to understand their needs and ensure that the database is running smoothly and efficiently. This course may be useful for database administrators who wish to gain the data indexing skills needed for database management.

See salaries and explore the career path for Database Administrator

Quantitative Analyst

Quantitative analysts use mathematical and statistical techniques to analyze financial data. They work with investment banks, hedge funds, and other financial institutions to develop and manage investment strategies. This course may be useful for quantitative analysts who wish to gain the data indexing skills needed for data analysis and modeling.

See salaries and explore the career path for Quantitative Analyst

Risk Analyst

Risk analysts assess and manage risk for organizations. They work with businesses to identify, assess, and mitigate risks that could impact the organization's financial performance or reputation. This course may be useful for risk analysts who wish to gain the data indexing skills needed for data analysis and modeling.

See salaries and explore the career path for Risk Analyst

Data Visualization Analyst

Data visualization analysts create visual representations of data to communicate insights and trends. They work with data scientists and other stakeholders to develop visualizations that are clear, concise, and actionable. This course may be useful for data visualization analysts who wish to gain the data indexing skills needed for data analysis and visualization.

See salaries and explore the career path for Data Visualization Analyst