Request HTML Celery, RabbitMQ, and Redis

  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…

SQL Server Create New Table And Insert Data using Python

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…

Working On–Week Review

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…

Company Report

Reminder: Purpose of website in general is to give a broad range of my capabilities, so in many cases end up sacrificing quality for quantity.             (Report Template: Equity Research Report Essentials – CFA Institute)

Notes – Materials > Petrochemical Industry

When I was a full-time Research Analyst, I spent a fair amount of time dissecting and understanding the Material Sectors, specifically Petro-Chemical Industry.  As you can see from the images below, these materials are used throughout the economy including Textiles, Safe Food Supply, Transportation, Housing, Recreation, Communications and Health and Hygiene.            ·         http://cen.acs.org/global-top-50.html