About

I need to extract data from a public webpage and populate 2 fields in the attached Excel file. Source data: https://policy.ideas-lab.ca/submission-index/ Table structure -ID (provided) -Riding (Provided) -Sponsoring EDA (https://policy.ideas-lab.ca/submission-index/ top page -Cosponsoring EDA (click on the Title page, and scrape the "Sponsoring Riding" field. The goal is to calculate each EDA's total number of sponsored and co-sponsored proposals. IMPORTANT: * Please only submit a proposal if you can complete this task in the next few hours. * If I receive a proposal containing an extract from the completed file I will immediately award the project. * The budget is low because this is a volunteer driven exercise and I'm paying out of pocket. I will provide an excellent review for accurate and rapid delivery. Thanks for your interest! I need to generate a table based on records in the attached CSV file. I want to know how many proposals a riding as sponsored and how many times a riding has co-sponsored a proposal. So three columns. Riding, # sponsored, # co-sponsored. The # sponsored is from this link: Submission Index – PoliTo get the # of co-sponsored proposals by riding, click on each Title and scrape the contents of the co-sponsoring ridings field. The riding names are separated by column. on records in the attached CSV file. I want to know how many proposals a riding as sponsored and how many times a riding has co-sponsored a proposal. So three columns. Riding, # sponsored, # co-sponsored. The # sponsored is from this link: Submission Index – PoliTo get the # of co-sponsored proposals by riding, click on each Title and scrape the contents of the co-sponsoring ridings field. The riding names are separated by column.