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]} -- https://mail.python.org/mailman/listinfo/python-list