Error in reading

[vineetk1984]

Description

What steps will reproduce the problem?

import pandas as pd

file_path = 'C:\Users\neyni\Alphavantage_ohlc_intraday.xlsx'

Read the Excel file

excel_file = pd.ExcelFile(file_path)

Initialize an empty dictionary

new_ohlc_intraday = {}

Loop through each sheet in the Excel file and reconstruct the dictionary

for sheet_name in excel_file.sheet_names:
df = pd.read_excel(file_path, sheet_name=sheet_name, index_col=0) # index_col=0 if you want to preserve the index
new_ohlc_intraday[sheet_name] = df

Traceback

Traceback (most recent call last):
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\spyder\plugins\variableexplorer\widgets\collectionsdelegate.py", line 269, in createEditor
    if not editor.setup_and_check(value, title=key):
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\spyder\plugins\variableexplorer\widgets\dataframeeditor.py", line 1773, in setup_and_check
    return self.set_data_and_check(data)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\spyder\plugins\variableexplorer\widgets\dataframeeditor.py", line 1882, in set_data_and_check
    self.dataModel = DataFrameModel(data, parent=self)
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\spyder\plugins\variableexplorer\widgets\dataframeeditor.py", line 227, in __init__
    self.max_min_col_update()
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\spyder\plugins\variableexplorer\widgets\dataframeeditor.py", line 349, in max_min_col_update
    vmax = col.max(skipna=True)
           ^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\series.py", line 6517, in max
    return NDFrame.max(self, axis, skipna, numeric_only, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\generic.py", line 12404, in max
    return self._stat_function(
           ^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\generic.py", line 12377, in _stat_function
    return self._reduce(
           ^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\series.py", line 6457, in _reduce
    return op(delegate, skipna=skipna, **kwds)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\nanops.py", line 147, in f
    result = alt(values, axis=axis, skipna=skipna, **kwds)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\nanops.py", line 404, in new_func
    result = func(values, axis=axis, skipna=skipna, mask=mask, **kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\nanops.py", line 1095, in reduction
    values, mask = _get_values(
                   ^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\nanops.py", line 294, in _get_values
    mask = _maybe_get_mask(values, skipna, mask)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\nanops.py", line 248, in _maybe_get_mask
    mask = isna(values)
           ^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\dtypes\missing.py", line 178, in isna
    return _isna(obj)
           ^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\dtypes\missing.py", line 207, in _isna
    return _isna_array(obj, inf_as_na=inf_as_na)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\pandas\core\dtypes\missing.py", line 288, in _isna_array
    elif isinstance(values, np.rec.recarray):
                            ^^^^^^
  File "C:\Users\neyni\miniconda3\envs\jupyter_env\Lib\site-packages\numpy\__init__.py", line 364, in __getattr__
    if not abs(x.dot(x) - float32(2.0)) < 1e-5:
    ^^^^^^^^^^^^^^^^^^^^^^^
ModuleNotFoundError: No module named 'numpy.rec'

Versions

• Spyder version: 6.0.1 (conda)
• Python version: 3.12.3 64-bit
• Qt version: 5.15.2
• PyQt5 version: 5.15.10
• Operating System: Windows-11-10.0.22631-SP0

Dependencies

# Mandatory:
aiohttp >=3.9.3                      :  3.11.10 (OK)
asyncssh >=2.14.0,<3.0.0             :  2.17.0 (OK)
atomicwrites >=1.2.0                 :  1.4.0 (OK)
chardet >=2.0.0                      :  4.0.0 (OK)
cloudpickle >=0.5.0                  :  3.0.0 (OK)
cookiecutter >=1.6.0                 :  2.6.0 (OK)
diff_match_patch >=20181111          :  20200713 (OK)
github >=2.3.0                       :  2.4.0 (OK)
importlib_metadata >=4.6.0           :  8.5.0 (OK)
intervaltree >=3.0.2                 :  3.1.0 (OK)
IPython >=8.13.0,<9.0.0,!=8.17.1     :  8.30.0 (OK)
jedi >=0.17.2,<0.20.0                :  0.19.2 (OK)
jellyfish >=0.7                      :  1.1.3 (OK)
jsonschema >=3.2.0                   :  4.23.0 (OK)
keyring >=17.0.0                     :  24.3.1 (OK)
nbconvert >=4.0                      :  7.16.4 (OK)
numpydoc >=0.6.0                     :  1.7.0 (OK)
parso >=0.7.0,<0.9.0                 :  0.8.4 (OK)
pexpect >=4.4.0                      :  4.8.0 (OK)
pickleshare >=0.4                    :  0.7.5 (OK)
psutil >=5.3                         :  5.9.0 (OK)
pygments >=2.0                       :  2.18.0 (OK)
pylint >=3.1,<4                      :  3.3.3 (OK)
pylint_venv >=3.0.2                  :  3.0.3 (OK)
pyls_spyder >=0.4.0                  :  0.4.0 (OK)
pylsp >=1.12.0,<1.13.0               :  1.12.0 (OK)
pylsp_black >=2.0.0,<3.0.0           :  2.0.0 (OK)
pyuca >=1.2                          :  1.2 (OK)
qdarkstyle >=3.2.0,<3.3.0            :  3.2.3 (OK)
qstylizer >=0.2.2                    :  0.2.2 (OK)
qtawesome >=1.3.1,<1.4.0             :  1.3.1 (OK)
qtconsole >=5.6.0,<5.7.0             :  5.6.0 (OK)
qtpy >=2.4.0                         :  2.4.1 (OK)
rtree >=0.9.7                        :  1.0.1 (OK)
setuptools >=49.6.0                  :  75.1.0 (OK)
sphinx >=0.6.6                       :  7.3.7 (OK)
spyder_kernels >=3.0.0,<3.1.0        :  3.0.0 (OK)
superqt >=0.6.2,<1.0.0               :  0.6.7 (OK)
textdistance >=4.2.0                 :  4.6.2 (OK)
three_merge >=0.1.1                  :  0.1.1 (OK)
watchdog >=0.10.3                    :  4.0.1 (OK)
yarl >=1.9.4                         :  1.18.0 (OK)
zmq >=24.0.0                         :  25.1.2 (OK)

# Optional:
cython >=0.21                        :  None (NOK)
matplotlib >=3.0.0                   :  3.9.2 (OK)
numpy >=1.7                          :  2.0.1 (OK)
pandas >=1.1.1                       :  2.2.2 (OK)
scipy >=0.17.0                       :  1.14.1 (OK)
sympy >=0.7.3                        :  None (NOK)

# Spyder plugins:
spyder_notebook.notebookplugin 0.6.1 :  0.6.1 (OK)

[ccordoba12]

Hey @vineetk1984, thanks for reporting. It seems there's a mismatch between your Pandas and Numpy versions, or perhaps you installed one of them with pip, which broke it.

So, I'd recommend you to update Pandas and Numpy with conda, or recreate your environment, and try again.

Let us know if that solves the problem for you.