Namedtuples problem

Thu Feb 23 10:19:00 EST 2017

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]}