I'm trying to extract project relevant information via web scraping using Python+ Spacy and then building a table of projects with few attributes , example phrases that are of interest for me are:
- The last is the 300-MW Hardin Solar III Energy Center in Roundhead, Marion, and McDonald townships in Hardin County.
- In July, OPSB approved the 577-MW Fox Squirrel Solar Farm in Madison County.
- San Diego agency seeking developers for pumped storage energy project.
- The $52.5m royalty revenue-based royalty investment includes the 151MW Old Settler wind farm
Here I have highlighted different types of information that I'm interested in , I need to end up with a table with following columns : {project name} , {Location} ,{company}, {Capacity} , {start date} , {end Date} , {$investment} , {fuelType}
I'm using Spacy , but looking at the dependency tree I couldn't find any common rule , so if I use matchers I will end up with 10's of them , and they will not capture every possible information in text, is there a systematic approach that can help me achieve even a part of this task (EX: Extract capacity and assign it to the proper project name)