Interactive Course

Writing Efficient Code with pandas

Learn efficient techniques in pandas to optimize your Python code.

  • 4 hours
  • 14 Videos
  • 45 Exercises
  • 6,341 Participants
  • 3,500 XP

Loved by learners at thousands of top companies:


Course Description

The ability to efficiently work with big datasets and extract valuable information is an indispensable tool for every aspiring data scientist. When working with a small amount of data, we often don’t realize how slow code execution can be. This course will build on your knowledge of Python and the pandas library and introduce you to efficient built-in pandas functions to perform tasks faster. Pandas’ built-in functions allow you to tackle the simplest tasks, like targeting specific entries and features from the data, to the most complex tasks, like applying functions on groups of entries, much faster than Python's usual methods. By the end of this course, you will be able to apply a function to data based on a feature value, iterate through big datasets rapidly, and manipulate data belonging to different groups efficiently. You will apply these methods on a variety of real-world datasets, such as poker hands or restaurant tips.

  1. 1

    Selecting columns and rows efficiently


    This chapter will give you an overview of why efficient code matters and selecting specific and random rows and columns efficiently.

  2. Replacing values in a DataFrame

    This chapter shows the usage of the replace() function for replacing one or multiple values using lists and dictionaries.

  3. Efficient iterating

    This chapter presents different ways of iterating through a Pandas DataFrame and why vectorization is the most efficient way to achieve it.

  4. Data manipulation using .groupby()

    This chapter describes the groupby() function and how we can use it to transform values in place, replace missing values and apply complex functions group-wise.

What do other learners have to say?


“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group


“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School


“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Leonidas Souliotis
Leonidas Souliotis

PhD @ University of Warwick

Leonidas Souliotis is a PhD student at the University of Warwick, UK. His research interests lie in the field of bioinformatics, machine learning, and deep learning. Before that, he completed his MSc in Statistics degree from Imperial College London, UK, and his BSc in Statistics and Insurance Science from the University of Piraeus. He has worked in different areas of applied statistics and machine learning, both inside and outside academia. This includes stock trading, epidemiology and biology.

See More
  • Hillary Green-Lerman

    Hillary Green-Lerman

  • Hadrien Lacroix

    Hadrien Lacroix

Icon Icon Icon professional info