Python Quandl in Spyder

how to import quandl in jupyter
how to install quandl in anaconda
quandl in colab
how to download quandl in anaconda
quandl package
quandl get not working
quandl set start date
quandl login

Spyder is working wonderfully with numpy and pandas, but with Quandl I get the following error (in spyder):

        >>> import Quandl
        Traceback (most recent call last):
        File "<stdin>", line 1, in <module>
        ImportError: No module named Quandl

Yet from the terminal Quandl installed without issue:

    $ sudo easy_install quandl
    Password:
    Searching for quandl
    Reading http://pypi.python.org/simple/quandl/
    Best match: Quandl 1.8.1
    Downloading https://pypi.python.org/packages/source/Q/Quandl/Quandl-1.8.1.tar.gz#md5=f67bef937eb7522d70cf39ed0de740c1
    Processing Quandl-1.8.1.tar.gz
    Running Quandl-1.8.1/setup.py -q bdist_egg --dist-dir /tmp/easy_install-BEwINw/Quandl-1.8.1/egg-dist-tmp-aBuphk
    zip_safe flag not set; analyzing archive contents...
    Adding Quandl 1.8.1 to easy-install.pth file

    Installed /Library/Python/2.7/site-packages/Quandl-1.8.1-py2.7.egg
    Processing dependencies for quandl
    Finished processing dependencies for quandl

and I can also readily use the library from the terminal directly (in python2.7):

    $ python2.7
    Python 2.7.5 (default, Aug 25 2013, 00:04:04) 
    [GCC 4.2.1 Compatible Apple LLVM 5.0 (clang-500.0.68)] on darwin
    Type "help", "copyright", "credits" or "license" for more information.
    >>> import Quandl
    >>> data= Quandl.get(['GOOG/NASDAQ_AAPL.4','GOOG/NASDAQ_MSFT.4'])
    No authentication tokens found: usage will be limited.
    See www.quandl.com/api for more information.
    Returning Dataframe for  [u'GOOG.NASDAQ_AAPL.4', u'GOOG.NASDAQ_MSFT.4']
    >>> data
    <class 'pandas.core.frame.DataFrame'>
    DatetimeIndex: 8294 entries, 1981-03-11 00:00:00 to 2014-01-03 00:00:00
    Data columns (total 2 columns):
    GOOG.NASDAQ_AAPL - Close    8294  non-null values
    GOOG.NASDAQ_MSFT - Close    7027  non-null values
    dtypes: float64(2)

Any input on why spyder would not be working with Quandl?

Must have been someone who tried to climb this mountain before me.


Solution went undiscovered when looking through stackoverflow, but was pointed out to me by the google group:

answer here!

I initially wrote Quandl (capitalized) and got an error, as it seems you are doing. It works lowercase for me (import quandl).

The python code from the quandl homepage is wrong on this point:

Quandl.get("OFDP/FUTURE_VX6", trim_start="2004-05-19", trim_end="2014-10-16")

Because they use a capitalized Q.

How do I install the Quandl Python library?, License: MIT; Home: https://www.quandl.com/; Development: https://github.com/​quandl/quandl-python; Documentation: conda install -c anaconda quandl  I got this problem in Anaconda Python after downgrading from 3.5 to 3.4. I tried using both pip install quandl and conda install quandl (Anaconda-specific) as well as some other variants such as uninstalling and reinstalling. I the end I realized the old value Quandl was cached.

I got this problem in Anaconda Python after downgrading from 3.5 to 3.4.

I tried using both pip install quandl and conda install quandl (Anaconda-specific) as well as some other variants such as uninstalling and reinstalling.

I the end I realized the old value Quandl was cached. After removing the Anaconda/Lib/site-packages/Qandl folder entirely (after uninstalling) the pip install quandl worked as it should.

Hope this helps someone!

Quandl :: Anaconda Cloud, sudo easy_install quandl Password: Searching for quandl Reading http://pypi.​python.org/simple/quandl/ Best match: Quandl 1.8.1  Confirm python version Installing the Quandl Python Library. After installing python we’ll need to make the Quandl library available before trying to get some data. Recent versions of python (including the latest 2.7.15) come with a tool called pip that makes installation very simple.

Just use import quandl and NOT import Quandl and it'll work. I had the same problem. Best

Spyder not able to use installed python library, by: nilima, 4 years ago. Hello, I installed Quandl through pip install and also tried installing though setup.py. But I get the import error: "No module named request  PYTHON. Get millions of financial and economic datasets from hundreds of publishers directly into Python. Most datasets on Quandl, whether in time-series or tables format, are available from within Python, using the free Quandl Python package. The Quandl package uses our API and makes it amazingly easy to get financial data.

you could just use the CSV links and download manually using url

import urllib2
response = urllib2.urlopen('http://www.quandl.com/api/v1/datasets/OFDP/FUTURE_VX1.csv?&trim_start=2004-05-03&trim_end=2014-01-07&sort_order=desc')
html = response.read()

then parse appropriately

Quandl Installed but Import Error, First, you're going to need the quandl package. This isn't totally necessary, as pulling from the API is quite simple with or without the package, but it does make it  The Quandl Python module is free but you must have a Quandl API key in order to download data. To get your own API key, you will need to create a free Quandl account and set your API key. After importing the Quandl module, you can set your API key with the following command: quandl.ApiConfig.api_key = "YOURAPIKEY"

Using Quandl for more data, The package managers "pip" and "conda" allow users to install, update, or uninstall Python Duration: 5:17 Posted: Oct 17, 2016 Please see our Python documentation for installation instructions.

Install Python Packages with pip and conda, Robert Hardy then shows some data munging in Python: a brief look at installing the Anaconda Python distribution,; using Pandas to clean data from Quandl. Free to Use. The Quandl Python package is free to use and grants access to all free datasets. Users only pay to access Quandl’s premium data products.

Introduction to data science in R and Python – Full Stack Quants, import quandl output: ModuleNotFoundError Traceback (most recent call last) in (​) ----> 1 No module named 'quandl' i am using python jupyter. Ok so first got to the anaconda prompt type: install -c anaconda quandl, next  Spyder allows us to view the variables easily, and we can see that an array- like object has been generated, this is a Dataframe which is a non-standard Python datatype. It was included by default with Spyder, I cannot comment on other installations of Python.

Comments
  • Just a thought: Can you restart Spyder and check?
  • @NipunBatra - rebooted Spyder. still same issue unfortunately.
  • (Spyder dev here) Are you using our Mac native app? I mean the one you get from our dmg installer?
  • @CarlosCordoba i referenced your solution in my answer.
  • Great! Happy coding then :-)
  • Good on you for answering a 4 year old question