Aditya and Varun - Final Project Plan

[ad1tyad3sa1]

Preface/Goals:

1. Learn and discover how sorting algorithms work and which ones work best while implementing existing features.
2. Add and update plan according to teacher, peers, and other student inputs.
3. Blog process, learnings, and updates so that we have a complete understanding on task and can represent our work better.

Overview:

The primary focus of our final project is adapting Varun's stock cpt using sorting and searching algorithms. We plan to do this by using a csv containing additional data for all stocks in S&P 500.

• The sorting algorithm that makes the most sense for our dataset is insertion.
• Considering bucket sorting for categorical data.
• Creating a platform for filtering stock data-based on sectors (Varun's part).
• Filtering companies based on year founded (bubble-sorting).

Plan:

• Considering using a table format, similar to existing feature, to represent Varun's part.
• Integrate existing buy sell feature to new category feature
• Looking into using a slider for a user to drag and find out stocks based on year founded for Aditya's part.
• Might have to filter CSV file and clean data to get rid of unnecessary information.
• Might have to adapt existing database or add on to database in backend API.

Deployment/Future:

• Make sure all APIs intilized under Init.
• Deploy project to display understanding and importance of real time data change.
• Learn about other CS topics through NATM and from viewing/reviewing other peoples projects.
• Work toward implementing all changes and suggestions given by teacher/peers.

Focus: is to create an operational update to CPT that uses and displays our understanding or sorting/searching algorithms.

Day-To-Day plans:

• Monday: Work on cleaning csv data and algorithmically sorting data/ frontend
• Tuesday: Work on Api/Frontend
• Wednesday: Work on connecting both API and Frontend and test for any errors.
• Thursday:work on deployment and final project testing
• Friday: Work on deployment

Progress

• all goals completed
• additional restructuring of existing project layout
• additional added single stock price update feature
• additionally added bubble sort of sort by alphabetic order for stock symbol
• deployed backend

[varunm532]

Progress/Completed:

Aditya's Feature:

• Frontend:

  • Create a slider for Aditya's feature of filters companies based on year
  • Slider used to set year range used for filtering companies.

• Backend:

  • Created a model containing code for filtering/sorting companies:
  • cleans CSV data
    • extracts year (specifically) from the year founded column in the CSV file
    • drops all columns except: 'Symbol', 'Founded', 'GICS Sector' columns
  • Uses merge sorting
  • Then filters based on year

    Varun's feature:

• Frontend:

  • Created a interactive pie chart prompting user to select the sector to sort by
  • Chart consistent with actual weightage of each sector in S&P 500
  • Sends selected sector to backend to start filtering process. eg. json : {"GICS Sector": "Utility"}

• Backend:

  • Created a model containing code for filtering/sorting companies:
  • cleans CSV data by making each sectors in the GICS Sector column in CSV file to numbers
  • Bucket Sorting/Filtering:
    • appends a empty list(buckets) into a list for every unique "sector" in the CSV file
    • reads through the previously cleansed CSV data to put same numbers into a bucket. This sorts all sectors
    • cleans JSON response to assign input sector to number ( same as CSV cleaning)
    • uses the cleaned JSON response number to all the bucket with the same number and sends it to the api by calling this function in the api

[varunm532]

Frontend:

• prompts user to search for stock by sectors
• redirects to page with stocks with options to buy

  Backend:

  

• gets user input
• calls model to get sorted stocks
• model code to clean csv file sector data to numeric values
• returns a list of tuple contain stock symbol and clean numeric value
• code for a variation of bucket sorting
• appends a empty list for every unique sector to a list callled :initialbucket
• iterations through list return for cleaning
  • access cleaned number for list element
  • appends element to specific list(bucket) in initialbucket based on cleaned number
  • returns initialbucket
• code that is called in api
• cleans json response based on same format as csv
• calls sorts function to get initialbucket
• creates sortdata by calling bucket with corresponding cleaned number
• uses bubble sorting to sort stocks symbols alphabetically
• inefficient, but small tuples list size therefore reasonable usage
• outer loop:
  • n-1 loops because each pass through the list places the next largest unsorted element in its correct position.
  • The outer loop controls the number of passes
• Inner loop:
  • handles actual comparison
  • compares two elements and swaps if necessary: compares ascii values of strings
  • range(0, n - i - 1): ensures that the loop does not run past the last unsorted element
• swapped flag:
  • used to optimize sorting
  • stops the outer loop if no passes are made in a single pass
• sortdata sent to class sortdisplay and is itterated through
• gets symbol by checking 0 index of element
• searching db for stock to get info and appends to list called returnlist
• each element of returnlist is read and appended to newlist
• new list is sent to frontend