craig-pt / pywrds Goto Github PK
View Code? Open in Web Editor NEWThis project forked from jbrockmendel/pywrds
Economists' tools for downloading data from WRDS.
License: Other
This project forked from jbrockmendel/pywrds
Economists' tools for downloading data from WRDS.
License: Other
Write script to return number of rows stored in a given table.
Need the possibility to access multiple tables and their results within a single query.
Pass in a dict / list and then access specific table accordingly
table_names = ['table_1', 'table_2']
or with name and description in dict? I think there's a new python type to allow this - look it up.
Just tried getting large file and transfer speeds of 80 Kbs. Around 20 mins for 98Mb using sftp. When try with pywrds hanging, so went direct.
Perhaps need to warn user if going to take this long.
raise IOError(text)
IOError: Failure
Way over quota and just trying to write 969 bytes throws IOError.
Seems to be no clear winner, go with some form of wrapped SQL.
(Set up as Class that inherits pywrds (db client)? )
Options: PonyORM
See:
Remove need to keep calling ssh.getSSH
query = ''
if libname:
query = "libname temp '{0}';".format(libname)
Some sort of listing of subscribed to db and their header info.
Can wrap with timeit if necessary
Also, some open source solutions to read .sas7bdat files directly, e.g. http://git.pyhacker.com/sas7bdat
Commented out the reconnection part. See the TODOs.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.