Python access to WRDS Data
Project description
WRDS-Py is a library for extracting data from WRDS data sources and getting it into Pandas. The library allows users to access data from WRDS and extract data using SQL statements. The data that is returned is read into a Pandas data frame.
Installation
Mac OS/Linux
$ python setup.py install
Windows
The WRDS-PY package requires Pandas and Psycopg2. Binaries of these can be found here: http://www.lfd.uci.edu/~gohlke/pythonlibs/#psycopg
Once the two required packages are installed, you can run $ python setup.py install
For more information please consult the WRDS Support section at https://wrds-web.wharton.upenn.edu/wrds/support/.
Usage
>>> import wrds
>>> db = wrds.Connection()
Enter your credentials.
Username: <your_username>
Password: <your_password>
>>> db.list_libraries()
['audit', 'bank', 'block', 'bvd', 'bvdtrial', 'cboe', ...]
>>> db.list_tables(library='crsp')
['aco_amda', 'aco_imda', 'aco_indfnta', 'aco_indfntq', ...]
>>> db.describe_table(library='crsp', table='stocknames')
Approximately 58957 rows in crsp.stocknames.
name nullable type
0 permno True DOUBLE PRECISION
1 permco True DOUBLE PRECISION
2 namedt True DATE
...
>>> stocknames = db.get_table(library='crsp', table='stocknames', obs=10) >>> stocknames.head() permno permco namedt nameenddt cusip ncusip ticker \ 0 10000.0 7952.0 1986-01-07 1987-06-11 68391610 68391610 OMFGA 1 10001.0 7953.0 1986-01-09 1993-11-21 36720410 39040610 GFGC 2 10001.0 7953.0 1993-11-22 2008-02-04 36720410 29274A10 EWST 3 10001.0 7953.0 2008-02-05 2009-08-03 36720410 29274A20 EWST 4 10001.0 7953.0 2009-08-04 2009-12-17 36720410 29269V10 EGAS ...
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file wrds-3.0.3.tar.gz.
File metadata
- Download URL: wrds-3.0.3.tar.gz
- Upload date:
- Size: 9.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 6a71ec4dbdc28f412b9d0dfd36e26626515a9740f85dbdd2d693f4ec158e52b7 |
|
| MD5 | e0ac18cfd829323ef020319aadc1928f |
|
| BLAKE2b-256 | e5cf32c6048d16567217ee9c3c4769ee57cc080bffefe8dca87d2d391c0a0ff5 |
File details
Details for the file wrds-3.0.3-py2.py3-none-any.whl.
File metadata
- Download URL: wrds-3.0.3-py2.py3-none-any.whl
- Upload date:
- Size: 11.6 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 520e48ef0d07f1f4c42937dec7d5c6ac00b776173031cd96e4fd2af8ee4d35ea |
|
| MD5 | 754d4ce40428ad9dd69d2c4497e9126b |
|
| BLAKE2b-256 | 1fb2709eaa7c27376fd74a98ac02d4857782892d883af86e90220a72a271c2de |
