This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
###requirements.txt | |
#pycrypto | |
#pyopenssl | |
## Creds | |
AWS_EC2_ACCESS_ID='AKIA**********' | |
AWS_EC2_SECRET_KEY = 'mh83**************' | |
PEM_FILE = os.path.expanduser('D:\\abc\\scripts\\s\\test.pem') | |
### Get Windows Admin password of the newly created AWS instance |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!pip install dropbox pandas | |
# Register for dropbox developer account for this to work and get the auth access code as explained in the get_dropbox_auth_access_code.py | |
# Include the Dropbox SDK | |
import dropbox | |
import pandas as pd | |
# get the access token from the get_dropbox_auth_access_code.py - below code is fake | |
access_token = "9TskpJ1jKCwAAAAAAAAAAVTAzOoY1VWDMGjKCwAAAg-Wu3uoYfd39ZZDvBkc179" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
""" | |
example use of pandas with oracle mysql postgresql sqlite | |
lightly tested. | |
to do: | |
save/restore index (how to check table existence? just do select count(*)?), | |
finish odbc, | |
add booleans?, | |
sql_server? | |
""" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mkdir ~/installs | |
cd ~/installs | |
wget -O dropbox.tar.gz "http://www.dropbox.com/download/?plat=lnx.x86_64" | |
tar -xvzf dropbox.tar.gz | |
mv .dropbox-dist ~/.dropbox-dist | |
~/.dropbox-dist/dropboxd | |
#Go to the URL provided by the above command. | |
#It will ask for your dropbox username and password to authorize the newly install dropbox client on the ubuntu server. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# IPython Notebook Launcher | |
# Adopted from the Rstudio upstart script | |
# | |
# | |
# upstart docs: http://upstart.ubuntu.com/getting-started.html | |
# http://manpages.ubuntu.com/manpages/karmic/man5/init.5.html | |
# | |
# (note that embedding a script and pre-start and post-start actions are supported) | |
# |