Ecosystem Organization Classifier - Revision history

Ed at 17:41, 21 September 2020

2020-09-21T17:41:42Z

2020-09-21T17:34:17Z

2020-09-20T16:29:11Z

2019-10-05T01:29:47Z

2019-04-10T01:48:30Z

Process Notes for Calculating Incubator Scores

2019-04-10T01:46:54Z

Process Notes for Calculating Incubator Scores

2019-04-10T01:10:54Z

Incubator Scores of Crunchbase Results

2019-04-05T19:28:06Z

Process Notes for Calculating Incubator Scores

2019-04-05T19:16:08Z

Process Notes for Calculating Incubator Scores

2019-04-05T19:15:14Z

Incubator Scores of Crunchbase Results

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data
 |Has sponsor=Kauffman Incubator Project
 |Has title=Ecosystem Organization Classifier

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=Kauffman Incubator Project
 |Has title=Ecosystem Organization Classifier

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=Ecosystem Organization Classifier
 |Has owner=Libby Bassini, Anne Freeman,

@@ Line 9: / Line 9: @@
 The purpose of this project is to build a classifier, which takes the description of an ecosystem organization (i.e., a startup, a venture capitalist, an incubator, etc.) and either correctly classifies the organization's type or correctly classifies incubators vs. non-incubators.
 ===Text Processing===
@@ Line 29: / Line 37: @@
 We can use [[The Matcher (Tool)]] to match organization names to portfolio companies and VC funds and firms taken from '''vcdb3''' (see [[VentureXpert Database]]). We will also search this data by hand for incubators to get an initial set. Later on, we'll match our early list of incubators to crunchbase organization names to expand our list.
 ==Incubator Scores of Crunchbase Results==

@@ Line 77: / Line 77: @@
   --466
-  \COPY (SELECT A.uuid, A.company_name, B.description FROM Organizations AS A JOIN organization_descriptions AS B on A.uuid=B.uuid WHERE country_code='USA' AND description LIKE '%incubat%') TO 'CrunchbaseLongOrgDescsUSAIncub.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
+  \COPY (SELECT A.uuid, A.company_name, B.description FROM Organizations AS A JOIN organization_descriptions AS B on A.uuid=B.uuid WHERE country_code='USA' AND description LIKE '%incubat%') TO 'CrunchbaseLongOrgDescsUSAIncubat.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
   --933

← Older revision		Revision as of 01:46, 10 April 2019
Line 71:		Line 71:

	==Process Notes for Calculating Incubator Scores==		==Process Notes for Calculating Incubator Scores==
		+
		+	Two new files were generated from the '''crunchbase3''' dbase as follows:
		+
		+	\COPY (SELECT uuid, company_name, short_description FROM Organizations WHERE country_code='USA' AND short_description LIKE '%incubat%') TO 'CrunchbaseShortOrgDescsUSAIncubat.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
		+	--466
		+
		+	\COPY (SELECT A.uuid, A.company_name, B.description FROM Organizations AS A JOIN organization_descriptions AS B on A.uuid=B.uuid WHERE country_code='USA' AND description LIKE '%incubat%') TO 'CrunchbaseLongOrgDescsUSAIncub.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
		+	--933
		+
		+	These files were put in E:\projects\crunchbase3.

	1. New file - Renamed E:\projects\crunchbase3\organizations as E:\projects\crunchbase3\organizations_OnlyIncubators_PlusIncubatorScores		1. New file - Renamed E:\projects\crunchbase3\organizations as E:\projects\crunchbase3\organizations_OnlyIncubators_PlusIncubatorScores

@@ Line 54: / Line 54: @@
 ! style="width: 9%" | Formal Application Process [Y - 0 /N - 1]
 ! style="width: 9%" | Incubator Score out of 4
 |-
+|

@@ Line 79: / Line 79: @@
 . New Columns - 1. #; 2. Company with URL to page linked; 3. Self-Identified Incubator [Y/N]; 4. State; 5. City; 6. Region; 7. Lists Client Companies [Y/N] with URL linked; 8. Fixed Duration [Y - 0 /N - 1]: (Startups at an incubator generally do not all stay for the same fixed duration; Incubator does not have a fixed graduation date for its startups or has a program that lasts longer than one year); 9. Incubator Investment [Y - 0 /N - 1]: (Incubator does not invest directly in the company or take equity in its startups); 10. Cohorts [Y - 0 /N - 1]: Incubator does not have limited-duration programs that ventures enter and exit in groups, known as cohorts or batches.; 11.  Formal Application Process [Y - 0 /N - 1]: (Selective, competitive admissions process; Fixed, not rolling application process); 12. Incubator Score out of 4 (A score of 4 is most likely to be an incubator and a score of 0 is less likely to be an incubator based on our baseline attributes for an incubator [[Defining Incubators]])
-. Deleted Columns - funding_rounds; roles; permalink; domain;
+. Deleted Columns - funding_rounds; roles; permalink; domain; funding rounds
 . Delete Closed Incubators - Filtered 'status' column to exclude showing results that are 'closed'

@@ Line 48: / Line 48: @@
 ! style="width: 9%" | City
 ! style="width: 7%" | Region
 ! style="width: 9%" | Fixed Duration [Y - 0 /N - 1]
 ! style="width: 5%" | Incubator Investment [Y - 0 /N - 1]