Skip to main content

Package for Quandl API access

Project description

Quandl API for Python
=====================
Basic wrapper to return datasets from the Quandl website as Pandas dataframe objects with a timeseries index, or as a numpy array. This allows interactive manipulation of the results via IPython or storage of the datasets using Pandas I/O functions. You will need a familarity with [pandas](http://pandas.pydata.org/) to get the most out of this.

See the [Quandl API](http://www.quandl.com/api) for more information.


Usage
=====
Usage is simple and mirrors the functionality found at [Quandl/API](http://www.quandl.com/api).

A request with a full list of options would be the following.

```python
data = Quandl.get('PRAGUESE/PX', authtoken='xxxxxx', trim_start='2001-01-01',
trim_end='2010-01-01', collapse='annual',
transformation='rdiff', rows=4, returns='numpy')
```

All options beyond specifying the dataset (PRAUGESE/PX) are optional,though it is helpful to specify an authtoken at
least once to increase download limits.

You can then view the dataframe with `data.head()`.

See the [pandas documentation](http://pandas.pydata.org/) for a wealth of options on data manipulation.

Authtokens are saved as pickled files in the local directory so it is unnecessary to enter them more than once,
unless you change your working directory. To replace simply save the new token or delete the `authtoken.p` file.


## Search Example
Using the search function you can search Quandl, specifying what sources to search, and what page you wish to show.

Quandl.search(query = "Search terms", source = "Source you wish to search", page = 1)

An example of searching for datasets having to do with oil:

python
import Quandl
datasets = Quandl.search('OIL')
datasets[0]


will output:

{u'code': u'NSE/OIL',
u'colname': [u'Date',
u'Open',
u'High',
u'Low',
u'Last',
u'Close',
u'Total Trade Quantity',
u'Turnover (Lacs)'],
u'desc': u'Historical prices for Oil India Limited (OIL), (ISIN: INE274J01014), National Stock Exchange of India.',
u'freq': u'daily',
u'name': u'Oil India Limited'}


## Get Example
An example of creating a pandas time series for IBM stock data, with a weekly frequency:

```python
data = Quandl.get('GOOG/NYSE_IBM', collapse='weekly')
data.head()
```

will output

```
No authentication tokens found,usage will be limited
Returning Dataframe for GOOG/NYSE_IBM

Open High Low Close Volume
Date
2013-03-28 209.83 213.44 209.74 213.30 3752999
2013-03-15 215.38 215.90 213.41 214.92 7937244
2013-03-08 209.85 210.74 209.43 210.38 3700986
2013-03-01 200.65 202.94 199.36 202.91 3309434
2013-02-22 199.23 201.09 198.84 201.09 3107976
```


### Multisets

Quandl's [multisets](http://www.quandl.com/help/multisets) allows you to create a collection of data, from any column of any dataset on Quandl, and download it as one dataset.

If you wanted to compare the closing prices for Apple and Microsoft, you would obtain the two Quandl codes:

`GOOG/NASDAQ_AAPL`

`GOOG/NASDAQ_MSFT`

Append the column you wish to get with a `.`, and put them into an array.

`['GOOG/NASDAQ_AAPL.4','GOOG/NASDAQ_MSFT.4']`

Just make a normal get call with the array passed to get, and your multiset will be returned.

`data= Quandl.get(['GOOG/NASDAQ_AAPL.4','GOOG/NASDAQ_MSFT.4'])`

Which outputs:

```
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']

GOOG.NASDAQ_AAPL - Close GOOG.NASDAQ_MSFT - Close
Date
1997-08-20 6.16 17.57
1997-08-21 6.00 17.23
1997-08-22 5.91 17.16
1997-08-25 5.77 17.06
1997-08-26 5.56 16.88

```


## Push Example
You can now upload your own data to Quandl through the Python package.

At this time the only accepted format is a date indexed Pandas DataSeries.

Things to do before you upload:

* Make an account and set your authentication token within the package with the Quandl.auth() function.
* Get your data into a data frame with the dates in the first column.
* Pick a code for your dataset - only capital letters, numbers and underscores are acceptable.

Then call the following to push the data:

```python
Quandl.push(data, code='TEST', name='Test', desc='test')
```

All parameters but desc are necessary

If you wish to override the existing set at code `TEST` add `override=True`.

Uploading a pandas DataSeries with random data:

```python
import pandas
import numpy

index = ['Dec 12 2296', 'Dec 21 1998', 'Oct 9 2000', 'Oct 19 2001',
'Oct 30 2003', 'Nov 12 2003']
data = pandas.DataFrame(numpy.random.randn(6, 3), index=index,
columns=['D', 'B', 'C'])
print Quandl.push(data, code='F32C', name='Test', desc='test',
authtoken='xxxxxx')
```

Will print the link to your newly uploaded data.


Recommended Usage
================
The IPython notebook is an excellent python environment for interactive data work. Spyder is also a superb IDE for analysis and more numerical work.

I would suggest downloading the data in raw format in the highest frequency possible and preforming any data manipulation
in pandas itself.

See [this link](http://pandas.pydata.org/pandas-docs/dev/timeseries.html) for more information about timeseries in pandas.


Questions/Comments
==================
Please send any questions, comments, or any other inquires about this package to <Chris@quandl.com>.


Installation
============
The stable version of Quandl can be installed with pip:

pip install Quandl


Dependencies
============
Pandas :: <https://code.google.com/p/pandas/>

dateutil (should be installed as part of pandas) :: <http://labix.org/python-dateutil>


License
=======
[MIT License](http://opensource.org/licenses/MIT)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

Quandl-2.8.7.tar.gz (8.9 kB view details)

Uploaded Source

Built Distribution

Quandl-2.8.7.macosx-10.10-intel.exe (77.7 kB view details)

Uploaded Source

File details

Details for the file Quandl-2.8.7.tar.gz.

File metadata

  • Download URL: Quandl-2.8.7.tar.gz
  • Upload date:
  • Size: 8.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for Quandl-2.8.7.tar.gz
Algorithm Hash digest
SHA256 e9be4f10575ea3b10a492b2d13ee0314e256000e851a81fdcdc05a62257e098f
MD5 96aaf61547318a1fcbbfa8bfc0db5c2a
BLAKE2b-256 0ea29401dc9ab0de9e6470fe9336c39f85c1250a375cd23b11f5dec448b1d3b1

See more details on using hashes here.

File details

Details for the file Quandl-2.8.7.macosx-10.10-intel.exe.

File metadata

File hashes

Hashes for Quandl-2.8.7.macosx-10.10-intel.exe
Algorithm Hash digest
SHA256 f1c2907e45b973c4d370e94c1e8752c4e8ba201f953ad3d883664c10e11026bb
MD5 3e1b0b04fafc494e08159f2e113b2c9f
BLAKE2b-256 9d806381ec7d7cad9196f54b72699596a20d916fa846a2b0fe93074cd653ba93

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page