splusconsulting Goto Github PK

followers: 1.0 following: 1.0 repos: 6.0 gists: 0.0

Name: Philip Sutera

Type: User

Company: Independent Consultant

Bio: No formal training. Code here are scripts developed over last dozen or so years to help solve specific business problems. Improvements welcome

Location: Seattle

Blog: https://www.linkedin.com/company/s-pluss/

Philip Sutera's Projects

b2b_orderforecasting

SQL Server Code used to determine order patterns at customer and SKU level and then forecast next order week for planning purposes. Customer SKU orders must meet a minimum threshold to be considered (can be tested an manually changed in the code)

cust_analysis

Implimentation of customer clustering on sales data. Uses nltk and scipy create customer clusters based on transaction history and NLP of product descriptions

monthly_sarimax

Script for creating monthly SARIMAX forecast for total sales or for various products

pfd-word-count

Code to open a pdf, read the text and create a csv with each unique word and the number of times it appears in the file

sql_connect

Work around for a SQL server I didnt have permission to create stored procedure on. Used a scheduled python script on my laptop to kick off a python script that connected to a SQL database and selected data into a table I wanted updated daily

url-keyword-count

Pull list of web addresses from a csv file. Counts the number of times words are counted on a website, key words are entered into the script and need to be modified. Writes urls and number of counts for each keyword into a new csv file

Recommend Projects