Meghana Gaur
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
Past Projects:
Rand Paul's page, Entrepreneurship and Innovation issue page, Religious Issue Page, Carried Interest, Introduction to Ed's Speech, Candidates stances on regulation, collected information for the regulations page for Ed's speech (regulations that harm small businesses (primarily EPA regulations))
- U.S. Policy towards Entrepreneurship and Innovation page : collecting information on legislation/bills pertaining to Entrepreneurship/Innovation
In progress:
- Patent Reform Acts (writing a summary on the 5 pieces of legislation relating to patents)
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.
