Pandas Cheat Sheet

If you are new to Pandas feel free to read Introduction to Pandas I’ve assembled some pandas code snippets Reading Data Reading CSV import pandas as pd # read from csv df = pd.read_csv(“path_to_file”) Can also be textfiles. file suffix is ignored

Excel Flash Fill

From time to time you have annoying things to do which you cannot avoid e.g. split names into surname and last name. Here comes the flash fill feature: Given you have the full names in column A Go to cell B1 and enter the last name Go to B2 Go to tab “Data” Click Flash…