Changes

<font size="5">'''==Fall 2016'''2017===</fontonlyinclude>

09/27/2016 15:00-18:00: Set up Staff wiki page, work [[Peter Jalbert]] [[Work Logs]] [[Peter Jalbert (Work Log)|(log page; registered for Slack, Microsoft Remote Desktop; downloaded Selenium on personal computer, read Selenium docs. Created wiki page for Moroccan Web Driver Project.)]]

09/29/2016 15:002017-12-18:0021: Re-enroll in Microsoft Remote Desktop with proper authentication, set up Selenium environment and Komodo IDE on Remote Desktop, wrote program using Selenium that goes Last minute adjustments to a link and opens up the print dialog boxMoroccan Data. Developed computational recipe for a different approach to the problemContinued working on [[Selenium Documentation]].

09/30/2016 2017-12:00-14:0020: Working on Selenium program selects view pdf option from the website, and goes to the pdf webpageDocumentation. Program then switches handle to the new pageWrote 2 demo files. CTRL S Wiki Page is sent to the page to launch save dialog windowavaiable [http://www. Text cannot be sent to this windowedegan. Brainstorm ways around this issuecom/wiki/Selenium_Documentation here]. Explored Chrome Options Created 3 spreadsheets for saving automatically without a dialog window. Looking into other libraries besides selenium that may helpthe Moroccan data.

10/3/2016 13:00 2017-12- 16:0019: Moroccan Web Driver projects completed for driving of Finished fixing the Monarchy proposed bills, the House of Representatives proposed bills, and the Ratified bills sitesDemo Day Crawler. Begun process of devising a naming system for the Changed files that does not require scraping. Tinkered with naming through regular expression parsing of the URL. Structure for the oral questions and written questions drivers is set up, but need fixes due installed as appropriate to the differences make linked in crawler compatible with the sitesRDP. Fixed bug on McNair wiki for women's biz team where email was plain text instead Removed some of an email link. Took a glimpse at Kuwait Parliament website, the bells and it appears to be very different from the Moroccan setupwhistles.

10/6/2016 13:30 2017-12- 18:00: Discussed Continued finding errors with Drthe Demo Day Crawler analysis. Elbadawy about Rewrote the desired file names for Moroccan data download. The consensus was parser to remove any search terms that were in the bill programs are ready top 10000 most common English words according to launch once the files can be named properly, Google. Finished uploading and the questions submitting Moroccan data must be retrieved using a web crawler which I need to learn how to implement. The naming of files is currently drawing errors in going from arabic, to url, to download, to filename. Debugging in process. Also built a demo selenium program for Dr. Egan that drives the McNair blog site on an infinite loop.

10/7/2016 2017-12:00 - 14:0015: Learned unicode and utf8 encoding and decoding in arabicFound errors with the Demo Day Crawler. Still working on transforming an ascii url into printable unicodeFixed scripts to download Moroccan Law Data.

10/11/2016 15:00 2017-12- 18:0014: Fixed arabic bug, files can now be saved with arabic titles. Monarchy bills downloaded and ready for shipmentUploading Morocco Parliament Written Questions. House of Representatives Bill mostly downloaded, ratified bills prepared Creating script for next Morocco Parliament download. Started learning scrapy library in python for web scrapingBegin writing Selenium documentation. Discussed idea of screenshot-ing questions instead of scrapingContinuing to download TIGER data.

10/13/2016 13:002017-12-1806:00: Completed download of Moroccan Bills. Working on either a web driver screenshot approach or a webcrawler approach to download the Moroccan oral and written questions data. Began building Web Crawler for Oral and Running Morocco Parliament Written Questions sitescript. Edited Moroccan Web Driver/Analyzing Demo Day Crawler wiki pageresults. [http://mcnair.bakerinstituteContinued downloading for TIGER geocoder.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web Driver]

10/14/2016 12:002017-11-1428:00: Finished Oral Questions crawlerDebugging Morocco Parliament Crawler. Finished Written Questions crawlerRunning Demo Day Crawler for all accelerators and 10 pages per accelerator. Waiting for further details on whether that data needs TIGER geocoder is back to be tweaked in any way. Updated the Moroccan Web Driver/Web Crawler wiki page. [http://mcnair.bakerinstituteForbidden Error.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web Driver]

10/18/2016 15:002017-11-1827:30: Finished code for Oral Questions web driver Rerunning Morocco Parliament Crawler. Fixed KeyTerms.py and Written Questions web driver using seleniumrunning it again. Now, the data Continued downloading for the dates of questions can be found using the crawler, and the pdfs of the questions will be downloaded using selenium. [http://mcnair.bakerinstituteTIGER geocoder.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web Driver]

10/2017-11-20/2016 13:00-18:00: Continued to download data for the Moroccan Parliament Written and Oral Questions. Updated Wiki page. Started working on Twitter project with Christy. running [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web DriverDemo_Day_Page_Parser Demo Day Page Parser]. Fixed KeyTerms.py and trying to run it again. Forbidden Error continues with the TIGER Geocoder. Began Image download for Image Classification on cohort pages. Clarifying specs for Morocco Parliament crawler.

10/21/2016 12:002017-11-14:0016: Continued to download data for the Moroccan Parliament Written and Oral Questions. Looked over running [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Christy_Warden_(Twitter_Crawler_Application_1) Christy's Twitter CrawlerDemo_Day_Page_Parser Demo Day Page Parser] to see how I can be helpful. DrFixed KeyTerms. Egan asked me to think about how to potentially make multiple tools py and trying to get cohorts and other sorts of data from accelerator sitesrun it again. See [http://mcnair.bakerinstitute.org/wiki/Accelerator_Seed_List_(Data) Accelerator List] He also asked me to look at Forbidden Error continues with the [http://mcnairTIGER Geocoder.bakerinstituteBegan Image download for Image Classification on cohort pages.org/wiki/Govtrack_Webcrawler_(Wiki_Page) GovTrack Web Crawler] Clarifying specs for potential ideas on how to bring this project to fruitionMorocco Parliament crawler.

2017-11/1/2016: -15:00-18Continued running [http:00: Continued //www.edegan.com/wiki/Demo_Day_Page_Parser Demo Day Page Parser]. Wrote a script to download Moroccan data in the backgroundextract counts that were greater than 2 from Keyword Matcher. Went over code Continued downloading for GovTracker Web Crawler, continued learning Perl. [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Govtrack_Webcrawler_(Wiki_Page) GovTrack Web CrawlerTiger_Geocoder TIGER Geocoder] Began Kuwait Web Crawler/Driver. Finished re-formatting work logs.

2017-11/3/2016: 13:00-1814:00Continued running [http: Continued ///www.edegan.com/wiki/Demo_Day_Page_Parser Demo Day Page Parser]. Wrote an HTML to download Moroccan data in the backgroundText parser. See Parser Demo Day Page for file location. DrContinued downloading for [http://www. Egan fixed systems requirements to run the GovTrack Web Crawleredegan. Made significant progress on the Kuwait Web Crawlercom/Driver for the Middle East Studies Departmentwiki/Tiger_Geocoder TIGER Geocoder].

2017-11/4/2016: 12:00-1413:00: Continued to download Moroccan data in the background. Finished writing initial Kuwait Web Crawler/Driver for the Middle East Studies Department. Middle East Studies Department asked for additional embedded files in the Kuwait website. Built [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web DriverDemo_Day_Page_Parser Demo Day Page Parser].

2017-11/8/2016: 15:00-1809:00: Continued to download Moroccan data in the backgroundRunning demo version of Demo Day crawler (Accelerator Google Crawler). Finished writing code for the embedded files on the Kuwait Site. Spent time debugging the frame errors due to the dynamically generated content. Never found an answer to the bug, and instead found a workaround that sacrificed run time for the ability to Fixing worklog format. [http://mcnair.bakerinstitute.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web Driver]

2017-11/10/2016 13:00-1807:00: Continued to download Moroccan data Created file with 0s and Kuwait data in 1s detailing whether crunchbase has the backgroundfounder information for an accelerator. Began work Details posted as a TODO on [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Google_Scholar_Crawler Google Scholar CrawlerAccelerator_Seed_List_(Data) Accelerator Seed List]page. Wrote a crawler Still waiting for feedback on the PostGIS installation from [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) Accelerator ProjectTiger_Geocoder Tiger Geocoder] to get the HTML files of hundreds of accelerators. The crawler ended up failing; it appears to have been due to HTTPSContinued working on Accelerator Google Crawler.

2017-11/11/2016 12:00-206:00Contacted Geography Center for the US Census Bureau, [https: Continued to download Moroccan data in the background//www.census.gov/geo/about/contact.html here], and began email exchange on PostGIS installation problems. Attempted to find bug fixes for Began working on the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) Selenium_Documentation Selenium Documentation]. Also began working on an Accelerator Project] crawlerGoogle Crawler that will be used with Yang and ML to find Demo Days for cohort companies.

2017-11/15/2016 15:00-1801:00Attempted to continue downloading, however ran into HTTP Forbidden errors. Listed the errors on the [http: Finished download of Moroccan Written Question pdfs//www. Wrote a parser with Christy to be used for parsing bills from Congress and eventually executive ordersedegan. Found bug in the system Python that was worked out and rebootedcom/wiki/Tiger_Geocoder Tiger Geocoder Page].

11/17/2016 13:002017-10-1831:00: Wrote a crawler to retrieve information about executive orders, and their corresponding pdfs. They can be found Began downloading blocks of data for individual states for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/E%26I_Governance_Policy_Report hereTiger_Geocoder Tiger Geocoder] project.] Next step is to run code to convert Wrote out the pdfs new wiki page for installation, and beginning to text files, then use the parser fixed by Christywrite documentation on usage.

11/18/2016 12:002017-10-2:0030: Converted Executive Order PDFs With Ed's help, was able to text files using adobe acrobat DCget the national data from Tiger installed onto a database server. See The process required much jumping around and changing users, and all the things we learned are outlined in [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/E%26I_Governance_Policy_Report WikipageDatabase_Server_Documentation#Editing_Users the database server documentation] for detailsunder "Editing Users".

11/22/2016 15:002017-10-1825:00: Transferred downloaded Morocco Written Bills to provided SeaGate Drive. Made a "gentle" F6S crawler to retrieve HTMLs of possible accelerator pages documented Continued working on the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) herePostGIS_Installation TigerCoder Installation].

11/29/2016 15:002017-10-1824:00: Began pulling data from Throw some addresses into a database, use address normalizer and geocoder. May need to install things. Details on the installation process can be found on the accelerators listed [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) herePostGIS_Installation PostGIS Installation page]. Made text files for about 18 accelerators.

12/1/2016 13:002017-10-18:0023: Continued making text files Finished Yelp crawler for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]. Built tool for the [http://mcnair.bakerinstitute.org/wiki/E%26I_Governance_Policy_Report E&I Governance Report Houston_Innovation_District Houston Innovation District Project] with Christy. Adds a column of data that shows whether or not the bill has been passed.

12/2/2016 12:002017-10-1419:00: Built and ran web Continued work on Yelp crawler for Center for Middle East Studies on Kuwait. Continued making text files for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List projectHouston_Innovation_District Houston Innovation District Project].

12/6/2016 15:002017-10-18:00: Learned how to use git. Committed software projects from the semester to the McNair git repository. Projects can be found at; [http://mcnair.bakerinstitute.org/wiki/E%26I_Governance_Policy_Report Executive Order Crawler], [http://mcnair.bakerinstitute.org/wiki/Moroccan_Parliament_Web_Crawler Foreign Government Web Crawlers], Continued work on Yelp crawler for [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) F6S Crawler and ParserHouston_Innovation_DistrictHouston Innovation District Project].

12/7/2016 15:002017-10-1817:00: Continued making text files Constructed ArcGIS maps for the agglomeration project. Finished maps of points for every year in the [http://mcnairstate of California.bakerinstituteFinished maps of Route 128.org/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]Began working on selenium Yelp crawler to get cafe locations within the 610-loop.

12/8/2016 14:002017-10-1816:00: Continued making text files for Assisted Harrison on the [http://mcnairUSITC project.bakerinstituteLooked for natural language processing tools to extract complaintants and defendants along with their location from case files.org/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]Experimented with pulling based on parts of speech tags, as well as using geotext or geograpy to pull locations from a case segment.

<font size="5">'''Spring 2017'''</font>-10-12: Continued work on Patent Thicket project, awaiting further project specs.

1/2017-10/2017 14:30-17:1504: Continued making text files Emergency ArcGIS creation for the [http://mcnair.bakerinstitute.org/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List Agglomeration project]. Downloaded pdfs in the background for the [http://mcnair.bakerinstitute.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project].

1/11/2017 -10:00-12:00: Continued making text files for the [http02://mcnair.bakerinstituteWorked on ArcGIS data.org/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]. Downloaded pdfs in the background See Harrison's Work Log for the [http://mcnair.bakerinstitute.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project]details.

1/12/2017 14:30-17:45: Continued making text files for the [http://mcnair.bakerinstitute.org/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]. Downloaded pdfs in the background for the [http09-28://mcnair.bakerinstitute.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project]Added collaborative editing feature to PyCharm.

1/17/2017 14:30-17:15: Continued making text files for the [http://mcnair.bakerinstitute.org/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]. Downloaded pdfs in the background for the [http09-27://mcnair.bakerinstitute.org/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project]Worked on big database file.

12017-09-25: New task -- Create text file with company, description, and company type.#[http://www.edegan.com/wiki/VC_Database_Rebuild VC Database Rebuild]#psql vcdb2#table name, sdccompanybasecore2#Combine with Crunchbasebulk #TODO: Write wiki on linkedin crawler, write wiki on creating accounts. 2017-09-21: Wrote wiki on Linkedin crawler, met with Laura about patents project.  2017-09-20: Finished running linkedin crawler. Transferred data to RDP. Will write wikis next. 2017-09-19: Began running linkedin crawler. Helped Yang create RDP account, get permissions, and get wiki setup. 2017-09-18: Finished implementation of Experience Crawler, continued working on Education Crawler for LinkedIn. 2017-09-14: Continued implementing LinkedIn Crawler for profiles. 2017-09-13: Implemented LinkedIn Crawler for main portion of profiles. Began working on crawling Experience section of profiles. 2017-09-12: Continued working on the [http://www.edegan.com/wiki/LinkedIn_Crawler_(Python) LinkedIn Crawler for Accelerator Founders Data]. Added to the wiki on this topic. 2017 10-09-11: Continued working on the [http:00//www.edegan.com/wiki/LinkedIn_Crawler_(Python) LinkedIn Crawler for Accelerator Founders Data].  2017-1209-06: Combined founders data retrieved with the Crunchbase API with the crunchbasebulk data to get linkedin urls for different accelerator founders. For more information, see [http://www.edegan.com/wiki/Crunchbase_Data here]. 2017-09-05: Post Harvey. Finished retrieving names from the Crunchbase API on founders. Next step is to query crunchbase bulk database to get linkedin urls. For more information, see [http://www.edegan.com/wiki/Crunchbase_Data here]. 2017-08-24:00Began using the Crunchbase API to retrieve founder information for accelerators. Halfway through compiling a dictionary that translates accelerator names into proper Crunchbase API URLs. 2017-08-23: Downloaded pdfs Decided with Ed to abandon LinkedIn crawling to retrieve accelerator founder data, and instead use crunchbase. Spent the day navigating the crunchbasebulk database, and seeing what useful information was contained in it. 2017-08-22: Discovered that LinkedIn Profiles cannot be viewed through LinkedIn if the target is 3rd degree or further. However, if entering LinkedIn through a Google search, the profile can still be viewed if the user has previously logged into LinkedIn. Devising a workaround crawler that utilizes Google search. Continued blog post [http://www.edegan.com/wiki/LinkedIn_Crawler_(Python) here] under Section 4. 2017-08-21: Began work on extracting founders for accelerators through LinkedIn Crawler. Discovered that Python3 is not installed on RDP, so the virtual environment for the project cannot be fired up. Continued working on Ubuntu machine.</onlyinclude> ===Spring 2017=== 2017-05-01: Continued work on HTML Parser. Uploaded all semester projects to git server. 2017-04-20: Finished the background HTML Parser for the [http://mcnairwww.edegan.com/wiki/LinkedIn_Crawler_(Python) LinkedIn Crawler]. Ran HTML parser on accelerator founders. Data is stored in projects/accelerators/LinkedIn Founder Data. 2017-04-19: Made updates to the [http://www.bakerinstituteedegan.orgcom/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government LinkedIn_Crawler_(Python) LinkedIn Crawler Project]Wikipage. Ran LinkedIn Crawler on accelerator data. Working on an html parser for the results from the LinkedIn Crawler. 2017-04-18: Ran LinkedIn Crawler on matches between Crunchbase Snapshot and the accelerator data.

1/19/2017 14:30-04- 17:45: Downloaded pdfs in the background for Worked on ways to get correct search results from the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government LinkedIn_Crawler_(Python) LinkedIn Crawler Project]. Created parser Worked on an HTML Parser for the [http://mcnair.bakerinstitute.org/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project], completed creation of final data set(yay!). Began working on cohort parserresults from the LinkedIn Crawler.

1/23/2017 10:00-12:0004-13: Worked on parser debugging the logout procedure for cohort data of the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_LinkedIn_Crawler_(DataPython) Accelerator Seed List projectLinkedIn Crawler]. Preliminary code is written, working on debuggingBegan formulation of process to search for founders of startups using a combination of the LinkedIn Crawler with the data resources from the [http://www.edegan.com/wiki/Crunchbase_2013_Snapshot CrunchBase Snapshot].

1/24/2017 14:30-1704-12:15: Worked Work on parser for cohort data of bugs with the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_LinkedIn_Crawler_(DataPython) Accelerator Seed List projectLinkedIn Crawler]. Cohort data file created, debugging is almost complete. Will begin work on the google accelerator search soon.

1/25/2017 10:00-12:0004-11: Finished parser for cohort data of the Completed functional [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_LinkedIn_Crawler_(DataPython) Accelerator Seed List projectcrawler of LinkedIn Recruiter Pro]. Some data files still need proofreading as they are not in an acceptable format. Began working on Google sitesearch projectBasic search functions work and download profile information for a given person.

1/26/2017 14:30-17:45: Continued working on Google sitesearch project. Discovered crunchbase, changed project priority. Priority 1, split accelerator data up by flag, priority 2, use crunchbase to get web urls for cohorts, priority 3, make internet archive wayback machine driver. Located [http04-10://mcnair.bakerinstitute.org/wiki/Whois_Parser Whois Parser]Began writing functioning crawler of LinkedIn.

1/30/2017 10:00-1204-06:00Continued working on debugging and documenting the [http: Optimized enclosing circle algorithm //www.edegan.com/wiki/LinkedIn_Crawler_(Python) LinkedIn Crawler]. Wrote a test program that logs in, searches for a query, navigates through memoizationsearch pages, and logs out. Developed script to read addresses from accelerator data and return latitude Recruiter program can now login and longitude coordinatessearch.

1/31/2017 14:30-17:1504-05: Built WayBack Machine Began work on the LinkedIn Crawler. Updated documentation for coordinates script. Updated profile page to include locations of codeResearched on launching Python Virtual Environment.

2/1/2017 10:00-12:0004-03:Finished debugging points for the Enclosing Circle Algorithm. Added Command Line functionality to the Industry Classifier.

Notes 2017-03-29: Worked on debugging points for the Enclosing Circle Algorithm. 2017-03-28: Finished running the Enclosing Circle Algorithm. Worked on removing incorrect points from Session with Edthe data set(see above).  2017-03-27: Project Worked on US university patenting debugging the Enclosing Circle Algorithm. Implemented a way to remove interior circles, and entrepreneurship programs (writing code determined that translation to identify universities latitude and longitude coordinates resulted in assignees), search Wikipedia (XML then bulk download), student pop, faculty pop, etcslightly off center circles. 2017-03-23: Finished debugging the brute force algorithm for [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm]. Implemented a method to plot the points and circles on a graph. Analyzed runtime of the brute force algorithm. 2017-03-21: Coded a brute force algorithm for the [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm]. 2017-03-20: Worked on debugging the [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm]. 2017-03-09: Continued running [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] on the Top 50 Cities. Finished script to draw Enclosing Circles on a Google Map. 2017-03-08: Continued running [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] on the Top 50 Cities. Created script to draw outcome of the Enclosing Circle Algorithm on Google Maps. 2017-03-07: Redetermined the top 50 cities which Enclosing Circle project should be run on. Data on the [http://www.edegan.com/wiki/Top_Cities_for_VC_Backed_Companies Top 50 Cities for VC data will end up being Backed Companies can be found here.] Ran [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] on the Top 50 Cities. 2017-03-06: Ran script to determine the top 50 cities which Enclosing Circle should be run on. Fixed the VC Circles script to take in a joint project to join accelerator new dataformat. Pull descriptions 2017-03-02: Cleaned up data for the VCCircles Project. Founders Created histogram of accelerators data in linkedinExcel. See [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project. Began work on the [http://www.edegan.com/wiki/LinkedInCrawlerPython LinkedIn cannot be caught(pretend to not be a bot)Crawler]. Can eventually get academic backgrounds through linkedin 2017-03-01: Created statistics for the VC Circles Project. Pull business registration 2017-02-28: Finished downloading geocoded data, Sternfor VC Data as part of the [http://www.edegan.com/wiki/Guzman Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project. Found bug in Enclosing Circle Algorithm. GIS ontop 2017-02-27: Continued to download geocoded data for VC Data as part of the [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project. Assisted work on the [http://www.edegan.com/wiki/Industry_Classifier Industry Classifier]. 2017-02-23: Continued to download geocoded datafor VC Data as part of the [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project.Maps that works Installed C++ Compiler for Python. Ran tests on wiki or blog (CartoDB), Maps API difference between Python and RC wrapped Python.NLP Projects, Description 2017-02-22: Continued to download geocoded data for VC Data as part of the [http://www.edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project. Helped out with [http://www.edegan.com/wiki/Industry_Classifier Industry ClassifierProject].

2/2/2017 14:30-1502-21:45: Out sick, independent research and work from RDP. Brief research into Continued to download geocoded data for VC Data as part of the [http://jorgegwww.scriptsedegan.mit.educom/homepage/wp-content/uploads/2016/03wiki/Guzman-Stern-State-of-American-Entrepreneurship-FINAL.pdf Stern-Guzman algorithmEnclosing_Circle_Algorithm Enclosing Circle Algorithm]Project. Research Researched into C++ Compilers for Python so that the Enclosing Circle Algorithm could be wrapped in C. Found a recommended one [httphttps://mcnairwww.bakerinstitutemicrosoft.orgcom/en-us/wikidownload/interactive_maps Interactive Mapsdetails.aspx?id=44266 here]. No helpful additions to map embedding problem.

2/7/2017 14:30-1702-20:15Continued to download geocoded data for VC Data as part of the [http: Fixed bugs in parse_cohort_data//www.py, the script for parsing the cohort data from edegan.com/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project. Assisted work on the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List projectIndustry_Classifier Industry Classifier]. Added descriptive statistics to cohort data excel file.

2/8/2017 10:00-1202-16:00 Worked on Neural Net for the Reworked [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Industry_Classifier Industry Classifier ProjectEnclosing_Circle_Algorithm Enclosing Circle Algorithm]to create a file of geocoded data. Began work on wrapping the algorithm in C to improve speed.

2/13/2017 10:00-1202-15:00 Worked on Neural Net for the Finished [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Industry_Classifier Industry Classifier ProjectEnclosing_Circle_Algorithm Enclosing Circle Algorithm]applied to the VC study. Enclosing Circle algorithm still needs adjustment, but the program runs with the temporary fixes.

2/14/2017 -02-14:30-17:15: Worked on the application of the Enclosing Circle algorithm to the VC study. Working on bug fixes in the Enclosing Circle algorithm. Created wiki page for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm].

2/15/2017: 10:00-1202-13:00: Finished Worked on Neural Net for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmIndustry_Classifier Industry Classifier Project] applied to the VC study. Enclosing Circle algorithm still needs adjustment, but the program runs with the temporary fixes.

2/16/2017 14:30-1702-08:45: Reworked Worked on Neural Net for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmIndustry_Classifier Industry Classifier Project] to create a file of geocoded data. Began work on wrapping the algorithm in C to improve speed.

2/20/2017 10:00-1202-07:00: Continued to download geocoded Fixed bugs in parse_cohort_data.py, the script for parsing the cohort data for VC Data as part of from the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmAccelerator_Seed_List_(Data) Accelerator Seed List project] Project. Assisted work on the [http://mcnair.bakerinstitute.org/wiki/Industry_Classifier Industry Classifier]Added descriptive statistics to cohort data excel file.

2/21/2017 14:30- 1702-02:15: Continued to download geocoded data for VC Data as part of Out sick, independent research and work from RDP. Brief research into the [http://mcnairjorgeg.bakerinstitutescripts.orgmit.edu/homepage/wp-content/uploads/2016/wiki03/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmGuzman-Stern-State-of-American-Entrepreneurship-FINAL.pdf Stern-Guzman algorithm] Project. Researched Research into C++ Compilers for Python so that the Enclosing Circle Algorithm could be wrapped in C. Found a recommended one [httpshttp://www.microsoftedegan.com/en-uswiki/download/detailsinteractive_maps Interactive Maps].aspx?id=44266 here]No helpful additions to map embedding problem.

2/22/2017 10:00-1202-01:00Notes from Session with Ed: Continued Project on US university patenting and entrepreneurship programs (writing code to identify universities in assignees), search Wikipedia (XML then bulk download geocoded ), student pop, faculty pop, etc.Circle project for VC data will end up being a joint project to join accelerator data . Pull descriptions for VC Data as part . Founders of the [http://mcnairaccelerators in linkedin. LinkedIn cannot be caught(pretend to not be a bot).bakerinstituteCan eventually get academic backgrounds through linkedin.orgPull business registration data, Stern/wiki/Enclosing_Circle_Algorithm Enclosing Circle Guzman Algorithm] Project. Helped out with [http://mcnair GIS ontop of geocoded data.bakerinstituteMaps that works on wiki or blog (CartoDB), Maps API and R.org/wiki/Industry_Classifier Industry NLP Projects, Description Classifier Project].

2/23/2017 14:30-17:4501-31: Continued to download geocoded data for VC Data as part of the [http://mcnairBuilt WayBack Machine Crawler.bakerinstitute.org/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project. Installed C++ Compiler Updated documentation for Pythoncoordinates script. Ran tests on difference between Python and C wrapped PythonUpdated profile page to include locations of code.

2/28/2017 14:-01-30-17:15: Finished downloading geocoded Optimized enclosing circle algorithm through memoization. Developed script to read addresses from accelerator data for VC Data as part of the [http://mcnair.bakerinstitute.org/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Project. Found bug in Enclosing Circle Algorithmand return latitude and longitude coordinates.

3/1/2017 10:00-1201-26:00Continued working on Google sitesearch project. Discovered crunchbase, changed project priority. Priority 1, split accelerator data up by flag, priority 2, use crunchbase to get web urls for cohorts, priority 3, make internet archive wayback machine driver. Located [http: Created statistics for the VC Circles Project//www.edegan.com/wiki/Whois_Parser Whois Parser].

3/6/2017 10:00-1201-25:00Finished parser for cohort data of the [http: Ran script to determine the top 50 cities which Enclosing Circle should be run on//www.edegan.com/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]. Fixed the VC Circles script to take Some data files still need proofreading as they are not in a new data an acceptable format. Began working on Google sitesearch project.

3/7/2017 14:30-1701-24:15: Redetermined the top 50 cities which Enclosing Circle should be run on. Data Worked on parser for cohort data of the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Top_Cities_for_VC_Backed_Companies Top 50 Cities for VC Backed Companies can be found here.Accelerator_Seed_List_(Data) Accelerator Seed List project] Ran [http://mcnair.bakerinstituteCohort data file created, debugging is almost complete.org/wiki/Enclosing_Circle_Algorithm Enclosing Circle Algorithm] Will begin work on the Top 50 Citiesgoogle accelerator search soon.

3/8/2017 10:00-1201-23:00: Continued running Worked on parser for cohort data of the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmAccelerator_Seed_List_(Data) Accelerator Seed List project] on the Top 50 Cities. Created script to draw outcome of the Enclosing Circle Algorithm Preliminary code is written, working on Google Mapsdebugging.

3/9/2017 14:30-1701-19:45Downloaded pdfs in the background for the [http: Continued running //www.edegan.com/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project]. Created parser for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmAccelerator_Seed_List_(Data) Accelerator Seed List project] on the Top 50 Cities, completed creation of final data set(yay!). Finished script to draw Enclosing Circles Began working on a Google Mapcohort parser.

3/20/2017 10:00-1201-18:00: Worked on debugging Downloaded pdfs in the background for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmMoroccan_Parliament_Web_Crawler Moroccan Government Crawler Project].

3/21/2017 14:30-1701-13:15Continued making text files for the [http: Coded a brute force algorithm //www.edegan.com/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]. Downloaded pdfs in the background for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmMoroccan_Parliament_Web_Crawler Moroccan Government Crawler Project].

3/23/2017 14:30- 1701-12:45: Finished debugging Continued making text files for the brute force algorithm for [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Enclosing_Circle_Algorithm Enclosing Circle AlgorithmAccelerator_Seed_List_(Data) Accelerator Seed List project]. Implemented a method to plot Downloaded pdfs in the points and circles on a graphbackground for the [http://www.edegan. Analyzed runtime of the brute force algorithmcom/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project].

3/27/2017 10:00-1201-11:00Continued making text files for the [http: Worked on debugging //www.edegan.com/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project]. Downloaded pdfs in the Enclosing Circle Algorithmbackground for the [http://www. Implemented a way to remove interior circles, and determined that translation to latitude and longitude coordinates resulted in slightly off center circlesedegan.com/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project].

3/28/2017 14:30- 1701-10:15Continued making text files for the [http: Finished running the Enclosing Circle Algorithm//www.edegan. Worked on removing incorrect points from the data setcom/wiki/Accelerator_Seed_List_(see aboveData)Accelerator Seed List project]. Downloaded pdfs in the background for the [http://www.edegan.com/wiki/Moroccan_Parliament_Web_Crawler Moroccan Government Crawler Project].

4/5/2017 9:452016-12-1108:45Continued making text files for the [http: Began work on the LinkedIn Crawler//www.edegan. Researched on launching Python Virtual Environmentcom/wiki/Accelerator_Seed_List_(Data) Accelerator Seed List project].

4/6/2017 14:002016-12-17:1507: Continued working on debugging and documenting making text files for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_Accelerator_Seed_List_(PythonData) LinkedIn CrawlerAccelerator Seed List project]. Wrote a test program that logs in, searches for a query, navigates through search pages, and logs out. Recruiter program can now login and search.

42016-12-06: Learned how to use git. Committed software projects from the semester to the McNair git repository. Projects can be found at; [http:/10/2017 10www.edegan.com/wiki/E%26I_Governance_Policy_Report Executive Order Crawler], [http:00-12//www.edegan.com/wiki/Moroccan_Parliament_Web_Crawler Foreign Government Web Crawlers], [http:00: Began writing functioning crawler of LinkedIn//www.edegan.com/wiki/Accelerator_Seed_List_(Data) F6S Crawler and Parser].

4/11/2017 14:302016-12-1702:15: Completed functional Built and ran web crawler for Center for Middle East Studies on Kuwait. Continued making text files for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_Accelerator_Seed_List_(PythonData) crawler of LinkedIn Recruiter ProAccelerator Seed List project]. Basic search functions work and download profile information for a given person.

4/2016-12/2017 10:00-12:0001: Work on bugs with Continued making text files for the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_Accelerator_Seed_List_(PythonData) LinkedIn CrawlerAccelerator Seed List project]. Built tool for the [http://www.edegan.com/wiki/E%26I_Governance_Policy_Report E&I Governance Report Project] with Christy. Adds a column of data that shows whether or not the bill has been passed.

4/13/2017 14:302016-11-1729:45: Worked on debugging the logout procedure for Began pulling data from the accelerators listed [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_Accelerator_Seed_List_(PythonData) LinkedIn Crawlerhere]. Began formulation of process to search Made text files for founders of startups using a combination of the LinkedIn Crawler with the data resources from the [http://mcnair.bakerinstitute.org/wiki/Crunchbase_2013_Snapshot CrunchBase Snapshot]about 18 accelerators.

4/17/2017 10:002016-11-1222:00: Worked on ways Transferred downloaded Morocco Written Bills to provided SeaGate Drive. Made a "gentle" F6S crawler to get correct search results from the retrieve HTMLs of possible accelerator pages documented [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_Accelerator_Seed_List_(PythonData) LinkedIn Crawlerhere]. Worked on an HTML Parser for the results from the LinkedIn Crawler.

4/2016-11-18/2017 14:30-17:15Converted Executive Order PDFs to text files using adobe acrobat DC. See [http: Ran LinkedIn Crawler on matches between Crunchbase Snapshot and the accelerator data//www.edegan.com/wiki/E%26I_Governance_Policy_Report Wikipage] for details.

4/19/2017 10:002016-11-12:0017: Made updates Wrote a crawler to the retrieve information about executive orders, and their corresponding pdfs. They can be found [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_(Python) LinkedIn CrawlerE%26I_Governance_Policy_Report here.] Wikipage. Ran LinkedIn Crawler on accelerator data. Working on an html parser for Next step is to run code to convert the results from pdfs to text files, then use the LinkedIn Crawlerparser fixed by Christy.

4/20/2017 14:302016-11-17:4515: Finished the HTML Parser for the [http://mcnairdownload of Moroccan Written Question pdfs.bakerinstitute.org/wiki/LinkedIn_Crawler_(Python) LinkedIn Crawler]. Ran HTML Wrote a parser on accelerator founderswith Christy to be used for parsing bills from Congress and eventually executive orders. Data is stored Found bug in projects/accelerators/LinkedIn Founder Datathe system Python that was worked out and rebooted.

5/1/2017 13:002016-11-17:0011: Continued work on HTML Parserto download Moroccan data in the background. Uploaded all semester projects Attempted to git serverfind bug fixes for the [http://www.edegan.com/wiki/Accelerator_Seed_List_(Data) Accelerator Project] crawler.

<font size="5">'''Fall 2017'''<2016-11-10: Continued to download Moroccan data and Kuwait data in the background. Began work on [http:/font>/www.edegan.com/wiki/Google_Scholar_Crawler Google Scholar Crawler]. Wrote a crawler for the [http://www.edegan.com/wiki/Accelerator_Seed_List_(Data) Accelerator Project] to get the HTML files of hundreds of accelerators. The crawler ended up failing; it appears to have been due to HTTPS.

8/21/2017 14:002016-11-1708:00: Began work Continued to download Moroccan data in the background. Finished writing code for the embedded files on extracting founders for accelerators through LinkedIn Crawlerthe Kuwait Site. Spent time debugging the frame errors due to the dynamically generated content. Discovered Never found an answer to the bug, and instead found a workaround that Python3 is not installed on RDP, so the virtual environment sacrificed run time for the project cannot be fired upability to work. Continued working on Ubuntu machine[http://www.edegan.com/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web Driver]

8/22/2017 14:002016-11-1604:00: Discovered that LinkedIn Profiles cannot be viewed through LinkedIn if Continued to download Moroccan data in the target is 3rd degree or furtherbackground. However, if entering LinkedIn through a Google search, Finished writing initial Kuwait Web Crawler/Driver for the profile can still be viewed if Middle East Studies Department. Middle East Studies Department asked for additional embedded files in the user has previously logged into LinkedInKuwait website. Devising a workaround crawler that utilizes Google search. Continued blog post [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_(Python) hereMoroccan_Parliament_Web_Crawler Moroccan Web Driver] under Section 4.

8/23/2017 14:002016-11-1503:30: Decided with Ed Continued to abandon LinkedIn crawling download Moroccan data in the background. Dr. Egan fixed systems requirements to retrieve accelerator founder data, and instead use crunchbaserun the GovTrack Web Crawler. Spent Made significant progress on the day navigating Kuwait Web Crawler/Driver for the crunchbasebulk database, and seeing what useful information was contained in itMiddle East Studies Department.

8/24/2017 14:302016-11-1601:30: Began using Continued to download Moroccan data in the Crunchbase API to retrieve founder information background. Went over code for acceleratorsGovTracker Web Crawler, continued learning Perl. Halfway through compiling a dictionary that translates accelerator names into proper Crunchbase API URLs[http://www.edegan.com/wiki/Govtrack_Webcrawler_(Wiki_Page) GovTrack Web Crawler] Began Kuwait Web Crawler/Driver.

9/5/2017 14:002016-10-1621:00Continued to download data for the Moroccan Parliament Written and Oral Questions. Looked over [http: Post Harvey//www. Finished retrieving names from the Crunchbase API on foundersedegan.com/wiki/Christy_Warden_(Twitter_Crawler_Application_1) Christy's Twitter Crawler] to see how I can be helpful. Dr. Next step is Egan asked me to query crunchbase bulk database think about how to potentially make multiple tools to get linkedin urlscohorts and other sorts of data from accelerator sites. See [http://www.edegan. For more information, see com/wiki/Accelerator_Seed_List_(Data) Accelerator List] He also asked me to look at the [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Crunchbase_Data hereGovtrack_Webcrawler_(Wiki_Page) GovTrack Web Crawler]for potential ideas on how to bring this project to fruition.

9/6/2017 14:002016-10-1520:30: Combined founders Continued to download data retrieved with for the Crunchbase API Moroccan Parliament Written and Oral Questions. Updated Wiki page. Started working on Twitter project with the crunchbasebulk data to get linkedin urls for different accelerator foundersChristy. For more information, see [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Crunchbase_Data hereMoroccan_Parliament_Web_Crawler Moroccan Web Driver].

9/11/2017 14:002016-10-1718:00: Continued working on Finished code for Oral Questions web driver and Written Questions web driver using selenium. Now, the data for the dates of questions can be found using the crawler, and the pdfs of the questions will be downloaded using selenium. [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_(Python) LinkedIn Crawler for Accelerator Founders DataMoroccan_Parliament_Web_Crawler Moroccan Web Driver].

9/12/2017 2016-10-14:00-16:00: Continued working Finished Oral Questions crawler. Finished Written Questions crawler. Waiting for further details on whether that data needs to be tweaked in any way. Updated the Moroccan Web Driver/Web Crawler wiki page. [http://mcnairwww.bakerinstituteedegan.orgcom/wiki/LinkedIn_Crawler_(Python) LinkedIn Crawler for Accelerator Founders DataMoroccan_Parliament_Web_Crawler Moroccan Web Driver]. Added to the wiki on this topic.

9/2016-10-13/2017 14:00-15:30: Implemented LinkedIn Completed download of Moroccan Bills. Working on either a web driver screenshot approach or a webcrawler approach to download the Moroccan oral and written questions data. Began building Web Crawler for main portion of profilesOral and Written Questions site. Edited Moroccan Web Driver/Crawler wiki page. [http://www. Began working on crawling Experience section of profilesedegan.com/wiki/Moroccan_Parliament_Web_Crawler Moroccan Web Driver]

9/14/2017 13:302016-10-1511:30: Continued implementing LinkedIn Crawler Fixed arabic bug, files can now be saved with arabic titles. Monarchy bills downloaded and ready for shipment. House of Representatives Bill mostly downloaded, ratified bills prepared for download. Started learning scrapy library in python for profilesweb scraping. Discussed idea of screenshot-ing questions instead of scraping.

9/18/2017 14:002016-10-17:0007: Finished implementation of Experience Crawler, continued Learned unicode and utf8 encoding and decoding in arabic. Still working on Education Crawler for LinkedIntransforming an ascii url into printable unicode.

9/19/2017 14:302016-10-1606:30: Began running linkedin Discussed with Dr. Elbadawy about the desired file names for Moroccan data download. The consensus was that the bill programs are ready to launch once the files can be named properly, and the questions data must be retrieved using a web crawlerwhich I need to learn how to implement. Helped Yang create RDP accountThe naming of files is currently drawing errors in going from arabic, get permissionsto url, and get wiki setupto download, to filename. Debugging in process. Also built a demo selenium program for Dr. Egan that drives the McNair blog site on an infinite loop.

9/20/2017 14:002016-10-1503:30: Finished running linkedin crawlerMoroccan Web Driver projects completed for driving of the Monarchy proposed bills, the House of Representatives proposed bills, and the Ratified bills sites. Begun process of devising a naming system for the files that does not require scraping. Tinkered with naming through regular expression parsing of the URL. Transferred data Structure for the oral questions and written questions drivers is set up, but need fixes due to RDPthe differences in the sites. Will write wikis nextFixed bug on McNair wiki for women's biz team where email was plain text instead of an email link. Took a glimpse at Kuwait Parliament website, and it appears to be very different from the Moroccan setup.

#TODO2016-09-30: Write wiki on linkedin crawlerSelenium program selects view pdf option from the website, write wiki on creating accountsand goes to the pdf webpage. Program then switches handle to the new page. CTRL S is sent to the page to launch save dialog window. Text cannot be sent to this window. Brainstorm ways around this issue. Explored Chrome Options for saving automatically without a dialog window. Looking into other libraries besides selenium that may help.

9/21/2017 142016-09-29:00Re-16:00: Wrote wiki enroll in Microsoft Remote Desktop with proper authentication, set up Selenium environment and Komodo IDE on Linkedin crawlerRemote Desktop, met with Laura about patents projectwrote program using Selenium that goes to a link and opens up the print dialog box. Developed computational recipe for a different approach to the problem.

9/25/2017 14:002016-09-1726:00: New task -- Create text file with companySet up Staff wiki page, work log page; registered for Slack, descriptionMicrosoft Remote Desktop; downloaded Selenium on personal computer, and company typeread Selenium docs.#[http://mcnair.bakerinstituteCreated wiki page for Moroccan Web Driver Project.org/wiki/VC_Database_Rebuild VC Database Rebuild]#psql vcdb2#table name, sdccompanybasecore2#Combine with Crunchbasebulk

9/27/2017 14:00-16:00: Worked on big database file.9/28/2017 13:30-15:30: Added collaborative editing feature to PyCharm. 10/1/2017 14:00-17:00: Worked on ArcGIS data. See Harrison's Work Log for the details.10/3/2017 14:00-16:00: Emergency ArcGIS creation for Agglomeration project.10/4/2017 14:15-15:45: Emergency ArcGIS creation for Agglomeration project.==''Notes=='''