Difference between revisions of "Yi Ma"

From edegan.com
Jump to navigation Jump to search
 
(50 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{Team Member
 
{{Team Member
 +
|Went to school=Georgetown
 +
|Has team sponsor=Kauffman Incubator Project
 
|Has name=Yi Ma
 
|Has name=Yi Ma
|Has headshot=[[File:YiMaPic.jpg|200px|thumb|center|alt text]]
+
|Has headshot=YiMaPic.jpg
 +
|Has team position=Student
 +
|Has job title=Researcher
 
|Has team status=Active
 
|Has team status=Active
 +
|Has or doing degree=Master
 
|Has academic major=Economics
 
|Has academic major=Economics
|Has skills=Microsoft Office Package, Stata, R, SQL, Unix, Linux
+
|Has skills=SQL, Linux, STATA
 
|Has email=ym433@georgetown.edu
 
|Has email=ym433@georgetown.edu
 
}}
 
}}
Currently working for [[http://www.edegan.com/wiki/Ed_Egan]]
+
 
 +
=Introduction=
 +
Currently working for [[Ed Egan]] on [[Projects | The Incubator Project]] including [[Incubators_in_Five_Ecosystems | Five Ecosystems]].
 +
 
 +
Check my shift [[Administration | 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]]

Latest revision as of 12:32, 30 September 2020

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