My Pandas Cheat sheet

As an office worker I have several reports that the only thing you end up doing is vlookuping data from a bunch of files and merging a files and applying some logic to it.

I tried solving some if this file merging and reporting on Power bi, but for one formula when applied to a couple of line gave me a value that had the tables had no info, that made me change to python (pandas).

These are some code snips I look for.

libraries

import files

adding a column with an if

Pivot table

Vlookup or Merging into one table

Export to en excel file