Advertisement
AmirNabiev

Untitled

Nov 16th, 2019
491
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.35 KB | None | 0 0
  1. https://praktikum.yandex.ru/trainer/data-analyst/lesson/cd601912-2c45-429c-b9f1-3ef16fb07a31/task/63e2c3f3-fa64-4376-8221-e8b753264535/
  2. moscow_general = df[df['city'] == 'Moscow']
  3. spb_general = df[df['city'] == 'Saint-Petersburg']
  4. def genre_weekday(df, day, time1, time2):
  5. genre_list = df.loc[(df.loc['weekday'] == day) & (df['time'] > time1) & (df['time'] < time2)]
  6. genre_list_sorted = genre_list.groupby('genre_name')['genre_name'].count().sort_values(ascending = False).head(10) # в переменной genre_list_sorted сохраняются в порядке убывания
  7. # первые 10 значений Series, полученной подсчётом числа значений 'genre_name'
  8. # сгруппированной по столбцу 'genre_name' таблицы genre_list
  9. return genre_list_sorted
  10. genre_weekday(moscow_general, 'Monday', '07:00:00', '11:00:00')
  11.  
  12. ошибка:
  13. KeyError Traceback (most recent call last)
  14. /opt/conda/lib/python3.7/site-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance)
  15. 2896 try:
  16. -> 2897 return self._engine.get_loc(key)
  17. 2898 except KeyError:
  18.  
  19. pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()
  20.  
  21. pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()
  22.  
  23. pandas/_libs/index_class_helper.pxi in pandas._libs.index.Int64Engine._check_type()
  24.  
  25. KeyError: 'weekday'
  26.  
  27. During handling of the above exception, another exception occurred:
  28.  
  29. KeyError Traceback (most recent call last)
  30. <ipython-input-39-c72f8908eeff> in <module>
  31. ----> 1 genre_weekday(moscow_general, 'Monday', '07:00:00', '11:00:00')# <вызов функции для утра понедельника в Москве >
  32.  
  33. <ipython-input-38-e5cb073c083d> in genre_weekday(df, day, time1, time2)
  34. 1 def genre_weekday(df, day, time1, time2):
  35. ----> 2 genre_list = df.loc[(df.loc['weekday'] == day) & (df['time'] > time1) & (df['time'] < time2)]
  36. 3 genre_list_sorted = genre_list.groupby('genre_name')['genre_name'].count().sort_values(ascending = False).head(10) # в переменной genre_list_sorted сохраняются в порядке убывания
  37. 4 # первые 10 значений Series, полученной подсчётом числа значений 'genre_name'
  38. 5 # сгруппированной по столбцу 'genre_name' таблицы genre_list
  39.  
  40. /opt/conda/lib/python3.7/site-packages/pandas/core/indexing.py in __getitem__(self, key)
  41. 1422
  42. 1423 maybe_callable = com.apply_if_callable(key, self.obj)
  43. -> 1424 return self._getitem_axis(maybe_callable, axis=axis)
  44. 1425
  45. 1426 def _is_scalar_access(self, key: Tuple):
  46.  
  47. /opt/conda/lib/python3.7/site-packages/pandas/core/indexing.py in _getitem_axis(self, key, axis)
  48. 1848 # fall thru to straight lookup
  49. 1849 self._validate_key(key, axis)
  50. -> 1850 return self._get_label(key, axis=axis)
  51. 1851
  52. 1852
  53.  
  54. /opt/conda/lib/python3.7/site-packages/pandas/core/indexing.py in _get_label(self, label, axis)
  55. 158 raise IndexingError("no slices here, handle elsewhere")
  56. 159
  57. --> 160 return self.obj._xs(label, axis=axis)
  58. 161
  59. 162 def _get_loc(self, key: int, axis: int):
  60.  
  61. /opt/conda/lib/python3.7/site-packages/pandas/core/generic.py in xs(self, key, axis, level, drop_level)
  62. 3735 loc, new_index = self.index.get_loc_level(key, drop_level=drop_level)
  63. 3736 else:
  64. -> 3737 loc = self.index.get_loc(key)
  65. 3738
  66. 3739 if isinstance(loc, np.ndarray):
  67.  
  68. /opt/conda/lib/python3.7/site-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance)
  69. 2897 return self._engine.get_loc(key)
  70. 2898 except KeyError:
  71. -> 2899 return self._engine.get_loc(self._maybe_cast_indexer(key))
  72. 2900 indexer = self.get_indexer([key], method=method, tolerance=tolerance)
  73. 2901 if indexer.ndim > 1 or indexer.size > 1:
  74.  
  75. pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()
  76.  
  77. pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc()
  78.  
  79. pandas/_libs/index_class_helper.pxi in pandas._libs.index.Int64Engine._check_type()
  80.  
  81. KeyError: 'weekday'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement