Pandas in Python – Common pitfalls and tips


This is Jing, a data scientist with great passion for applying data science and big data technology in the industry. Today you are going to learn Pandas with me. I will talk about some common errors and good practice when you are processing data with python.

Here is a list of things we will cover today.

Common pitfalls and errors

  • Key Error
  • Index Error
  • Attribute Error

Best practices and tips

  • Get or set values quickly
  • Leftover DataFrames
  • Set data type for the columns in the dataset
  • Check and know your data before calculation

Before we look at each function, we need to create an example dataset so that you could understand the function better through the examples. And import the pandas library as pd which is a name we will use in the following code. Then follows explanation, examples and exercise of each function listed above.

Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.

Hope you find it is helpful for you to learn more about Pandas!

One thought on “Pandas in Python – Common pitfalls and tips

  1. I’m just getting into Data Analytics, and find that this entire blog is such a great resource! So thank you in advance for all your help 🙂


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s