Difference between revisions of "Meghana Gaur"
imported>Meghana |
imported>Carlin |
||
Line 19: | Line 19: | ||
*'''Work log''': | *'''Work log''': | ||
+ | {{:Meghana Gaur (Work Log)}} |
Revision as of 16:23, 10 February 2016
Name: Meghana Gaur
Major: Mathematical Economic Analysis, Minor in Politics, Law, and Social Thought, Pre-Law
Year: Freshman, Class of 2019
College: Lovett
Contact:
- Email: mg62@rice.edu
- Phone: 512-739-7105
- Facebook, Slack
Current projects:
- Presidential Candidate Platforms
- TBD (something with policy)
- Work log:
Meghana Gaur Work Logs (log page)
2017-12-1: worked with ed to build tables with firm/portco data on distance and fund/portco data on performance
2017-11-16: finished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table)
2017-11-14: worked on getting all roundline tables down to the firm level, instead of fund; running into small problems with calculating gcd between firms and portco's (will discuss with Ed)
2017-11-14: worked on joining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)
2017-11-09: reloaded firm coords and also fund coords - re-building roundlinewithgcd (code is written, but fund coords weren't correctly loaded, so this code will be re-run), wrote code for fundtofirms and portcotofirms, but this code will be re-run once the firm codes are correctly loaded; working on joining portcoexitmaster to roundlinejoinerlean
2017-11-08: loaded roundlinewithgcd table (calculating gcd between portcos and funds), created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on building portcostofirms
2017-11-07: loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining funds to firms
2017-11-03: loaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; joined coordinates to all clean base tables for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in new table: roundlinecoords
2017-11-02: met with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates
2017-10-27: come up with next steps for matching firms to funds - for geocoding branch offices
2017-10-26: update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed
2017-10-24: met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms from both firmbasecore and bocore
2017-10-12: peer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project; continue literature review for matching models
2017-10-11: finished loading tables (firmbase and branchoffice)
2017-10-6: load data using SQL code into tables, which is on Retrieving US VC Data From SDC
2017-09-29: completed pulling/normalizing data, still need to load data using SQL code into tables, which is on Retrieving US VC Data From SDC
2017-09-28: met with Ed, worked on pulling firm and branch office data from SDC
2017-09-22: join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."
2017-09-21: work with Ed on research project
2017-09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management
2017-09-15: work on joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to VC's project folder" on E drive.
2017-09-14: build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)
2017-09-27: rebuild portcoexits and work on apportioning amounts in roundlinejoiner
2017-09-07: work with Ed to familiarize with SQL script for VC project/vcdb2 database
2017-09-05: receive project from Ed; reacquaint with wiki, RDP, etc.