cannot upgrade or install pip due to pyodbc version..

[Yoonho-Na]

I want to install some libraries using pip But I get warning from pyodbc.

WARNING: Error parsing dependencies of pyodbc: Invalid version: '4.0.0-unsupported'

I tried to reinstall pyodbc by pip uninstall pyodbc and pip install pyodbc but when I do pip uninstall pyodbc it says WARNING: Skipping pyodbc as it is not installed. but when I pip list it shows pyodbc 4.0.0-unsupported

and then I tried to upgrade pyodbc this error occured

pip install pyodbc
Defaulting to user installation because normal site-packages is not writeable
ERROR: Exception:
Traceback (most recent call last):
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/cli/base_command.py", line 105, in _run_wrapper
    status = _inner_run()
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/cli/base_command.py", line 96, in _inner_run
    return self.run(options, args)
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/cli/req_command.py", line 67, in wrapper
    return func(self, options, args)
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/commands/install.py", line 379, in run
    requirement_set = resolver.resolve(
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/resolution/resolvelib/resolver.py", line 95, in resolve
    result = self._result = resolver.resolve(
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_vendor/resolvelib/resolvers.py", line 546, in resolve
    state = resolution.resolve(requirements, max_rounds=max_rounds)
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_vendor/resolvelib/resolvers.py", line 397, in resolve
    self._add_to_criteria(self.state.criteria, r, parent=None)
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_vendor/resolvelib/resolvers.py", line 148, in _add_to_criteria
    matches = self._p.find_matches(
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/resolution/resolvelib/provider.py", line 232, in find_matches
    return self._factory.find_candidates(
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/resolution/resolvelib/factory.py", line 451, in find_candidates
    return self._iter_found_candidates(
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/resolution/resolvelib/factory.py", line 342, in _iter_found_candidates
    _get_installed_candidate(),
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/resolution/resolvelib/factory.py", line 288, in _get_installed_candidate
    if not specifier.contains(installed_dist.version, prereleases=True):
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_internal/metadata/pkg_resources.py", line 192, in version
    return parse_version(self._dist.version)
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_vendor/packaging/version.py", line 56, in parse
    return Version(version)
  File "/home/yh/.local/lib/python3.8/site-packages/pip/_vendor/packaging/version.py", line 202, in __init__
    raise InvalidVersion(f"Invalid version: '{version}'")
pip._vendor.packaging.version.InvalidVersion: Invalid version: '4.0.0-unsupported'

I also tried upgrading pip and It doesn't work too.

pip install --upgrade pip
Defaulting to user installation because normal site-packages is not writeable
Requirement already satisfied: pip in /home/yh/.local/lib/python3.8/site-packages (24.2)
WARNING: Error parsing dependencies of pyodbc: Invalid version: '4.0.0-unsupported'

I also have tried putting -U options in pip too. How can I fix this?