Sourpuss: Like feeding pickles to a cat(1)

Sourpuss displays the contents of one or more Python pickle files on standard output. Currently, this small utility targets pickled Pandas DataFrames and supports transforming them in simple ways. Other pickled objects (e.g. dicts, NumPy arrays, etc.) are coerced into DataFrames. By making it easy to answer simple questions via Unix pipelines, sourpuss lets you avoid constantly context switching between $SHELL and Jupyter/IPython.

Help:

Usage: sourpuss [OPTIONS] [FILE]...

  Cat Python pickle file(s) onto standard output, especially DataFrames.

Options:
  -a, --append-index TEXT  Append named column to the index.
  -c, --csv                Emit CSV instead of formatted table.
  -l, --location           Prefix each row with the location of the file
  -m, --multi-sparse       Sparsify any MultiIndex display.
  -n, --no-index           Do not display the index.
  -p, --precision DIGITS   Change precision for floating point.  [default: 17]
  -q, --query QUERY        Show only rows satisfying a query.
  -r, --reset-index TEXT   Remove named column from the index.
  -s, --sort-index         Sort according to the index.
  -t, --types              Show the type, not the value, of each datum.
  --help                   Show this message and exit.

Examples:

$ sourpuss data_frame.pkl
            name              city  phone-number        date
Katherine Rivera              Pavo  540-489-5084  1973-01-18
   Katie Estrada            Antler  992-454-3547  2003-07-07
    Scott Harris        Colesville  665-552-3378  1989-01-01
  Anthony Flores         Round Oak  437-057-2113  1975-01-27
   Deborah Clark  Balcones Heights  871-803-9642  1978-02-07
    Andrea Owens            Lucile  308-267-6029  2018-01-05
  Kimberly Myers       Holly Ridge  906-150-0581  2002-02-26
Katherine Garner       Dalton City  687-950-3807  1984-06-16
 Brianna Preston           Bernice  489-937-8732  1970-11-28
   Justin Herman  Milleville Beach  847-845-5160  1984-11-10


$ sourpuss data_frame.pkl -q 'city == "Pavo"'
            name  city  phone-number        date
Katherine Rivera  Pavo  540-489-5084  1973-01-18


$ sourpuss data_frame.pkl -a city -a name -s | head -5
                                   phone-number        date
city             name
Antler           Katie Estrada     992-454-3547  2003-07-07
Balcones Heights Deborah Clark     871-803-9642  1978-02-07
Bernice          Brianna Preston   489-937-8732  1970-11-28

$ sourpuss numpy_array.pkl -a 1 -s -p 6
                  0         2         3         4
1
-0.686618 -0.309380 -0.787130  0.794882 -2.045493
-0.579552  0.338158 -0.269337  1.290424 -0.872747
-0.014240  0.333677  0.235846 -0.614426  0.222267
 0.317477  0.407887 -0.289088 -0.231201  0.046131
 1.307109 -0.383681  0.009120 -0.978323  0.446737

RhysU/sourpuss

Sourpuss: Like feeding pickles to a cat(1)