{ "info": { "author": "WRDS", "author_email": "wrds@wharton.upenn.edu", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Console", "Intended Audience :: Education", "Intended Audience :: End Users/Desktop", "Intended Audience :: Financial and Insurance Industry", "Intended Audience :: Science/Research", "Programming Language :: Python", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Topic :: Office/Business :: Financial", "Topic :: Scientific/Engineering :: Information Analysis" ], "description": "WRDS Python Data Access Library\n===============================\n\nWRDS-Py is a library for extracting data from WRDS data sources and getting it into Pandas.\nThe library allows users to access data from WRDS and extract data using SQL statements. The data\nthat is returned is read into a Pandas data frame.\n\nInstallation\n~~~~~~~~~~~~\n\nMac OS/Linux\n\n$ python setup.py install\n\nWindows\n\nThe WRDS-PY package requires Pandas and Psycopg2. Binaries of these can be found here:\nhttp://www.lfd.uci.edu/~gohlke/pythonlibs/#psycopg\n\nOnce the two required packages are installed, you can run\n$ python setup.py install\n\nFor more information please consult the WRDS Support section at https://wrds-web.wharton.upenn.edu/wrds/support/.\n\nUsage\n~~~~~\n\n>>> import wrds\n>>> db = wrds.Connection()\nEnter your credentials.\nUsername: \nPassword: \n>>> db.list_libraries()\n['audit', 'bank', 'block', 'bvd', 'bvdtrial', 'cboe', ...]\n>>> db.list_tables(library='crsp')\n['aco_amda', 'aco_imda', 'aco_indfnta', 'aco_indfntq', ...]\n>>> db.describe_table(library='crsp', table='stocknames')\nApproximately 58957 rows in crsp.stocknames.\n name nullable type\n0 permno True DOUBLE PRECISION \n1 permco True DOUBLE PRECISION \n2 namedt True DATE\n...\n\n>>> stocknames = db.get_table(library='crsp', table='stocknames', obs=10) \n>>> stocknames.head()\n permno permco namedt nameenddt cusip ncusip ticker \\\n0 10000.0 7952.0 1986-01-07 1987-06-11 68391610 68391610 OMFGA\n1 10001.0 7953.0 1986-01-09 1993-11-21 36720410 39040610 GFGC\n2 10001.0 7953.0 1993-11-22 2008-02-04 36720410 29274A10 EWST\n3 10001.0 7953.0 2008-02-05 2009-08-03 36720410 29274A20 EWST\n4 10001.0 7953.0 2009-08-04 2009-12-17 36720410 29269V10 EGAS\n\n>>> db.close() # Close the connection to the database...\n\n>>> with wrds.Connection() as db: # You can use a context manager\n... stocknames = db.get_table(library='crsp', table='stocknames', obs=10)\n>>> stocknames.head()\n permno permco namedt nameenddt cusip ncusip ticker \\\n0 10000.0 7952.0 1986-01-07 1987-06-11 68391610 68391610 OMFGA\n1 10001.0 7953.0 1986-01-09 1993-11-21 36720410 39040610 GFGC\n2 10001.0 7953.0 1993-11-22 2008-02-04 36720410 29274A10 EWST\n3 10001.0 7953.0 2008-02-05 2009-08-03 36720410 29274A20 EWST\n4 10001.0 7953.0 2009-08-04 2009-12-17 36720410 29269V10 EGAS\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://www.whartonwrds.com", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "wrds", "package_url": "https://pypi.org/project/wrds/", "platform": "", "project_url": "https://pypi.org/project/wrds/", "project_urls": { "Homepage": "http://www.whartonwrds.com" }, "release_url": "https://pypi.org/project/wrds/3.0.8/", "requires_dist": [ "mock", "pandas", "psycopg2-binary", "sqlalchemy" ], "requires_python": "", "summary": "Python access to WRDS Data", "version": "3.0.8" }, "last_serial": 5932247, "releases": { "0.0.5": [ { "comment_text": "", "digests": { "md5": "d26fb79851585886e38a71a19aa29d0d", "sha256": "08e666c1bd7cc96d28f3c15037344b3d77a212bc2753d69d1ab78ebd883a1ec5" }, "downloads": -1, "filename": "wrds-0.0.5.tar.gz", "has_sig": false, "md5_digest": "d26fb79851585886e38a71a19aa29d0d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2456, "upload_time": "2015-12-10T21:30:50", "url": "https://files.pythonhosted.org/packages/83/be/967dddaa0a756425ace8cd96773d5a72529eca1899ab6c7f1fe919e2c13d/wrds-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "1374d08a6f9907a18bd6b4cf8f0d30fa", "sha256": "78390cf1699b96233b32cf0563e426173c98c436651f41998c65f3b82d2ddbbe" }, "downloads": -1, "filename": "wrds-0.0.6.tar.gz", "has_sig": false, "md5_digest": "1374d08a6f9907a18bd6b4cf8f0d30fa", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2468, "upload_time": "2017-03-13T19:13:51", "url": "https://files.pythonhosted.org/packages/26/c4/96ecbe309a56e355728709aa15cdc7b733920eaf35685336bd0c04a34a29/wrds-0.0.6.tar.gz" } ], "3.0": [ { "comment_text": "", "digests": { "md5": "4ab5b8467eca4dd8536a1b86748ebe35", "sha256": "e82aba369ba4802dbd05624eed7d11e1d45142e63aef59195a704c4ffd903c79" }, "downloads": -1, "filename": "wrds-3.0.tar.gz", "has_sig": false, "md5_digest": "4ab5b8467eca4dd8536a1b86748ebe35", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5816, "upload_time": "2017-06-30T20:36:13", "url": "https://files.pythonhosted.org/packages/0a/3d/6670a803aa8f90579ca75f907694c74ea66fddb1fe2a8511471a4a8bae2b/wrds-3.0.tar.gz" } ], "3.0.1": [ { "comment_text": "", "digests": { "md5": "6bba67c79ff171a8f8cb07b697a68d91", "sha256": "afa3254b67db205957049aeeca54e3459d875cc4b855a591dd8f70ac87fc0a3d" }, "downloads": -1, "filename": "wrds-3.0.1.tar.gz", "has_sig": false, "md5_digest": "6bba67c79ff171a8f8cb07b697a68d91", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5795, "upload_time": "2017-07-01T02:24:06", "url": "https://files.pythonhosted.org/packages/7d/1d/d9720a4d801466ef2acb08b01ace44546c3ac025318ce2a6bdb60bb93da9/wrds-3.0.1.tar.gz" } ], "3.0.2": [ { "comment_text": "", "digests": { "md5": "6a6196aa14ca66425581378fe2e45291", "sha256": "53f2b8ef1a6004a116a2d8eaa51d0c3566c785abe7a444c8159fcdb17a08f1bb" }, "downloads": -1, "filename": "wrds-3.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "6a6196aa14ca66425581378fe2e45291", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11531, "upload_time": "2017-11-16T19:19:49", "url": "https://files.pythonhosted.org/packages/dc/78/0283d76d4477e3d11d40da6bf32c4221b6120d63fd22f7bbf5f38681197c/wrds-3.0.2-py3-none-any.whl" } ], "3.0.3": [ { "comment_text": "", "digests": { "md5": "754d4ce40428ad9dd69d2c4497e9126b", "sha256": "520e48ef0d07f1f4c42937dec7d5c6ac00b776173031cd96e4fd2af8ee4d35ea" }, "downloads": -1, "filename": "wrds-3.0.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "754d4ce40428ad9dd69d2c4497e9126b", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 11584, "upload_time": "2018-05-07T20:05:39", "url": "https://files.pythonhosted.org/packages/1f/b2/709eaa7c27376fd74a98ac02d4857782892d883af86e90220a72a271c2de/wrds-3.0.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e0ac18cfd829323ef020319aadc1928f", "sha256": "6a71ec4dbdc28f412b9d0dfd36e26626515a9740f85dbdd2d693f4ec158e52b7" }, "downloads": -1, "filename": "wrds-3.0.3.tar.gz", "has_sig": false, "md5_digest": "e0ac18cfd829323ef020319aadc1928f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9575, "upload_time": "2018-05-07T20:05:40", "url": "https://files.pythonhosted.org/packages/e5/cf/32c6048d16567217ee9c3c4769ee57cc080bffefe8dca87d2d391c0a0ff5/wrds-3.0.3.tar.gz" } ], "3.0.4": [ { "comment_text": "", "digests": { "md5": "82b7bfda871451f24ff6e18ccce3b9dc", "sha256": "857ab84d9765c7ef4d35a8e6aa09083614257bf708c72a82d897b0588a56943d" }, "downloads": -1, "filename": "wrds-3.0.4-py3.7.egg", "has_sig": false, "md5_digest": "82b7bfda871451f24ff6e18ccce3b9dc", "packagetype": "bdist_egg", "python_version": "3.7", "requires_python": null, "size": 20575, "upload_time": "2019-04-23T16:42:23", "url": "https://files.pythonhosted.org/packages/96/8f/6c4e763dc5a4e6d5fda9e0913fa336baa1003ae88deb0840e61b2ad19c34/wrds-3.0.4-py3.7.egg" }, { "comment_text": "", "digests": { "md5": "6da522be87211971f30353e8cd534880", "sha256": "3667fe1108047c0ab15c1787376a2e281909fdfc2a6bb1e012a87fc6008664cf" }, "downloads": -1, "filename": "wrds-3.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "6da522be87211971f30353e8cd534880", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11695, "upload_time": "2018-07-13T12:52:22", "url": "https://files.pythonhosted.org/packages/71/16/59dd5e6bee5156e6c678e62cd187cfe9df621b7308e84b2ef7468d71bf28/wrds-3.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b76247d7c0d8b39caea6811b4f4f2a2b", "sha256": "9565a9e3e51aeb06077d60c97273f15d4347d429a65ead2c0f643948d59000c5" }, "downloads": -1, "filename": "wrds-3.0.4.tar.gz", "has_sig": false, "md5_digest": "b76247d7c0d8b39caea6811b4f4f2a2b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9419, "upload_time": "2018-07-13T12:52:24", "url": "https://files.pythonhosted.org/packages/31/da/892019b42c1729702262d7fca3ef51b014b929207ae9c8c9a2d0bd7eca50/wrds-3.0.4.tar.gz" } ], "3.0.5": [ { "comment_text": "", "digests": { "md5": "06fcbb4a3ad50b2e403cf2db865a7a46", "sha256": "c902115ef893860e1d0b1aa1c0ab30dd48154a9ad6ffbccb8aea99d01e972086" }, "downloads": -1, "filename": "wrds-3.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "06fcbb4a3ad50b2e403cf2db865a7a46", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 10838, "upload_time": "2018-10-05T19:41:03", "url": "https://files.pythonhosted.org/packages/29/d6/892838b96a0e949199db0c47981ba985f42e7e660b0b00ef11143e8c932a/wrds-3.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6acbd8a59298d9a96fe717e57968fc91", "sha256": "e7d20db3b864b765d0b65b51c110ca1a63dfedc77d028956b08535e4472cb84e" }, "downloads": -1, "filename": "wrds-3.0.5.tar.gz", "has_sig": false, "md5_digest": "6acbd8a59298d9a96fe717e57968fc91", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10009, "upload_time": "2018-10-05T19:41:06", "url": "https://files.pythonhosted.org/packages/0c/f1/6a2335d17c2fe928b544ba0c67641f222e1ace4b8339d2d7fce934f2c216/wrds-3.0.5.tar.gz" } ], "3.0.6": [ { "comment_text": "", "digests": { "md5": "725762678e8d5ce8fab2fd4e58ceea62", "sha256": "7923a64db30930ac687b4b70623cc92555dc68bd5c7d5d0d5696ceb8bf3c9fde" }, "downloads": -1, "filename": "wrds-3.0.6-py2-none-any.whl", "has_sig": false, "md5_digest": "725762678e8d5ce8fab2fd4e58ceea62", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 11576, "upload_time": "2018-11-16T18:51:12", "url": "https://files.pythonhosted.org/packages/7b/85/f42d5344c22e1c47ec4235126f394d6e17b1a25c9eaab88bab990935e969/wrds-3.0.6-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7d1903c30e26c3c2137ab909c432a2ca", "sha256": "5cc3ccaef9c2d656b13137c570a8f45463337ccab3561ccc1a1952d568c47586" }, "downloads": -1, "filename": "wrds-3.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "7d1903c30e26c3c2137ab909c432a2ca", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11577, "upload_time": "2018-11-16T18:51:14", "url": "https://files.pythonhosted.org/packages/c2/1c/0daee64bf36a7b32e46341902329efa41ecad1230762fe055e389478851b/wrds-3.0.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d3dc057b1f521e84fcd2a9a9894b3979", "sha256": "bfb8425b7a93b8f677373a9b9406bada218537af8ca0bfd42b165dd6fd0585d6" }, "downloads": -1, "filename": "wrds-3.0.6.tar.gz", "has_sig": false, "md5_digest": "d3dc057b1f521e84fcd2a9a9894b3979", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10487, "upload_time": "2018-11-16T18:51:15", "url": "https://files.pythonhosted.org/packages/0f/70/4ff3acd9c57e13895aa3f232efb6ce3b4448550189870010597108b0d3bc/wrds-3.0.6.tar.gz" } ], "3.0.7": [ { "comment_text": "", "digests": { "md5": "f08ad2ce4a51b2f3882b14e238343c30", "sha256": "218c4478cb281d1434183c97296f76c0dd261753edd0f0716343c15de6af0076" }, "downloads": -1, "filename": "wrds-3.0.7-py2.7.egg", "has_sig": false, "md5_digest": "f08ad2ce4a51b2f3882b14e238343c30", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 22388, "upload_time": "2019-04-23T16:42:25", "url": "https://files.pythonhosted.org/packages/27/e3/0b8ec098a5cc3bb072d370a16c47c6eab5eb26d50609f7d42a8242cb50c3/wrds-3.0.7-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "0b09f5dfb6dedf80b189aa7de4ed7340", "sha256": "e786121454e62a718e674924827fad1ad6d99df475c45ba90c9e2d4a07fb5de9" }, "downloads": -1, "filename": "wrds-3.0.7-py2-none-any.whl", "has_sig": false, "md5_digest": "0b09f5dfb6dedf80b189aa7de4ed7340", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 12627, "upload_time": "2019-04-24T14:09:39", "url": "https://files.pythonhosted.org/packages/f2/3e/b1f40346fe02134d71293d309f9ebac6e38f3a2d4ab5fec45ec5f8acd3e9/wrds-3.0.7-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "31f8f7a0efe12121613d3953884babec", "sha256": "e2eee483d7c54a6de580ccabddebf330581325a4ed5b17f19a0333f8d3d763e7" }, "downloads": -1, "filename": "wrds-3.0.7-py3.7.egg", "has_sig": false, "md5_digest": "31f8f7a0efe12121613d3953884babec", "packagetype": "bdist_egg", "python_version": "3.7", "requires_python": null, "size": 22503, "upload_time": "2019-04-23T16:42:26", "url": "https://files.pythonhosted.org/packages/ec/db/24670ef1dbed33f88d9959eab61708b3fa78f227aa0a58089af9fae6162b/wrds-3.0.7-py3.7.egg" }, { "comment_text": "", "digests": { "md5": "6a7b2df9c02f32cc53ad7af0b5e3fd36", "sha256": "fa689f85368965789ba5bb1bfdb269caa70e4073a024c6bcac199db964528738" }, "downloads": -1, "filename": "wrds-3.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "6a7b2df9c02f32cc53ad7af0b5e3fd36", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11576, "upload_time": "2019-04-23T16:42:22", "url": "https://files.pythonhosted.org/packages/e7/8d/4c2d0e9793a0dc2f443727cf2586a5dca78762902208aeea0e68246f93ee/wrds-3.0.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "bc5de6fa076aeecc8b71812f6c6dda79", "sha256": "931dc3a1963ec373052c8baf769eeaf5f8c6ab000f1937a4c8b3184af1014792" }, "downloads": -1, "filename": "wrds-3.0.7.tar.gz", "has_sig": false, "md5_digest": "bc5de6fa076aeecc8b71812f6c6dda79", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10933, "upload_time": "2019-04-23T16:42:27", "url": "https://files.pythonhosted.org/packages/94/e7/7e7690cadb220af99b50cf5500b6ce9a5043e71e34de4cae55baa1a1a4fe/wrds-3.0.7.tar.gz" } ], "3.0.8": [ { "comment_text": "", "digests": { "md5": "16fc2ba7f4eb66a1be6a654e530cfbdf", "sha256": "85afbf88c4abf65072ee00cf534a9c689d51afc90d81ffba6205028449c70017" }, "downloads": -1, "filename": "wrds-3.0.8-py3-none-any.whl", "has_sig": false, "md5_digest": "16fc2ba7f4eb66a1be6a654e530cfbdf", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 12640, "upload_time": "2019-06-07T20:00:36", "url": "https://files.pythonhosted.org/packages/1c/35/9d86097c36a8528a1f5bbc3815c161c2dfce7fffc28e10cfd7c9726c1ac0/wrds-3.0.8-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a9dc1c585c1f036daef41c0eafd7daa6", "sha256": "94f44b8661d16e22932bc8dfbe3435380799ba06ca642698ae27471d81a0f6c4" }, "downloads": -1, "filename": "wrds-3.0.8.tar.gz", "has_sig": false, "md5_digest": "a9dc1c585c1f036daef41c0eafd7daa6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10099, "upload_time": "2019-06-07T20:00:37", "url": "https://files.pythonhosted.org/packages/a8/03/493096903ec08e392c15df645fcf9a1d94d2e36582061972f109aa4c7d44/wrds-3.0.8.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "16fc2ba7f4eb66a1be6a654e530cfbdf", "sha256": "85afbf88c4abf65072ee00cf534a9c689d51afc90d81ffba6205028449c70017" }, "downloads": -1, "filename": "wrds-3.0.8-py3-none-any.whl", "has_sig": false, "md5_digest": "16fc2ba7f4eb66a1be6a654e530cfbdf", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 12640, "upload_time": "2019-06-07T20:00:36", "url": "https://files.pythonhosted.org/packages/1c/35/9d86097c36a8528a1f5bbc3815c161c2dfce7fffc28e10cfd7c9726c1ac0/wrds-3.0.8-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a9dc1c585c1f036daef41c0eafd7daa6", "sha256": "94f44b8661d16e22932bc8dfbe3435380799ba06ca642698ae27471d81a0f6c4" }, "downloads": -1, "filename": "wrds-3.0.8.tar.gz", "has_sig": false, "md5_digest": "a9dc1c585c1f036daef41c0eafd7daa6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10099, "upload_time": "2019-06-07T20:00:37", "url": "https://files.pythonhosted.org/packages/a8/03/493096903ec08e392c15df645fcf9a1d94d2e36582061972f109aa4c7d44/wrds-3.0.8.tar.gz" } ] }