Up to date remote data access for pandas
Up to date remote data access for pandas: https://pandas-datareader.readthedocs.io/en/latest/
Questions tagged [pandas-datareader]
368 questions
57
votes
6 answers
import pandas_datareader gives ImportError: cannot import name 'is_list_like'
I am working in a virtual environment. I am able to import and work in pandas without any error but when I am trying to import pandas_datareader
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import datetime as dt
from…
Raj
- 922
- 1
- 7
- 12
40
votes
5 answers
How to show a pandas dataframe into a existing flask html table?
This may sound a noob question, but I'm stuck with it as Python is not one of my best languages.
I have a html page with a table inside it, and I would like to show a pandas dataframe in it.
What is the best way to do it? Use…
Motta
- 405
- 1
- 5
- 10
19
votes
12 answers
No module named pandas_datareader
I have just installed pandas_datareader using pip install pandas-datareader which ran successfully.
Now I am trying to use it for a tutorial and I am getting this error when I try to import.
import pandas_datareader as pdr
ModuleNotFoundError:…
Goulouh Anwar
- 627
- 1
- 9
- 20
13
votes
4 answers
Downloading mutliple stocks at once from yahoo finance python
I have a question about the function of yahoo finance using the pandas data reader. I'm using for months now a list with stock tickers and execute it in the following lines:
import pandas_datareader as pdr
import datetime
stocks =…
ScharcoMolten
- 133
- 1
- 1
- 5
13
votes
5 answers
How to import a mysqldump into Pandas
I am interested if there is a simple way to import a mysqldump into Pandas.
I have a few small (~110MB) tables and I would like to have them as DataFrames.
I would like to avoid having to put the data back into a database since that would require…
Keith
- 4,117
- 5
- 40
- 62
10
votes
4 answers
How can I download stock price data with Python?
I have installed pandas-datareader but I'm wondering if there are alternatives.
So far, I'm using this:
import pandas_datareader.data as web
start_date = '2018-01-01'
end_date = '2018-06-08'
panel_data = web.DataReader('SPY', 'yahoo', start_date,…
user8270077
- 3,589
- 5
- 41
- 90
10
votes
2 answers
ImportError: cannot import name 'PandasError'
I am very new to Python 3x, running on a mac.
Currently using a sentdex tutorial for python with finance, tried running the following script:
import datetime as dt
import matplotlib.pyplot as plt
from matplotlib import style
import pandas as…
Tobias Nilsson
- 121
- 1
- 1
- 3
9
votes
1 answer
Zipline: using pandas-datareader to feed in Google Finance dataframe for non-US based financial markets
PLEASE NOTE: This question was successfully answered ptrj below. I have also written a blog post on my blog about my experiences with zipline which you can find here: https://financialzipline.wordpress.com
I'm based in South Africa and I'm trying…
Simon
- 18,312
- 22
- 130
- 197
8
votes
2 answers
How to fix "ImportError: cannot import name 'StringIO'"
python version is 3.6.6 and pandas_datareader version is 0.7.0
when i import pandas_datareader, an error occurs like below.
C:\PycharmProjects\Demo\venv\Scripts\python.exe C:/PycharmProjects/Demo/stock.py
Traceback (most recent call last):
File…
김장환
- 81
- 1
- 1
- 3
6
votes
2 answers
Error in reading stock data : 'DatetimeProperties' object has no attribute 'weekday_name' and 'NoneType' object has no attribute 'to_csv'
I tried running the code to get stock data but it fails, showing the following error:
'DatetimeProperties' object has no attribute 'weekday_name'
'NoneType' object has no attribute 'to_csv'
from pandas_datareader import data as web
import…
sirishp
- 81
- 1
- 1
- 3
6
votes
1 answer
Why pandas.read_sql returns an empty DataFrame?
I'm trying to retrieve the data from database and save into pandas.DataFrame.
Here is my Python script,
conn = pyodbc.connect(sql_server)
query = '''SELECT a1, a2, a3
FROM ''' + dbschema + '''.SomeResults
WHERE FactorName = \' ''' + FactorName +…
Pandaaaaaaa
- 237
- 3
- 6
6
votes
4 answers
Yahoo Finance API / URL not working: Python fix for Pandas DataReader
Yahoo Finance URL has not been accessible using the Pandas DataReader's "yahoo" method since 16 May 2017. I have yet to test this fix-yahoo-finance: https://pypi.python.org/pypi/fix-yahoo-finance that was posted just yesterday, with the statement:…
artDeco
- 350
- 2
- 6
- 20
4
votes
3 answers
pandas_datareader, ImportError: cannot import name 'urlencode'
I am working fine with pandas_datareader, then today I installed below both yahoo finance from the below link trying to solve another issue.
No data fetched Web.DataReader Panda
pip install yfinance
pip install fix_yahoo_finance
After the above…
roudan
- 632
- 1
- 6
- 18
4
votes
1 answer
Getting market data from different markets with yahoo and pandas_datareader in python
So I have a bit of an issue with redundant tag names between markets. For example when using the following code to get data:
from pandas_datareader import data as pdr
from datetime import datetime
data = pdr.get_data_yahoo(['AC'],…
kpie
- 7,934
- 5
- 19
- 40
4
votes
1 answer
How do i fix this RemoteDataError, in Pandas DataReader
i want to download FTSE historical data but i cant download it, i have reinstalled pandas_datareader but the problem still persisted
there are no issues downloading other tickers such as S&P, Dow Jones ,etc only FTSE
this is the following code i…
Yash
- 41
- 2