Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +==============================================+==================================================================+
- | Spreadsheet feature | Spreadsheet feature |
- +==============================================+==================================================================+
- | worksheet | Pandas data frame |
- +----------------------------------------------+------------------------------------------------------------------+
- | File --> Import --> CSV | PixieDust sampleData |
- +----------------------------------------------+------------------------------------------------------------------+
- | cell B:2 | df.price[0] |
- +----------------------------------------------+------------------------------------------------------------------+
- | Formula =COUNTA(A:A) | df.count() |
- +----------------------------------------------+------------------------------------------------------------------+
- | Formula =AVERAGE(B1:B20000) | df['price'].mean() |
- +----------------------------------------------+------------------------------------------------------------------+
- | Using formulae to create new derived columns | apply a Python function |
- +----------------------------------------------+------------------------------------------------------------------+
- | Pivot tables | Combine groupby, aggregate and sort_values. See also reset_index |
- +----------------------------------------------+------------------------------------------------------------------+
- | Charts | Pixiedust display |
- +----------------------------------------------+------------------------------------------------------------------+
Add Comment
Please, Sign In to add comment