“TypeError: string indices must be integers” when getting data of a stock from Yahoo Finance using Pandas Datareader

by

None of the solutions reported here so far worked for me. As per the discussion here Yahoo made changes to their API that broke compatibility with previous pandas datareader versions.

In the same Github thread a fix is reported, implemented in a pull request from Github user raphi6. I confirmed the pull request works fine. The version from the pull request can be installed with this 3 lines:

conda install pycryptodome pycryptodomex
conda uninstall pandas-datareader
pip install git+https://github.com/raphi6/pandas-datareader.git@ea66d6b981554f9d0262038aef2106dda7138316

The pycrypto* packages are dependencies I have to install to make it work. Notice I am using the commit hash here instead of the branch name, because it is Yahoo!_Issue#952 and there is an issue with hash characters when using pip this way.

This can also be done using pip for all the commands instead of conda (see Update 1 below).

Update 1

To try this on Google Colab use (as shown here):

! pip install pycryptodome pycryptodomex
! pip uninstall --yes pandas-datareader
! pip install git+https://github.com/raphi6/pandas-datareader.git@ea66d6b981554f9d0262038aef2106dda7138316

Update 2 (27/12/2022)

Although past week I could not make it work, I have tried again, and I can confirm that the pdr_override() workaround mentioned below by Nikhil Mulley is working now (at least with yfinance 0.2.3 and pandas-datareader 0.10.0).

Original answer (works but more lines of code)

In the same Github thread a fix is reported, implemented in a pull request from Github user raphi6. I confirmed the pull request works fine. Detailed installation instructions for the pull request can be found here, copied below for the sake of completeness:

git clone https://github.com/raphi6/pandas-datareader.git
cd pandas-datareader
conda uninstall pandas-datareader
conda install pycryptodome pycryptodomex
git checkout 'Yahoo!_Issue#952'
python setup.py install --record installed_files.txt

The --record argument in the install command is to get a list of installed files, so that it is easy to uninstall in the future (following this SO thread). The pycrypto* files are dependencies I have to install to make it work.

More Related Contents:

  1. Downloading multiple stocks at once from Yahoo Finance
  2. Extract the data and modify an existing excel with openpyxl
  3. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  4. How to show a pandas dataframe into a existing flask html table?
  5. Static methods in Python?
  6. urllib and “SSL: CERTIFICATE_VERIFY_FAILED” Error
  7. Finding and replacing elements in a list
  8. How to truncate float values?
  9. Execution of Python code with -m option or not
  10. Python script to do something at the same time every day [duplicate]
  11. Pandas: How to easily share a sample dataframe using df.to_dict()?
  12. Purpose of calling function without brackets python
  13. How do I do exponentiation in python? [duplicate]
  14. Capture arbitrary path in Flask route
  15. Shifted colorbar matplotlib
  16. How to normalize a 2-dimensional numpy array in python less verbose?
  17. What does the random.sample() method in Python do?
  18. Changing plot scale by a factor in matplotlib
  19. Python Flask Render Text from Variable like render_template
  20. Max and Min date in pandas groupby
  21. Import module works in terminal but not in IDLE
  22. Module function vs staticmethod vs classmethod vs no decorators: Which idiom is more pythonic?
  23. matplotlib share x axis but don’t show x axis tick labels for both, just one
  24. how to turn on minor ticks only on y axis matplotlib
  25. Python and SQLite: insert into table
  26. Iterating through a string word by word
  27. What is right batch normalization function in Tensorflow?
  28. How can I turn a flat list into a 2D array in python?
  29. Sorting in pyqt tablewidget
  30. Dynamic choices WTForms Flask SelectField

Leave a Comment