Filtering by condition in Python dataset -


i'm struggling sorting operation of stata file in phyton3: asked keep households without kids out of dataset/table:

i used filtering condition filter these rows out of table:

filtering_condition = df["kids"] > 0  df_nokids = df.loc[filtering_condition,"kids"]

this, however, gives me unknown error:

keyerror                                  traceback (most recent call last) /opt/anaconda/anaconda3/lib/python3.5/site-packages/pandas/indexes/base.py in get_loc(self, key, method, tolerance) 1944             try: -> 1945                 return self._engine.get_loc(key)    1946             except keyerror:  pandas/index.pyx in pandas.index.indexengine.get_loc (pandas/index.c:4154)()  pandas/index.pyx in pandas.index.indexengine.get_loc (pandas/index.c:4018)()  pandas/hashtable.pyx in pandas.hashtable.pyobjecthashtable.get_item (pandas/hashtable.c:12368)()  pandas/hashtable.pyx in pandas.hashtable.pyobjecthashtable.get_item     (pandas/hashtable.c:12322)()  keyerror: 'kids'  during handling of above exception, exception occurred:  keyerror                                  traceback (most recent call last) <ipython-input-321-e72cd8a67065> in <module>()       1 #keep households without kids , use dataset   rest of assignment ----> 2 filtering_condition = df["kids"] > 0       3 df_nokids = df.loc[filtering_condition,"kids"]  /opt/anaconda/anaconda3/lib/python3.5/site-packages/pandas/core/frame.py in  __getitem__(self, key)    1995             return self._getitem_multilevel(key)    1996         else: -> 1997             return self._getitem_column(key)    1998     1999     def _getitem_column(self, key):  /opt/anaconda/anaconda3/lib/python3.5/site-packages/pandas/core/frame.py in  _getitem_column(self, key)    2002         # column    2003         if self.columns.is_unique: -> 2004             return self._get_item_cache(key)    2005     2006         # duplicate columns & possible reduce dimensionality  /opt/anaconda/anaconda3/lib/python3.5/site-packages/pandas/core/generic.py    in _get_item_cache(self, item)    1348         res = cache.get(item)    1349         if res none: -> 1350             values = self._data.get(item)    1351             res = self._box_item_values(item, values)    1352             cache[item] = res  /opt/anaconda/anaconda3/lib/python3.5/site-packages/pandas/core/internals.py     in get(self, item, fastpath)    3288     3289             if not isnull(item): -> 3290                 loc = self.items.get_loc(item)    3291             else:    3292                 indexer = np.arange(len(self.items))   [isnull(self.items)]   /opt/anaconda/anaconda3/lib/python3.5/site-packages/pandas/indexes/base.py    in get_loc(self, key, method, tolerance)    1945                 return self._engine.get_loc(key)    1946             except keyerror: -> 1947                 return     self._engine.get_loc(self._maybe_cast_indexer(key))    1948     1949         indexer = self.get_indexer([key], method=method,    tolerance=tolerance)  pandas/index.pyx in pandas.index.indexengine.get_loc (pandas/index.c:4154)()  pandas/index.pyx in pandas.index.indexengine.get_loc (pandas/index.c:4018)()  pandas/hashtable.pyx in pandas.hashtable.pyobjecthashtable.get_item (pandas/hashtable.c:12368)()  pandas/hashtable.pyx in pandas.hashtable.pyobjecthashtable.get_item (pandas/hashtable.c:12322)()  keyerror: 'kids'

any explanations of doing wrong?

thanks!

datafile: enter image description here

do mean this:

df_kids = df[df['kids']>0]

this selects rows 'kids' column not zero.


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more