Ola, fiz o exercicio, a alternativa que vcs puseram como correta, esta dando erro aqui
dataset.loc[["Passat", "DS5"], ["Motor", "Valor"]]
---------------------------------------------------------------------------
KeyError Traceback (most recent call last)
<ipython-input-46-cec74f5dfd72> in <module>
----> 1 dataset.loc[["Passat", "DS5"], ["Motor", "Valor"]]
~\miniconda3\envs\python_fundamentos_dsa\lib\site-packages\pandas\core\indexing.py in __getitem__(self, key)
887 # AttributeError for IntervalTree get_value
888 return self.obj._get_value(*key, takeable=self._takeable)
--> 889 return self._getitem_tuple(key)
890 else:
891 # we by definition only have the 0th axis
~\miniconda3\envs\python_fundamentos_dsa\lib\site-packages\pandas\core\indexing.py in _getitem_tuple(self, tup)
1065 # ugly hack for GH #836
1066 if self._multi_take_opportunity(tup):
-> 1067 return self._multi_take(tup)
1068
1069 return self._getitem_tuple_same_dim(tup)
~\miniconda3\envs\python_fundamentos_dsa\lib\site-packages\pandas\core\indexing.py in _multi_take(self, tup)
1017 """
1018 # GH 836
-> 1019 d = {
1020 axis: self._get_listlike_indexer(key, axis)
1021 for (key, axis) in zip(tup, self.obj._AXIS_ORDERS)
~\miniconda3\envs\python_fundamentos_dsa\lib\site-packages\pandas\core\indexing.py in <dictcomp>(.0)
1018 # GH 836
1019 d = {
-> 1020 axis: self._get_listlike_indexer(key, axis)
1021 for (key, axis) in zip(tup, self.obj._AXIS_ORDERS)
1022 }
~\miniconda3\envs\python_fundamentos_dsa\lib\site-packages\pandas\core\indexing.py in _get_listlike_indexer(self, key, axis, raise_missing)
1264 keyarr, indexer, new_indexer = ax._reindex_non_unique(keyarr)
1265
-> 1266 self._validate_read_indexer(keyarr, indexer, axis, raise_missing=raise_missing)
1267 return keyarr, indexer
1268
~\miniconda3\envs\python_fundamentos_dsa\lib\site-packages\pandas\core\indexing.py in _validate_read_indexer(self, key, indexer, axis, raise_missing)
1306 if missing == len(indexer):
1307 axis_name = self.obj._get_axis_name(axis)
-> 1308 raise KeyError(f"None of [{key}] are in the [{axis_name}]")
1309
1310 ax = self.obj._get_axis(axis)
KeyError: "None of [Index(['Passat', 'DS5'], dtype='object')] are in the [index]"