An error pops when running exec(code) in line 18.
ValueError Traceback (most recent call last)
Cell In[18], line 1
----> 1 exec(code)
File :37
File /usr/local/lib/python3.11/site-packages/pandas/io/parsers/readers.py:1026, in read_csv(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, date_format, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, encoding_errors, dialect, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options, dtype_backend)
1013 kwds_defaults = _refine_defaults_read(
1014 dialect,
1015 delimiter,
(…)
1022 dtype_backend=dtype_backend,
1023 )
1024 kwds.update(kwds_defaults)
→ 1026 return _read(filepath_or_buffer, kwds)
File /usr/local/lib/python3.11/site-packages/pandas/io/parsers/readers.py:620, in _read(filepath_or_buffer, kwds)
617 _validate_names(kwds.get(“names”, None))
619 # Create the parser.
→ 620 parser = TextFileReader(filepath_or_buffer, **kwds)
622 if chunksize or iterator:
623 return parser
File /usr/local/lib/python3.11/site-packages/pandas/io/parsers/readers.py:1620, in TextFileReader._init_(self, f, engine, **kwds)
1617 self.options[“has_index_names”] = kwds[“has_index_names”]
1619 self.handles: IOHandles | None = None
→ 1620 self._engine = self._make_engine(f, self.engine)
File /usr/local/lib/python3.11/site-packages/pandas/io/parsers/readers.py:1898, in TextFileReader._make_engine(self, f, engine)
1895 raise ValueError(msg)
1897 try:
→ 1898 return mapping[engine](f, **self.options)
1899 except Exception:
1900 if self.handles is not None:
File /usr/local/lib/python3.11/site-packages/pandas/io/parsers/c_parser_wrapper.py:161, in CParserWrapper._init_(self, src, **kwds)
155 self._validate_usecols_names(
156 usecols,
157 self.names, # type: ignore[has-type]
158 )
160 # error: Cannot determine type of ‘names’
→ 161 self._validate_parse_dates_presence(self.names) # type: ignore[has-type]
162 self._set_noconvert_columns()
164 # error: Cannot determine type of ‘names’
File /usr/local/lib/python3.11/site-packages/pandas/io/parsers/base_parser.py:243, in ParserBase._validate_parse_dates_presence(self, columns)
233 missing_cols = ", “.join(
234 sorted(
235 {
(…)
240 )
241 )
242 if missing_cols:
→ 243 raise ValueError(
244 f"Missing column provided to ‘parse_dates’: ‘{missing_cols}’”
245 )
246 # Convert positions to actual column names
247 return [
248 col if (isinstance(col, str) or col in columns) else columns[col]
249 for col in cols_needed
250 ]
ValueError: Missing column provided to ‘parse_dates’: ‘Sold_Date’
