Write code to parse and filter uspto patent bulk data into excel
$10-30 USD
Completed
Posted over 5 years ago
$10-30 USD
Paid on delivery
I need code to parse [login to view URL] patent bulk data into excel. The bulk data I need to parse weekly can be found here: [login to view URL]
I need the patents filtered so that the specification includes microprocessor cpu microcontroller or "micro controller". Also the assignee name needs to match the inventor [login to view URL] the inventor country needs to be usa
I need to be able to run the code myself on a weekly basis.
The data is similar to xml but it is not exactly so excel will not import the data natively.
The data i want in the excel file is the inventor name, city, state and country, assignee name, city, state and country, the patent number and the specification.
I checked the xml file and I can filter the data on specifications, name and country and output the results in desired format.
I have excellent hold on MS Excel and VBA and have parsed xml data before.
$150 USD in 4 days
4.9 (64 reviews)
5.5
5.5
9 freelancers are bidding on average $395 USD for this job
Hello Sir,
I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 395 + projects with 100% client satisfaction.
I can help you with Write code to parse and filter uspto patent bulk data into excel
I have more than 5 years of the experience in Excel, Excel VBA, Programming, XML
Please ping me for more discussion.
Thanks.
I can provide you web scraping script that will visit above website, download zip archive, unzip it, parse XML and save output into your Excel file.
You can use it on weekly basis to get updated information from bulkdata.uspto.gov.
I can complete it in less than 3 days for just $450.
Hello Sir I can perform the task as per ur requirement and deliver you the expected results. Since I want to start working as a freelancer. I will give you a sample XML file from where I have done something similar.
i use various programming languages like R, Python and VBA macro in my daily work. mainly involved in implementing through languages which can do automatically and in a smoother an faster way.
i surely can help you in this project .