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 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='csrp', 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
wrds-3.0.tar.gz
(5.8 kB
view details)
File details
Details for the file wrds-3.0.tar.gz.
File metadata
- Download URL: wrds-3.0.tar.gz
- Upload date:
- Size: 5.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | e82aba369ba4802dbd05624eed7d11e1d45142e63aef59195a704c4ffd903c79 |
|
| MD5 | 4ab5b8467eca4dd8536a1b86748ebe35 |
|
| BLAKE2b-256 | 0a3d6670a803aa8f90579ca75f907694c74ea66fddb1fe2a8511471a4a8bae2b |
