Difference between revisions of "Yi Ma"
| (46 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=YiMaPic.jpg | |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= | + | |Has skills=SQL, Linux, STATA |
|Has email=ym433@georgetown.edu | |Has email=ym433@georgetown.edu | ||
}} | }} | ||
| + | =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
| Student | |
|---|---|
| Yi Ma | |
| Information | |
| Status | Active |
| Degree | Master |
| Major | Economics |
| Skills (Students only) | SQL, Linux, STATA |
| 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
