Code Monkey home page Code Monkey logo

osppre's Introduction

OSPPre (Open Source Parts Prediction), largely inspired by Aquant.io's Smart Triage & Parts Prediction

A short write-up on Medium is here.
A short write-up on Linked-in with a Demo video.
The Wiki has some additional insights.

Installation

Install the Anaconda Environment via AnacondaEnvironment.yml
Create a MySQL DB Schema - as per DDL/DDL.sql
Change the database connection properties in SQLHelper.py

Usage

Going from unstructured historical data to structured categorical data

  1. Get some historical data containing Work Orders & Problem Descriptions, for a specific machine, in the format shown in SampleInput/IntegrationTest.csv. Or use the sample file.

  2. By default, the outputs, MasterList.csv & WOsAndSymptoms.csv, are written to the folder /SampleOutput.

  3. Edit InvokePipeline.py to point to the file containing the historical data.

  4. Invoke InvokePipeline.py.

  5. Review the outputs of the above process. MasterList.csv contains the Master list of Symptoms that can go wrong with the machine. Review & edit this file. Review the column symptom_text. This contains the Symptoms that are shown in the UI. Since this shows up on the UI, they should look good. Feel free to replace any value here with a semantically similar value from the column DuplicateSymptomsList. The column symptom_question should be edited to hold the question asked by the Call Center Agent during the Triage. For a Symptom_text like "Radiator leaking", the question can be something like "Is the Radiator leaking ?". WOsAndSymptoms.csv contains WO-Symptom co-occurrences and does not need to be edited.

  6. Import MasterList.csv & WOsAndSymptoms.csv into the tables master_symptoms & wo_symptom_cooccurence, respectively. Note that the column DuplicateSymptomsList in MasterList.csv, does not reside in the database. Since MasterList.csv contains vectors, good import tools like Navicat or RazorSQL are required to perform the import.

  7. The table parts_master should contain the Parts Master data. Or use DDL/DummyPartsMaster.sql.

  8. The table wo_parts should contain the historical data associating the WOs & the Parts consumed. Or use DDL/DummyWOParts.sql

  9. Once the 4 tables are populated, start the REST service - RestService.py

Getting Predictions

Review the Swagger API spec under REST/openapi-client-generated
There are just 3 APIs.
1. Get the next Symptom question (Service used by the Triage UI)
2. Get Predictions given the Symptom IDs
3. Get Predictions given the Problem Description text

The API documentation is here

osppre's People

Contributors

navraj28 avatar

Stargazers

 avatar

Forkers

naushad-khan

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.