DaveInga
/ gist:a7c68e1403c8ecddcad2
Last active Sep 13, 2015
— forked from rtt/gist:5a2e0cfa638c938cca59
example python tinderbot
View gist:a7c68e1403c8ecddcad2
| # encoding: utf8 1,1 Top# encoding: utf8 | |
| import argparse | |
| from datetime import datetime | |
| import json | |
| from random import randint | |
| import requests | |
| import sys | |
| from time import sleep |
DaveInga
/ desired-output.txt
Created Jul 24, 2013
I'm an sql noob, this is my first function... How do I go about creating a function 'fiscal_year' which could create output.txt (below)?
View desired-output.txt
| xbrl=# select fiscal_year,cik,company_name from csv_table limit 10; | |
| fiscal_year | cik | company_name | |
| -------------+---------+-------------------------------------- | |
| 2010 | 1075607 | TC PIPELINES LP | |
| 2011 | 1075607 | TC PIPELINES LP | |
| 2012 | 1075607 | TC PIPELINES LP | |
| 2012 | 1075607 | TC PIPELINES LP | |
| 2010 | 1314054 | BMX Development Corp. | |
| 2011 | 1423974 | Farrallon, Inc | |
| 2011 | 1396536 | INFORMATION SYSTEMS ASSOCIATES, INC. |