Yi Ma

From edegan.com
Jump to navigation Jump to search
Team Member
Student
Yi Ma
YiMaPic.jpg
Information
Status Active
Degree Master
Major Economics
Skills (Students only) SQL, Linux, STATA
Email ym433@georgetown.edu
Projects Ecosystem: Austin TX, US Incubators
School Georgetown
Job Title Researcher
Sponsor Kauffman Incubator Project
Copyright © 2019 edegan.com. All Rights Reserved.


Introduction

Currently working for Ed Egan on The Incubator Project including Five Ecosystems.

Check my shift here.

Feel free to reach out to me on Slack.

Current Projects

1. Manually classify the Crunchbase Database with Libby Bassini

2. Assemble a near-population dataset on US Incubators using Incubator Seed Data

Progress Update

(5/15/19)

Expanding regional data sources for US Incubators

Subtracting incubators using unique uuid from Crunchbase Database

Retrieving incubators from crunchbase database using incubator uuid

1. Create a file of uuids of incubators

2. Load the file into the database

3. Run a query that joins uuids with related fields


(5/1/19)

Finished compiling national and regional data. See US Incubators for more info

(4/23/19)

Working on extracting incubator data from page source using regular expression

  • File Location:
E:\projects\Kauffman Incubator Project\01 Classify entrepreneurship ecosystem organizations\YiMaResearch\US Incubators

(4/16/19)

Worked on Ecosystem Organization Classifier

1. Matched the organizations data with "The File to Rule Them All" to remove potential accelerators in the list

2. Finished manually going through the incubators for the first round

3. Working on assigning scores to incubators

  • File Location:
E:\projects\crunchbase3\CrunchbaseShortOrgDescsSAIncubat_IncubatorScore

Useful Links

Working with PostgreSQL

Regular Expression Cheat Sheet