Namedtuples problem

[Peter Otten]

Pavol Lisy wrote:

> If we are talking about less code than necessary then probably we
> could use something from python's ecosystem...
> 
>>>> import pandas as pd  # really useful package

Yes, pandas looks like the perfect fit here.

There is a learning curve, though, so that it will probably pay off only 
after the second project ;) 

For example here's what my session might have looked like:

>>> df = pd.read_csv("what_location.csv")
>>> df
  what    location
0  foo        here
1  foo       there
2  bar  eberywhere

[3 rows x 2 columns]
>>> df.groupby("what")
<pandas.core.groupby.DataFrameGroupBy object at 0x7f52a71f3e48>
>>> print(df.groupby("what"))
<pandas.core.groupby.DataFrameGroupBy object at 0x7f52a71f3f60>
>>> df.groupby("what")["foo"]
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python3/dist-packages/pandas/core/groupby.py", line 2477, 
in __getitem__
    raise KeyError(str(key))
KeyError: 'foo'
>>> df.groupby("what").keys()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
TypeError: 'str' object is not callable
>>> df.groupby("what").keys
'what'

Frustrating.

PS:
>>> g.groups
{'foo': [0, 1], 'bar': [2]}