Coder Social home page Coder Social logo

franklinjtan / final-web-application Goto Github PK

View Code? Open in Web Editor NEW
1.0 1.0 3.0 2.69 MB

Using Python, Docker, Flask, Jinja, Bootstrap, HTML, CSS and MySQL I built an application that is designed to journalize all stocks in a given portfolio. I also implemented Oauth2 to make it easier for users to login using their Google Accounts. In the near future, I will look to integrate Yahoo Finance modules to make the application retrieve the latest stock prices. Additionally, I plan to scrape Top Financials News Sites such as GuruFocus, Seeking Alpha, and Yahoo News and capture the latest news for the given company.

Python 30.23% Dockerfile 0.78% HTML 68.53% CSS 0.46%
flask html jinja mysql oauth2 python

final-web-application's Introduction

Franklin Tan

My Links

KS Business Problem

  • Business Recommendations Summary:
    • Kickstarter New Campaign Moratorium (during low activity months) to focus on improving the quality of current projects, and create a sense of excitement.
    • Green Day! Similar to Black Friday, but to support entrepreneurs and bring ambitious, innovative, and imaginative ideas to life
    • Provide marketing services to Kickstarter Creators to help them optimize the launch of their campaigns. Overambitious funding targets can lead to project failure, disappointment among backers, and potential damage to Kickstarter's reputation. By helping creators set appropriate funding goals, Kickstarter can increase the chances of project success and backer satisfaction.
    • Attract Organic Backers: One way to achieve this is by enhancing the platform's visibility and outreach to potential backers, showcasing successful projects, and engaging with the creative community. Building a strong initial backing for projects will help create a sense of momentum and social proof, which can attract additional support.
    • Incentivize Larger Pledges: Kickstarter should continue pursuing strategies that reward and incentivize backers who contribute higher amounts. Offering exclusive perks, early access, or special recognition like badges to backers making significant contributions can motivate backers to pledge more, leading to increased revenue for both Kickstarter and project creators.
  • Classification Methodology KS method

Key Findings ROC_curve bar-chart log_curve

KS Business Problem

  • 2nd Place Winner at the Cornell SC Johnson Data Science Showcase on May 22, 2023
  • Our motivation to address this problem stemmed from our research on the growing credit card debt in the United States and the lack of predictive and prescriptive analytics in budgeting and personal finance apps. While you may receive information on your spending and where it occurs, you typically don't receive real-time feedback on which categories to cut back on, personalized strategies to adopt, or an understanding of your strengths and weaknesses.
  • Our solution incorporates the OKR and KPI measurement framework to track spending data and establish a realistic budget. We utilize ML models like Naive Bayes to classify transactions as necessities or not, advanced forecasting methods to predict categories of overspending and prescribe strategies to take, gamification to encourage healthy spending habits, and a Chrome Extension that analyzes your recent purchase history and engages System 2 (deliberate thinking) to prevent impulse purchases.
  • Used pandas, numpy, dash, nltk, panel, and plotly libraries for data wrangling, data visualizations, web application framework, ML algorithms, and dashboard deployment. Dashboard Spendalyzer Recommendations

I conducted a comprehensive consumer behavior analysis for the Supplemental Nutrition Assistance Program (SNAP) using Python. SNAP is a food assistance program in the US for low-income households. The analysis aimed to understand the psychological mechanisms driving SNAP households' tendencies to purchase unhealthy, hedonic food items. The research identified key insights and made recommendations to the USDA Director to reduce unhealthy food consumption among SNAP participants.

Key Insights:

  1. Attention to Hedonic Food Items: SNAP households exhibit higher cravings for both hedonic and utilitarian food items compared to non-SNAP households. Their circumstances may lead to reliance on heuristics (system 1 thinking) rather than analytical thinking (system 2), influencing their food choices.
  2. Emotional Responses: SNAP households experience stronger cravings for both hedonic and utilitarian food items due to their stressful situation, prioritizing immediate gratification.
  3. Coherence in Hedonic Purchases: Despite being aware of potential health risks, SNAP households justify hedonic food choices to maintain coherence and emotional well-being.
  4. Statistically Significant Findings:
    • SNAP households buy more hedonic products but fewer utilitarian products compared to non-SNAP households
    • Income and education are not statistically significant predictors of SNAP households' consumption patterns.
    • SNAP households do not consider hedonic food to be better value for money compared to utilitarian food.
    • SNAP households perceive both hedonic and utilitarian products as less unhealthy than non-SNAP households.
    • SNAP households report higher craving levels for both hedonic and utilitarian products compared to non-SNAP households.
    • The relationship between craving and unhealthiness perception is stronger among SNAP households.
  • Performed RFM analysis, created customer segments, and predicted CLV for a 6-month period, enabling businesses to make informed decisions about customer acquisition, retention, and management strategies.
  • Recency scores were assigned to each customer based on their last purchase date.
  • Recency clusters were ordered and assigned based on the recency scores.
  • Frequency clusters were determined by calculating the number of orders for each customer.
  • Revenue clusters were created by calculating the revenue generated by each customer.
  • Overall scores were calculated by summing the recency, frequency, and revenue cluster numbers.
  • Customers were segmented into low-value, mid-value, and high-value segments based on their overall scores.
  • Customer Lifetime Value (CLV) for a 6-month period was calculated by summing the revenue for each customer.
    Dashboard
  • Created a set of analyses and data visualizations that explores whether Netflix movies are getting longer or shorter
  • Used matplotlib, pandas, seaborn to generate line charts, bar charts, histograms, box plots, scatterplots, and groupedby dataframes Scatterplot-Netflix Linechart-Netflix
  • Understanding the importance of diversification and a portfolio of uncorrelated returns, I plotted the 5-year returns of several equities, ETFs, and commodities against SPY.
  • I also used linear regression to calculate the beta and correlation, and generated a correlation matrix and a heatmap.
    Correlation Matrix Heatmap of Portfolio
  • Created a set of analyses and data visualizations that support or disprove the following statements made by Subway Restaurant leadership:
    • Head of Customer Service: “Our ratings are gradually improving, and we will soon reach 4.5/5.”
    • Head of Store Operations: “Sandwiches are a tricky business. All sandwich chains suffer from poor customer ratings.”
    • Head of Social Media: “The goal of 4.5/5 is unreasonable for national chains like us. Only small, local, and boutique restaurants can achieve such high ratings.”
    • Chief Data Scientist: “It is well known that customers make the effort to give a rating only when they are either extremely angry or absolutely delighted with the service. So online ratings are not reliable.”
  • Used matplotlib, seaborn, scipy, and pandas to generate line charts, bar charts, scatterplots, groupedby dataframes, and linear regression
    Avg Ratings by State through the Years Total Ratings Received by stars value and years 2018-2021
  • Created a program simulation written in Python that will generate a production level recommendation given a set of parameters
  • Used NumPy to generate a random sample of demand instances from a normal (Gaussian) distribution.
  • Used matplotlib to generate a scatterplot visualization with a color scale depicting optimal ranges of production
  • Cleaned and prepared monthly retail trade data from the Census Burea to create a time-series of various industries from 1992 to 2022
  • Used Python Pandas for data cleaning and Tableau to create visualizations
  • Tableau Dashboard
  • Created an application that crawls the a fashion store website and extracts product information to helps users track and reduce their environmental impact.
  • Scraped over 1000 product descriptions from the clothing store, The Reformation using python and selenium
  • Stored the data in a hosted database (AWS RDS).
  • Optimized solution by targeting unique identifier-keys like ASIN in cases where website structure changes or product becomes out-of-stock.

Certificates:

final-web-application's People

Contributors

franklinjtan avatar

Stargazers

 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.