7,612
edits
Changes
Jump to navigation
Jump to search
Industry Classifier (view source)
Revision as of 13:47, 21 September 2020
, 13:47, 21 September 2020no edit summary
{{Project|Has project output=Tool|Has sponsor=McNair ProjectsCenter|Project TitleHas title=Industry Classifier|Has owner=Christy Warden,|Start TermHas start date=Spring 2017,|Has keywords=Tool|Has project status=Subsume
}}
The objective of this project is to build a neural network that can classify a firm's industry based on text of its business description.
The following projects are dependent on this projects: {{#ask: [[Category:McNair Projects]] [[Is dependent on::{{PAGENAME}}]]}}
=Summer 2018 Work=
Test data will come from crunchbase.
Database is called crunchbase2 and is located in:
/bulk/crunchbase2
The pulled information is in:
E:\McNair\Projects\Accelerators\Summer 2018\Industry Classifier update\Our companies with other info.xlsx
The code to build tables to pull all info is in:
E:\McNair\Projects\Accelerators\Summer 2018\Industry Classifier update\BuildTestData.sql
==MLP Classifier==
The new version that I am editing on is:
E:\McNair\Projects\Accelerators\Summer 2018\Industry Classifier update\IndustryClassifierCONDENSED-USETHIS.py
Small training and testing data is called:
2018traindata.txt
NewTestData2018.txt
Larger training and testing data is called:
bigtrain2018.txt
bigtest2018.txt
This file modifies the Classifier.pkl file which stores the components of the model. Eventually, we should be able to run this through FinalIndustryClassifier.py.
The crunchbase data in my training data has almost 40 labels and I could not get the accuracy rate of this model to go up past 30%. However, if you assign only 3 labels, the accuracy rate goes up to 50%
==LSTM Model==
See old page here [[Deep Text Classifier]]. I updated the preprocessing file to run on python3.
I tried updating this code to run on the new data from Crunchbase. Files used are located in:
E:\McNair\Projects\Accelerators\Summer 2018\Industry Classifier update\Yang's Code
You should first run the preprocessing file and then use the classification file. I could not figure out why the accuracy on this model was only 10% with 40 labels and around 30% with 5-8 labels. The accuracy of this one should be higher than the MLP classifier.
=New Notes=
We're rebuilding the [[Industry Classifier]] using better technology and better inputs.
For the inputs:
*Run LoadLongDescription.sql in Z:\VentureCapitalData\SDCVCData\vcdb2
*With sdccompanybase1 table already loaded, load the commented code in that file too
*This outputs longdescriptionindu.txt
=Final Product and Use=
==Description==
The final product (as of 2/27/17) is FinalIndustryClassifier.py which is located in McNair/Projects/Accelerators/Industry_Classifier.
It takes in an input file of the format Company tab Description and outputs a file called inputfile + Classified.txt. (So if you input Myfile.txt, your output file will be
MyfileClassified.txt). This file will be located in the same folder as the FinalIndustry.py code (McNair/Projects/Accelerators/Industry_Classifier).
==Use==
1) Create a file of the format Company [tab] Description. The description must all be on one line.
2) Copy your file into the folder McNair/Projects/Accelerators/Industry_Classifier
3) Open the file FinalIndustryClassifier.py in Komodo
4) On line 7 of the code, change the words inside the quotation marks to the name of your file. For example, if your file is called MyFile.txt, line 7 should read myfile = "MyFile.txt"
5) Press the play button and wait for "Done!" to print in the output window of Komodo.
6) Open McNair/Projects/Accelerators/Industry_Classifier and find the file called "(the name of your file)Classified.txt" (aka MyFileClassified.txt)
7) Open this file (IN TEXTPAD). It should be your output of the format Company [tab] Classification.
==Command Line Use==
A command line program exists for this tool. To use it, open the Command Prompt and change directories to:
E:\McNair\Projects\Accelerators\Industry_Classifier
To run the program, enter:
python FinalIndustryClassifier_command.py
A prompt will appear asking you to enter an F or S. F stands for File Input, and S stands for Single Use.
If you select F, a prompt will appear asking you to enter an input filename, and an output filename, separated by a space.
=Possible Tools=
Christy: No matter what parameters I change in the NN, I can't get the accuracy to go up above around 30%. Looking at the descriptions that the classifier fails on, I realized that it pretty much guesses randomly a lot of the time when the descriptions are terrible like "We provide services to our customers." I think we need to be training and classifying based on the longer description, which is why I started working on the FixDescriptions.txt script.
'''2/27/17'''
Christy: The pickle library is vital and we should remember to use it when we use black boxish libraries like the sklearn classifier.
