I want to give an unsolicited shout-out to the one program that I recommend you download right this second: Everything Search (link). It’s a local file search tool which requires a few tweaks in settings (excluding %appdata%, windows, program files). The best about this is it’s fast, not resource intensive (except for when indexing files,…
A popular source of information are the filings held in the EDGAR database. EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection, validation, indexing, acceptance, and forwarding of submissions by companies and others who are required by law to file forms with the U.S. Securities and Exchange Commission SEC (U.S. Securities and…
https://www.youtube.com/watch?v=2Oe9ZqXVGME&t=2427s How To Download and Process SEC XBRL Data Directly from EDGAR ^https://github.com/altova/sec-xbrl thanks Alex $ python loadSECfilings.py -y 2014 -m 1 –f 2014 –t 2017 http://rankandfiled.com/ pretty cool
To run need to do two things (while in folder of python filename.py): 1) Run worker by executing the python program with the “worker” arguement: $ celery –A tasks worker –loglevel=info 2) Call the task aka run: $ python filename.py ####################### # grabhtml.py import requests from html import unescape class GrabHTML(object): def __init__(self): pass…
Python Script to insert CSV File into SQL Server Database import pandas as pd import csv import pyodbc import sys, os USERNAME = ‘sa’ PASSWORD = ‘password’ SERVER = ‘server’ DATABASE = ‘DATA’ DRIVERNAME = ‘ODBC Driver 13 for SQL Server’ cnxn = pyodbc.connect(‘Driver={‘+DRIVERNAME+’};Server=’+SERVER+’;Database=’+DATABASE+’;uid=’+USERNAME+’;pwd=’+PASSWORD) cur = cnxn.cursor() ##### using pandas grab first row for column…
Searching Website/Html/Document – currenly using Docfetcher, PowerGrep Flask/Django – looking into creating search page for html files Docker, MongoDB (3T MongoChef), Redis (Redis Desktop Manager) in Docker Storing the Data – HTML, CSV, JSON Pandas – dataframes, concat, merge OpenrefineGoogleRefine – Seemed to do trick so NLTK will come another day Natual Language Processing – Briefly…
Been been using ManicTime (www.manictime.com/) for >3 years to keep track of what I work on. Going to use this as source for weekly working on post.
ConEmu64.exe !@ !P -new_console:d -cur_console:znd:C:Usersryan C:WindowsSystem32bash.exe “ssh !U@!@ -p !# -t ‘cd !/ ; /bin/bash’” ^^ paste in WinSCP preferences edit 02-25-17: I just reloaded windows and realized that you need to install SSH.EXE in windows path (i.e. install git and make sure ssh.exe is in path… my bad) Now when connect, opens new console…