| #!/usr/bin/env python3 | |
| ''' | |
| Thanks to Andres Torres | |
| Source: https://www.pythoncentral.io/introduction-to-sqlite-in-python/ | |
| ''' | |
| import sqlite3 | |
| # Create a database in RAM |
Long ago, the first time I read "The Pragmatic Programmer", I read some advice that really stuck with me.
"Don't Use Manual Procedures".
This in the chapter on Ubiquitous Automation. To summarize, they want you to automate all the things.
The trouble was that I hadn't much of an idea how to actually go
How to get a remote repository (from BitBucket, GitHub or anyone)
$ git clone https://github.com/<username>/<repository>.git
If you have added a SSH key, then you can also use this command:
$ git clone git@bitbucket.org:<username>/<repository>.git
How to create a new repository from the command line
unittest2
| _ | |
| _._ _..._ .-', _.._(`)) | |
| '-. ` ' /-._.-' ',/ | |
| ) \ '. | |
| / _ _ | \ | |
| | a a / | | |
| \ .-. ; | |
| '-('' ).-' ,' ; | |
| '-; | .' | |
| \ \ / |
A personal diary of DataFrame munging over the years.
Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)
| # Customize BASH PS1 prompt to show current GIT repository and branch. | |
| # by Mike Stewart - http://MediaDoneRight.com | |
| # SETUP CONSTANTS | |
| # Bunch-o-predefined colors. Makes reading code easier than escape sequences. | |
| # I don't remember where I found this. o_O | |
| # Reset | |
| Color_Off="\[\033[0m\]" # Text Reset |
| git branch -m old_branch new_branch # Rename branch locally | |
| git push origin :old_branch # Delete the old branch | |
| git push --set-upstream origin new_branch # Push the new branch, set local branch to track the new remote |
| # Compiled source # | |
| ################### | |
| *.com | |
| *.class | |
| *.dll | |
| *.exe | |
| *.o | |
| *.so | |
| # Packages # |
