2.6 reindex 관련 예제 질문

아래의 에러가 발생했을 때 어떻게 진행해야 할지 모르겠습니다.

df1과 df2의 실행이 안됩니다.

---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
File ~\anaconda3\Lib\site-packages\pandas\core\computation\scope.py:198, in Scope.resolve(self, key, is_local)
    197 if self.has_resolvers:
--> 198     return self.resolvers[key]
    200 # if we're here that means that we have no locals and we also have
    201 # no resolvers

File ~\anaconda3\Lib\collections\__init__.py:1004, in ChainMap.__getitem__(self, key)
   1003         pass
-> 1004 return self.__missing__(key)

File ~\anaconda3\Lib\collections\__init__.py:996, in ChainMap.__missing__(self, key)
    995 def __missing__(self, key):
--> 996     raise KeyError(key)

KeyError: 'Timestamp'

During handling of the above exception, another exception occurred:

KeyError                                  Traceback (most recent call last)
File ~\anaconda3\Lib\site-packages\pandas\core\computation\scope.py:209, in Scope.resolve(self, key, is_local)
    205 try:
    206     # last ditch effort we look in temporaries
    207     # these are created when parsing indexing expressions
    208     # e.g., df[df > 0]
--> 209     return self.temps[key]
    210 except KeyError as err:

KeyError: 'Timestamp'

The above exception was the direct cause of the following exception:

UndefinedVariableError                    Traceback (most recent call last)
File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:666, in BaseExprVisitor.visit_Call(self, node, side, **kwargs)
    665 try:
--> 666     res = self.visit(node.func)
    667 except UndefinedVariableError:
    668     # Check if this is a supported function name

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:415, in BaseExprVisitor.visit(self, node, **kwargs)
    414 visitor = getattr(self, method)
--> 415 return visitor(node, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:549, in BaseExprVisitor.visit_Name(self, node, **kwargs)
    548 def visit_Name(self, node, **kwargs):
--> 549     return self.term_type(node.id, self.env, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\ops.py:85, in Term.__init__(self, name, env, side, encoding)
     84 self.is_local = tname.startswith(LOCAL_TAG) or tname in DEFAULT_GLOBALS
---> 85 self._value = self._resolve_name()
     86 self.encoding = encoding

File ~\anaconda3\Lib\site-packages\pandas\core\computation\ops.py:109, in Term._resolve_name(self)
    107     is_local = False
--> 109 res = self.env.resolve(local_name, is_local=is_local)
    110 self.update(res)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\scope.py:211, in Scope.resolve(self, key, is_local)
    210 except KeyError as err:
--> 211     raise UndefinedVariableError(key, is_local) from err

UndefinedVariableError: name 'Timestamp' is not defined

During handling of the above exception, another exception occurred:

ValueError                                Traceback (most recent call last)
Cell In[2], line 2
      1 # 삼성전자
----> 2 df1 = fdr.DataReader("005930", '2018-01-02', '2018-10-30')
      4 # KODEX 200 (ETF)
      5 df2 = fdr.DataReader("069500", '2018-01-03', '2018-10-30')

File ~\anaconda3\Lib\site-packages\FinanceDataReader\data.py:19, in DataReader(symbol, start, end, exchange, kind)
     16 start, end = _validate_dates(start, end)
     17 if (symbol.isdigit() and len(symbol)==6 and exchange==None) or \
     18    (symbol.isdigit() and exchange and exchange.upper() in ['KRX', '한국거래소']):
---> 19     return NaverDailyReader(symbol, start, end, exchange, kind).read()
     21 if (symbol.isdigit() and exchange and exchange.upper() in ['KRX-DELISTING']):
     22     return KrxDelistingReader(symbol, start, end, exchange, kind).read()

File ~\anaconda3\Lib\site-packages\FinanceDataReader\naver\data.py:29, in NaverDailyReader.read(self)
     26 df.sort_index(inplace=True)
     27 df['Change'] = df['Close'].pct_change()
---> 29 return df.query('index>=%r and index<=%r' % (self.start, self.end))

File ~\anaconda3\Lib\site-packages\pandas\util\_decorators.py:331, in deprecate_nonkeyword_arguments.<locals>.decorate.<locals>.wrapper(*args, **kwargs)
    325 if len(args) > num_allow_args:
    326     warnings.warn(
    327         msg.format(arguments=_format_argument_list(allow_args)),
    328         FutureWarning,
    329         stacklevel=find_stack_level(),
    330     )
--> 331 return func(*args, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\frame.py:4474, in DataFrame.query(self, expr, inplace, **kwargs)
   4472 kwargs["level"] = kwargs.pop("level", 0) + 2
   4473 kwargs["target"] = None
-> 4474 res = self.eval(expr, **kwargs)
   4476 try:
   4477     result = self.loc[res]

File ~\anaconda3\Lib\site-packages\pandas\util\_decorators.py:331, in deprecate_nonkeyword_arguments.<locals>.decorate.<locals>.wrapper(*args, **kwargs)
    325 if len(args) > num_allow_args:
    326     warnings.warn(
    327         msg.format(arguments=_format_argument_list(allow_args)),
    328         FutureWarning,
    329         stacklevel=find_stack_level(),
    330     )
--> 331 return func(*args, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\frame.py:4612, in DataFrame.eval(self, expr, inplace, **kwargs)
   4609     kwargs["target"] = self
   4610 kwargs["resolvers"] = tuple(kwargs.get("resolvers", ())) + resolvers
-> 4612 return _eval(expr, inplace=inplace, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\eval.py:353, in eval(expr, parser, engine, truediv, local_dict, global_dict, resolvers, level, target, inplace)
    344 # get our (possibly passed-in) scope
    345 env = ensure_scope(
    346     level + 1,
    347     global_dict=global_dict,
   (...)
    350     target=target,
    351 )
--> 353 parsed_expr = Expr(expr, engine=engine, parser=parser, env=env)
    355 # construct the engine and evaluate the parsed expression
    356 eng = ENGINES[engine]

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:813, in Expr.__init__(self, expr, engine, parser, env, level)
    811 self.parser = parser
    812 self._visitor = PARSERS[parser](self.env, self.engine, self.parser)
--> 813 self.terms = self.parse()

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:832, in Expr.parse(self)
    828 def parse(self):
    829     """
    830     Parse an expression.
    831     """
--> 832     return self._visitor.visit(self.expr)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:415, in BaseExprVisitor.visit(self, node, **kwargs)
    413 method = "visit_" + type(node).__name__
    414 visitor = getattr(self, method)
--> 415 return visitor(node, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:421, in BaseExprVisitor.visit_Module(self, node, **kwargs)
    419     raise SyntaxError("only a single expression is allowed")
    420 expr = node.body[0]
--> 421 return self.visit(expr, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:415, in BaseExprVisitor.visit(self, node, **kwargs)
    413 method = "visit_" + type(node).__name__
    414 visitor = getattr(self, method)
--> 415 return visitor(node, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:424, in BaseExprVisitor.visit_Expr(self, node, **kwargs)
    423 def visit_Expr(self, node, **kwargs):
--> 424     return self.visit(node.value, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:415, in BaseExprVisitor.visit(self, node, **kwargs)
    413 method = "visit_" + type(node).__name__
    414 visitor = getattr(self, method)
--> 415 return visitor(node, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:750, in BaseExprVisitor.visit_BoolOp(self, node, **kwargs)
    747     return self._maybe_evaluate_binop(op, node.op, lhs, rhs)
    749 operands = node.values
--> 750 return reduce(visitor, operands)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:743, in BaseExprVisitor.visit_BoolOp.<locals>.visitor(x, y)
    742 def visitor(x, y):
--> 743     lhs = self._try_visit_binop(x)
    744     rhs = self._try_visit_binop(y)
    746     op, op_class, lhs, rhs = self._maybe_transform_eq_ne(node, lhs, rhs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:739, in BaseExprVisitor._try_visit_binop(self, bop)
    737 if isinstance(bop, (Op, Term)):
    738     return bop
--> 739 return self.visit(bop)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:415, in BaseExprVisitor.visit(self, node, **kwargs)
    413 method = "visit_" + type(node).__name__
    414 visitor = getattr(self, method)
--> 415 return visitor(node, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:723, in BaseExprVisitor.visit_Compare(self, node, **kwargs)
    721     op = self.translate_In(ops[0])
    722     binop = ast.BinOp(op=op, left=node.left, right=comps[0])
--> 723     return self.visit(binop)
    725 # recursive case: we have a chained comparison, a CMP b CMP c, etc.
    726 left = node.left

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:415, in BaseExprVisitor.visit(self, node, **kwargs)
    413 method = "visit_" + type(node).__name__
    414 visitor = getattr(self, method)
--> 415 return visitor(node, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:536, in BaseExprVisitor.visit_BinOp(self, node, **kwargs)
    535 def visit_BinOp(self, node, **kwargs):
--> 536     op, op_class, left, right = self._maybe_transform_eq_ne(node)
    537     left, right = self._maybe_downcast_constants(left, right)
    538     return self._maybe_evaluate_binop(op, op_class, left, right)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:458, in BaseExprVisitor._maybe_transform_eq_ne(self, node, left, right)
    456     left = self.visit(node.left, side="left")
    457 if right is None:
--> 458     right = self.visit(node.right, side="right")
    459 op, op_class, left, right = self._rewrite_membership_op(node, left, right)
    460 return op, op_class, left, right

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:415, in BaseExprVisitor.visit(self, node, **kwargs)
    413 method = "visit_" + type(node).__name__
    414 visitor = getattr(self, method)
--> 415 return visitor(node, **kwargs)

File ~\anaconda3\Lib\site-packages\pandas\core\computation\expr.py:670, in BaseExprVisitor.visit_Call(self, node, side, **kwargs)
    667 except UndefinedVariableError:
    668     # Check if this is a supported function name
    669     try:
--> 670         res = FuncNode(node.func.id)
    671     except ValueError:
    672         # Raise original error
    673         raise

File ~\anaconda3\Lib\site-packages\pandas\core\computation\ops.py:614, in FuncNode.__init__(self, name)
    612 def __init__(self, name: str) -> None:
    613     if name not in MATHOPS:
--> 614         raise ValueError(f'"{name}" is not a supported function')
    615     self.name = name
    616     self.func = getattr(np, name)

ValueError: "Timestamp" is not a supported function