Cleaning sheets with Pandas

pandas is a wonderful python module for data manipulation.

It can read eg. Excel data directly from clipboard!

1- open your spreadsheet and copy some cells;
2- run

#ipython
>>> import pandas as pd
>>> my_table = pd.read_clipboard()
>>> my_table.columns

3- enjoy ;)

Lascia un commento