Seed Accelerator Data Assembly - Revision history

GraceTan: /* prioritycodecategory.py */

2018-08-03T21:28:45Z

prioritycodecategory.py

2018-08-03T21:27:49Z

codecategory.py

2018-08-03T21:27:08Z

codecategory.py

2018-08-03T21:17:47Z

prioritycodecategory.py

2018-08-03T21:17:28Z

prioritycodecategory.py

2018-08-03T21:13:30Z

format_timing.py

2018-08-03T21:10:45Z

format_timing.py

2018-08-03T21:06:47Z

2018-08-02T20:45:40Z

Data assembly details

2018-08-02T18:24:23Z

Data assembly details

@@ Line 330: / Line 330: @@
    E:/McNair/Projects/Accelerators/Summer 2018/prioritycodecategory.py
-Input: txt file with a list of category groups
+Input: txt file with a list of category groups (Column Y of Cohorts Final in The File to Rule Them All)
 Output: txt file with line number and minor code
-Final output: I took the txt file and copied the codes and pasted it into column Z of the Cohorts Final sheet from The File to Rule Them All.
+Final output: I took the txt file and copied the codes and pasted it into the added column Z of the Cohorts Final sheet from The File to Rule Them All.
    E:/McNair/Projects/Accelerators/Summer 2018/Cohorts Final - minor code priority Grace.xlsx

← Older revision		Revision as of 21:27, 3 August 2018
Line 350:		Line 350:
	E:/McNair/Projects/Accelerators/Summer 2018/Cohorts Final - minor code (no priority) Grace.xlsx		E:/McNair/Projects/Accelerators/Summer 2018/Cohorts Final - minor code (no priority) Grace.xlsx

−	I arbitrarily chose the first code when multiple were given. I fixed this in excel by separating on commas.	+	I arbitrarily chose the first code when multiple were given. I fixed this in excel by separating on commas. I also manually did a lot of them which is why there are mode values in this file than the one with priority.

← Older revision		Revision as of 21:27, 3 August 2018
Line 340:		Line 340:

	===codecategory.py===		===codecategory.py===
		+	E:/McNair/Projects/Accelerators/Summer 2018/codecategory.py
		+
		+	Input: txt file with a list of category groups (column Y of Cohorts Final in The File to Rule Them All)
		+
		+	Output: txt file with line number and multiple minor codes
		+
		+	Final output: I took the minor codes and copied them into column Z of this sheet (a copy of The File to Rule Them All with this added column)
		+
		+	E:/McNair/Projects/Accelerators/Summer 2018/Cohorts Final - minor code (no priority) Grace.xlsx
		+
		+	I arbitrarily chose the first code when multiple were given. I fixed this in excel by separating on commas.

← Older revision		Revision as of 21:17, 3 August 2018
Line 331:		Line 331:

	Input: txt file with a list of category groups		Input: txt file with a list of category groups
		+
	Output: txt file with line number and minor code		Output: txt file with line number and minor code

← Older revision		Revision as of 21:17, 3 August 2018
Line 328:		Line 328:

	===prioritycodecategory.py===		===prioritycodecategory.py===
		+	E:/McNair/Projects/Accelerators/Summer 2018/prioritycodecategory.py
		+
		+	Input: txt file with a list of category groups
		+	Output: txt file with line number and minor code
		+
		+	Final output: I took the txt file and copied the codes and pasted it into column Z of the Cohorts Final sheet from The File to Rule Them All.
		+	E:/McNair/Projects/Accelerators/Summer 2018/Cohorts Final - minor code priority Grace.xlsx
		+
		+	Chooses code based on important from priority ranking dictionary before choosing arbitrarily.

	===codecategory.py===		===codecategory.py===

← Older revision		Revision as of 21:13, 3 August 2018
Line 324:		Line 324:

	Input: a txt file with accelerator mapped to multiple companies(in a single cell separated by columns or in separate rows)		Input: a txt file with accelerator mapped to multiple companies(in a single cell separated by columns or in separate rows)
		+
	Output: txt file with companies mapped to accelerators with all the other information in the original file		Output: txt file with companies mapped to accelerators with all the other information in the original file

@@ Line 321: / Line 321: @@
 ==Grace's Code==
 ===format_timing.py===
 ===prioritycodecategory.py===
 ===codecategory.py===

@@ Line 210: / Line 210: @@
 Grace:
 *Process and Join in new timing data - new date located in Z:/accelerator/Formatted Timing Info.txt
-*Make a category group to minorcode lookup
+*Make a category group to minorcode lookup - in E:/McNair/Projects/Accelerators/Summer 2018/Cohorts Final - minor code priority Grace.xlsx
-*Run WHOIS crawler on all valid URLs (not facebook pages, etc.)
+*Run WHOIS crawler on all valid URLs (not facebook pages, etc.) - Maxine did this
-*Founders Experience: Match Employers to VC funds/firms, VC backed startups (requires data from Augi)
+*Founders Experience: Match Employers to VC funds/firms, VC backed startups (requires data from Augi) - added 2 columns to The File to Rule Them All (VC and VC start up)
 ==Accelerator Data Assembly Progress (Hira) ==
@@ Line 317: / Line 317: @@
 ) timing_combined - This table combines all timing information we have and appends tables 4, 7 and 8.
 ) cohortcompanies_wtiming - merges data in tables cohortcompany and timing_combined

← Older revision		Revision as of 20:45, 2 August 2018
Line 305:		Line 305:

	7) additional_timing_info - source file: "merging_work.xlxs" located in: E:\Projects\McNair\Seed DB		7) additional_timing_info - source file: "merging_work.xlxs" located in: E:\Projects\McNair\Seed DB
		+	8) additional_timing_info2 - source file: "formatted timing info2.txt" located in E:\Projects\McNair\Accelerators\Summer 2018. This was collected through MTurks.
		+	Tables 7 and 8 include columns:
		+	*coname
		+	*acceleratorname
		+	*cohort_name
		+	*date
		+	*month
		+	*year
		+	*season
		+
		+	9) timing_combined - This table combines all timing information we have and appends tables 4, 7 and 8.
		+	10) cohortcompanies_wtiming - merges data in tables cohortcompany and timing_combined

← Older revision		Revision as of 18:24, 2 August 2018
Line 303:		Line 303:
	*Location		*Location
	*Extra_Description		*Extra_Description
		+
		+	7) additional_timing_info - source file: "merging_work.xlxs" located in: E:\Projects\McNair\Seed DB