How to solve SettingWithCopyWarning when using the ‘inplace’ parameter in pandas

  • by
  • 2 min read

The SettingWithCopyWarning message is a confusing warning to many who are new to Pandas. If you’ve ever taken a computer science course, you might be aware of passing/copying by value or by reference. Well, it very much applies to pandas DataFrames too. Let’s go. Basically, when you are slicing a… 

Solve “Loading data may take a while” when using IMPORTDATA in Google Spreadsheets

  • by
  • 2 min read

It’s no surprise that I’m a huge fan of GDrive (and basically all of Google’s products). Google Spreadsheets might not be as powerful as Excel, it’s definitely becoming the Swiss-army-knife par excellence for many digital natives. In this blog post how you can import huge amounts of data in a… 

How to: pandas – drop column

  • by
  • 3 min read

There are many ways to remove a column in a pandas DataFrame. However, some ways are better than others. In this blog post, I elaborate on multiple solutions and what the pros and cons are. First, let’s load the iris dataset from the Seaborn package on GitHub. Drop a pandas…