KeyError Traceback (most recent call last)
Cell In[1], line 42
39 lunch_df = df[df[‘食材’].isin(lunch)]
40 dinner_df = df[df[‘食材’].isin(dinner)]
—> 42 breakfast_summary = breakfast_df[[‘食材’, ‘维生素B1’, ‘维生素B2’, ‘维生素B6’, ‘维生素B12’]].sum()
43 lunch_summary = lunch_df[[‘食材’, ‘维生素B1’, ‘维生素B2’, ‘维生素B6’, ‘维生素B12’]].sum()
44 dinner_summary = dinner_df[[‘食材’, ‘维生素B1’, ‘维生素B2’, ‘维生素B6’, ‘维生素B12’]].sum()
File /usr/local/lib/python3.10/site-packages/pandas/core/frame.py:4108, in DataFrame.getitem(self, key)
4106 if is_iterator(key):
4107 key = list(key)
-> 4108 indexer = self.columns._get_indexer_strict(key, “columns”)[1]
4110 # take() does not accept boolean indexers
4111 if getattr(indexer, “dtype”, None) == bool:
File /usr/local/lib/python3.10/site-packages/pandas/core/indexes/base.py:6200, in Index._get_indexer_strict(self, key, axis_name)
6197 else:
6198 keyarr, indexer, new_indexer = self._reindex_non_unique(keyarr)
-> 6200 self._raise_if_missing(keyarr, indexer, axis_name)
6202 keyarr = self.take(indexer)
6203 if isinstance(key, Index):
6204 # GH 42790 - Preserve name from an Index
File /usr/local/lib/python3.10/site-packages/pandas/core/indexes/base.py:6252, in Index._raise_if_missing(self, key, indexer, axis_name)
6249 raise KeyError(f"None of [{key}] are in the [{axis_name}]“)
6251 not_found = list(ensure_index(key)issing_mask.nonzero()[0]].unique())
-> 6252 raise KeyError(f”{not_found} not in index")
KeyError: “[‘维生素B1’, ‘维生素B2’, ‘维生素B6’, ‘维生素B12’] not in index”