Changes

7,818 bytes added , 18:28, 28 November 2017

~~[[Category:Work Log]]~~===Fall 2017===<onlyinclude>

[[Ben Baldazo]] [[Work Logs]] [[Ben Baldazo (Work Log) | (Work Log)]]

=contributing Projects=

[[Crunchbase Data]] / [[Accelerator Seed List (Data)]] : Combined this data in a table discussed on [[Crunchbase Data#Funded by Accelerators|Crunchbase Data]]

[[Houston Innovation District]]

[[Augusta Startup Ecosystem]]

[[Houston Entrepreneurship Ecosystem Project]]

[[Houston Entrepreneurship]]

[[Start-Up Guide (Issue Brief)]]

[[Houston Accelerators and Incubators (Report)]]

[[Cofounding in Exchange for Equity]]

[[Start-Ups of Houston (Map)]]

=worklog=

'''2017-11-21:''' Worked with Ed to set up all of the ground work to begin joining tables for the purpose stated in yesterday's work log. Should be able to finish it upon returning next week, but until then, notes are all held within "Z:\bulk\crunchbase\AccFunding.psql" with the important parts under the header of "From Ed on 21st of Nov. To finish on Nov 27"

'''2017-11-20:''' Attempting to link 3 tables from psql crunchbasebulk to find accelerators that have invested in companies. Likely found success with the table "Acc_Funded_Cos" but the investor column is dirty, thus trying to do it cleaner with the aforementioned 3 table link

*This is all noted in "Z:\bulk\crunchbase\AccFunding.psql" and the code for "Acc_Funded_Cos" is emphasized

'''2017-09-25:''' Followed [[Talk:Ben Baldazo (Work Log)]] to create documentation infrastructure for [[Augusta Startup Ecosystem]]

</onlyinclude>

===Spring 2017===

*4/24/2017 9:30am-11:30am

*4/19/2017 2:00 - 4:00pm

*4/17/2017 2:00pm - 4:00pm

*4/12/2017 3:00pm - 5:30pm

*4/10/2017 2:00pm - 5:30pm

**Created some of the missing cohort files for the accelerator project

**Created PotentialAccelerators.txt in 'E:\McNair\Projects\Accelerators\Crunchbase Snapshot'

***Used Organizations.csv from crunchbase and matched on "accel" "startup" and "mentor" asking that "accel" and at least one of the other two be included in the description of the organization

*4/05/2017 2:00pm - 6:00pm

**Finished code to create a percentage of VC backed marker per accelerators

**Looked over duplicates from VC data matched to Cohort Data

*4/03/2017 2:00pm - 4:00pm

**Worked with duplicates in Matches between Accelerator Cohorts and All VC data for Accelerators project. Notated what the duplicates mean

**helped teach SQL

*3/29/2017 2:00pm-5:15pm

**Filtered websites for Accelerator project using regex code

*3/22/2017 2:00pm - 5:30pm

**Began Join tables in "accelerator" database in order to find "PercentVC" amount per accelerator

*3/20/2017 2:00pm - 5:40pm

**Taught PSQL and went over future expectations for [[Houston Entrepreneurship]] page

*3/8/2017 2:00pm-5:30pm

**Ran matches between VC Data and PortCos for the Accelerator Project

*3/6/2017 2:00pm-3:00pm

**Cleaned data from VC Data and PortCos

*3/3/2017 1:00pm-4:00pm

**Refined data in E:\McNair\Projects\Accelerators\VC_Data_Repeated_Down.txt

*3/1/2017 2:00pm-5:00pm

**Worked with the Accelerators project

*2/27/2017 3:30-5:30

**Cleaned and reuploaded data to [[Start-Up Guide (Issue Brief)]]

**Worked on editing [https://docs.google.com/document/d/1RwXuZmB6gKxgOlyoco0dTigIZ0xf185dwDgLZnVTvgY/edit?ts=58867bd0 Houston Issue Brief]

*2/22/2017 2:00pm-5:00pm

**Taught SDC and normalizer. Updated [[Normalizer Documentation]]

*2/20/2017 2:00pm-5:30pm