Yi Ma

Team Member

Student
Yi Ma
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